Example.xlsxHi,
I wondered if anyone is able to assist. I would like Excel to display a cell range if another cell range meets a certain criteria. Attached is the spreadsheet and the data I wish to work with. Essentially this is what I am trying to achieve but I am a complete beginner when it comes to Formula and VBA.
If I was to write it in my thought process it would be like something like
If Cell range N5:O10 contains text "N" then display all results that corrospond to "N" in the adjacent cell range I5:J10 but ingnore cells if they contain the text "[New Date]" and "Example". Display all these results in Cells A3 onwards. Using the example attached, the results I would expect to see are located in Cells A3:D4
I hope that makes sense. I appreciate all efforts and any help that you are able to share.
Thanks!
Karo
Bookmarks