#### imported_unknown

##### Active Member

- Joined
- Jan 13, 2002

- Messages
- 424

This is my very first time here ... found it through a Search Engine, so hope I am using the write forum to ask this question??

I am trying to create a formula that will do the following, and I am getting myself all tied up with it ... it's driving me nuts

What I want to do is have the formula look for the highest figure among 10 cells.

Rather than return the highest value (ie using MAX) I'd like it to return the text that is in the cell 9 rows immediately above it.

There will be times however that there will be more than one cell with exactly the same highest figure, in which case, to get to the above result, I will need the formula to work out which of the equal highest cells in value is closest numerically (by referring to a number in a cell adjacent to it)to the figure in a cell on another sheet within the workbook.

Gee, this is hard to explain. I hope that all makes sense?

Anyway, I might leave it here and see what response I get as to whether I need to explain something in greater detail or if I am barking up an unclimbable tree so to speak.

Thank you most sincerely for any help or advice and I look forward to hearing from you all.

Thanks again