Hello all, this problem has been bothering me for days so Im really hopeful someone here can help. (Ive attached a sample workbook with additional notes)
In a nutshell Im looking to search a list of invoice numbers in Column B for any that have the - Finished flag on them. However where it gets too hard for me is the fact Im looking to do this search from the bottom of column B to the top of column B and return all the results that have the - Finished flag.
Quick data without the sample workbook.
982
145
353 - Finished 23/08/22
876
904
123 - Finished 01/08/22
353
991
402
321 - Finished 18/07/22
678
609
297 - Finished 30/07/22
558
Result desired (note these are not in date order but merely results taken from the bottom of the column up to the top of the column, when the - Finished flag is present)
297 - Finished 30/07/22
321 - Finished 18/07/22
123 - Finished 01/08/22
353 - Finished 23/08/22
Bookmarks