Hi,
I would like to know how I can find the cells that meet the following criteria in the attached spreadsheet. I want to find when there is a difference of between .93 and 1.03 both negative and positive between column C and column E and find the cells in colum A when this criteria has been met. So for example, cell A10 should be signaled out somehow (either highlighted or the other data could be parsed and just have the rows that meet the criteria or anything that would be faster than doing it manually). A21, A248, A266, A356 and A374 are the only returns that I would like. How can I achieve this?
Thank you for all your help.
Bookmarks