Last seen: Aug 26, 2025
I tested the first two formulas in the worksheet and didn't get the missing parenthesis error. Though, the 'Completed' formula has a few typo's in it....
I've entered a formula in the table that produces 0 or 1 in line with the required result FALSE or TRUE. Though, it also returns 0 (i.e. FALSE) if the...
There is no attachment. Please try again and press the 'Start upload' and wait until finished, before you submit your reply.
Made some changes to the file in order to make it work as you intended. Some comments, though. 1) The dates in the 2nd table were all from the year...
I had a look at your file as well and noticed that both slicers in the Analysis tab were set to display both Income and Expense. Around 13:30 in the v...
Great! Mystery solved then!
Hi, Can you please upload a file so that we don't have to guess about what you are trying to do. I pasted your formula in an empty sheet with some dat...
Doing what Alan suggests created the functions in B2 and C2 (i.e. =A2.Name and =A2.[Official name], respectively). A2 is a relative cell reference ...
I've used Excel MS365 Insider/Beta, version 2403 but the solution provided should work on older versions as well.
The attached file contains a query that does what you ask for. In the Advanced editor you can follow the applied steps. Quite a few of them I'm afraid...
Great to see you worked out a solution. Now with respect to naming the series and why the legend isn't there on the second chart, that's easily resolv...
Where does the data come from to begin with? If with Power Query, you can load it back to an Excel table AND the Data Model.
I reconstructed your table came up with the following formula to return the desired answer: =INDEX(SORT(FILTER(Table10,(Table10[DEVELOPED LG]>I2...
Thank! That worked and I could delete the other attachment for you. Not sure I fully understood your questions, but please have a look at the attac...
"How is the winter in Sweden?" Cold and much snow!