Hello
I am trying to use match to search a row for a date and return the position of the last value of that date. For example I am trying to search for 07/10/10 in the 2nd row but the first few instances of it don't have the correct data below it, so I need to find the last instance of it. Does that make sense?
I am currently trying to make a loop so it will find the date and if the cell below it is 0, it finds the next cell etc but surely there is a more efficient way that I don't know of
Thanks
Bookmarks