How do I find a value in a row of formulae

[ouadad]

I have a row that contains 5000 values based on formula that I see when I highlight the cell. I can find the max and min values, but I don't know where they are in the row. When I execute a Find, it tells me it can't find the data. Is there a simple way to go about this?

 

[MARK858]

In the Find options is the "Look in" set to values or formulas?

 

[ouadad]

Thank you