Forum Widgets
Latest Discussions
Use Form to update data
When the command button New Record is clicked the user enters a value into a Form which will then be entered into F7 (or the next available empty cell in F) When the user clicks OK E7 is then updated with Todays date Followed by Filldown formulas in I6 and J6 to the next row Followed by copy cell J2 and past in to K7 End I have included a sample sheet to help explain what I am wanting to do. All and any help will be greatly appreciated. Thanks Summary Form.xlsxpackieJan 19, 2025Brass Contributor6Views0likes1CommentSorting Recurring Expenses?
Hello, I don't use Excel much and I'm having trouble trying to do something that seems so simple. I've searched and searched and can't find an answer. I've prepared a very simple worksheet for monthly recurring expenses. These expenses are typically due the same date each month (1st, 10th, 15th, etc.). How should I be entering those dates so I can sort the list on that? Ultimately, I'd like to sort the expenses bi-weekly to coincide with my pay periods. Thanks! LyleLyleJJan 19, 2025Copper Contributor16Views0likes1CommentFilter result to skip selected columns
Hi all Question - when outputting a filter, can selected columns be skipped in the output? Please see my example spreadsheet. I basically want to skip column H and have the total populate in column I instead. Is this possible please? Thanksmatt0020190Jan 19, 2025Brass Contributor60Views0likes3CommentsProblem with MS office on apple mac
I had a problem with mail on apple, went to their support and they said before anything else I needed to update to the latest version Sonoma. This I did and problem in mail solved. However, I now have a problem with opening office files. In particular, Word and Excel Keep getting permissions needed notices if I try to open from any “recent files” drop downs If I go to the root directory for the file and double click the files will open albeit very slowly. Having opened them in this way I can then reopen them in recent files in finder again albeit slowly, but not recent files in office. Visited apple store and they checked it over and couldn’t see any obvious apple problems. Permissions are on etc. They then reinstalled office but still the same. Have since contacted MS support again they tried a few thigs including reinstalling office, this time from MS account and not from my installer file on the computer. Still no change. The last chance seems to be to completely scrub my Mac book and start again Apple store have said that may be the only way if there is no known problem of this nature. Before I do just want to make sure that there isn’t any history like this or a known fix7063412656Jan 19, 2025Copper Contributor49Views0likes1CommentIs there a formula / function for displaying the "Name" of a reference cell?
I am trying to see if there is an Excel function to display the "Name" of another cell. I looked through all of the options using the =CELL() function (there are many) but none seem to return the "Name" that I have given the cell. I have used reference names in several places within my spreadsheet to simplify formulas and make them more readable, but I would like to have a dictionary of these referenced inputs including what each one is named in a separate tab. Any pointers are appreciated.SgreeverJan 19, 2025Copper Contributor45Views0likes2CommentsWhat do you think of thunks?
OK, so the most likely response by far is going to be "I don't". However, I tried one of Omid Motamedisedeh's regular challenges and found it a suitable problem for exploring some of the lesser known byways of modern Excel. The challenge is to pick out locally maximum values from a rolling range. What I did was to write a function that used MAP to select one cell at a time, using DROP to remove the initial cells and TAKE to return a range of 5 cells with the active cell in the middle. The direct route to solving the stated problem would be to calculate the maximum value within each range immediately, but I was interested in the more general problem of "could I return the array of ranges in a form that would support further analysis?" As shown, the following formula ROLLINGRANGEλ = LAMBDA(values, n, LET( rows, SEQUENCE(ROWS(values)), MAP(rows, LAMBDA(k, LET( m, QUOTIENT(n, 2), rng, TAKE(DROP(values, k - m - 1), MIN(k + m, n)), rng ) ) ) ) ); gives and array of ranges error, but simply by enclosing the 'rng' variable within a further LAMBDA ... LET( m, QUOTIENT(n, 2), rng, TAKE(DROP(values, k - m - 1), MIN(k + m, n)), LAMBDA(rng) ) will cause Excel to return an array of functions, each one of which would return a range if evaluated. In the attached workbook, a number of formulae are based upon this array of functions = ROLLINGRANGEλ(dataValues, 5) = MAP(ROLLINGRANGEλ(dataValues, 5), LAMBDA(ϑ, ROWS(ϑ()))) = MAP(ROLLINGRANGEλ(dataValues, 5), LAMBDA(ϑ, ISREF(ϑ()))) = MAP(ROLLINGRANGEλ(dataValues, 5), LAMBDA(ϑ, AVERAGE(ϑ()))) = MAP(ROLLINGRANGEλ(dataValues, 5), dataValues, LAMBDA(ϑ,v, MAX(ϑ()))) = LET( rollingMax, MAP(ROLLINGRANGEλ(dataValues, 5), LAMBDA(ϑ, MAX(ϑ()))), FILTER(Data, rollingMax=dataValues) ) The first simply returns #CALC! errors on the worksheet which is the normal response to a Lambda function defined on the grid. The second formulas uses ROWS to show that the ranges are not all the same size, the third shows the returned objects to be range references and not simply arrays of numbers, the forth is a rolling average while the fifth is a rolling MAX. The final formula returns the solution to the problem, being a filtered list. The purpose of this post is to demonstrate that Excel, which started out as a 'simple' spreadsheet program, now contains a very different programming environment that shares a function library and uses the grid for input/output but, other than that, has very little in common with 'normal' spreadsheet practice! A related survey can be found at https://www.linkedin.com/feed/update/urn:li:activity:7285432559902068736/PeterBartholomew1Jan 19, 2025Silver Contributor46Views1like1CommentIFS or anyother function
Dear Experts, I have a data like below:- So, Column "B" - sfn can go from 0 ~ 1023, and Column-"C", can go from 0~19, Column "G" has 3 values(rnti's) - Now, we have only 2 situations like below in Column"E", where I need the formula:- Either all these 3 rnti's can be Multiplexed in the same sfn.slot So, in below snip all 3 rnti's are FDMed in same sfn.slot - 394.6 and should be continuous, so Column "E" should have fdm-3 But in below instance, in 395.2 we have only 2 rnti's multiplexed(so fdm-2 should be populated) Attached is the spreadsheet. Thanks in Advance, Br, AnupamSolved75Views0likes5Comments- MITHUNBMJan 19, 2025Copper Contributor20Views0likes2Comments
Spreadsheet Compare Highlight Function
Hello I would like to know if rows can be highlighted in the compared files using the Spreadsheet Compare program. I want the rows changed, rows deleted and the rows with entered values changed highlighted in different colors respectively on the compared sheets by the Spreadsheet Compare program itself. Is it possible? Basically, the Spreadsheet Compare program takes in two spreadsheets - Old Data and New Data. I want the added rows detected in the new data sheet to be highlighted green, the changed rows should be highlighted yellow in the new data sheet and the deleted rows should be highlighted red in the old data sheet. I would like to know if there's any way to accomplish this using Spreadsheet Compare or any external method. I'd greatly appreciate any help! Thanks!24Views0likes2CommentsInsert Options button on Mac
Hi, I want to insert a new column in a table. However, I want that column to be blank. Thus, I must use the "Insert Options" button after I have inserted the column. I cannot find this button / it doesn't show. I have checked so that "Show Insert Options" is turned on in settings. I use Mac. How can I find this button? //FilipFilipDevalliusJan 19, 2025Copper Contributor21Views0likes1Comment
Resources
Tags
- Excel42,019 Topics
- Formulas and Functions24,357 Topics
- Macros and VBA6,330 Topics
- office 3655,901 Topics
- Excel on Mac2,606 Topics
- BI & Data Analysis2,315 Topics
- Excel for web1,868 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,602 Topics