Perhaps post a sample sheet? ( Go Advanced - Manage attachments)


Did you commit the formula correctly?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Never mind, found the issue, thank you for your time and help!
Now is it possible to add another column of data to the formula as an added step for filtering the results?

E.g.
In the provided spreadsheet could I also have the formula filter for only those that have TRUE in column C.

Attached Files

FormulaTestSheetASL.xlsx (9.1 KB, 18 views)