Forum

Hi Ravikiran, Based on your expected values, you don't need to check if it's a buy or sell, it's a simple formula taking the closing prices minus t...

Hi Richard, Welcome to our forum! Add a custom column that checks if column B is empty. If it is, bring in the car park name, otherwise return n...

Hi Bruno, It's in the zip file you downloaded with all the other practice files etc. You'll find it in the 'Practice Files' folder and it's called ...

Hi James, The best thing you can do is create a mock up with a sample of your 70 classifications and some dummy data you want to classify, and some...

Hi Nelson, Correct, no need for SQL. However, I can't predict whether you'll have performance issues with that many workbooks that are all differen...

Hi Nelson, Welcome to our forum! It would be helpful if you were specific about the number of workbooks, but I'd say you have the following options...

Hi Aye, With dynamic arrays: =COUNT(UNIQUE(FILTER($B$2:$B$26,$A$2:$A$26=A34))) Mynda

Hi Trevor, I'd be inclined to ignore the DST time changes because trying to handle them only introduces more issues that are worse in my opinion. ...

Hi James, Welcome to our forum! Maybe you could use Power Query to do a merge with another table that contains all the scenarios/criteria. When ...

Hi Victor, My original suggestion works: "Try setting the field to 'show items with no values' (in the field settings), so that even if there is a ...

Hi Maria, The formula is calculating correctly. The last value in your sales table for 2020 is on 26th October, not 28th. Also, you can't look at t...

Hi Bruno, Change the week number format to yyyy_mm as text i.e. January 2020 looks like this: 2020_01. The zero in front of the 1 is important for ...

Hi Victor, Can you share the file, or at least a sample file? Mynda

In that case you'd use column F in your lookup table and then rank these job titles numerically and, or with the hierarchy code you displayed in colum...

Correct.