Hi All,
I need a formula to INDEX MATCH with an if statement to then return the results in alphabetical order
Therefore, if my listed data (task names) is in range A3:A500 and if there is a value (I.e. <>"") in B3:B500 (task frequency) then I need in D3:D500 to return the (task names) from A3:A500 in alphabetical order
Bookmarks