MAX, Lookup and count showing wrong value

[wildecoyote1966]

I am having an issue with MAX, lookup and count.

Cell H1 has

Please Login or Register  to view this content.

, Cell I1 has

Please Login or Register  to view this content.

and Cell J1 has

Please Login or Register  to view this content.

and they appear to work fine

however in Cell H2 has

Please Login or Register  to view this content.

, Cell I2 has

Please Login or Register  to view this content.

and Cell J2 has

Please Login or Register  to view this content.

and they show incorrect values

[TMS]

Try:

Please Login or Register  to view this content.

[wildecoyote1966]

in which cell

[TMS]

I2 highest profit date.

[wildecoyote1966]

Thanks TMS

[TMS]

You're welcome. Thanks for the rep.