Hi,

First post so hope this is ok.

I have a large row & column of numbers (stock market figures).

Example:
A B C D E F G etc
1 11532 11530 11485 11448 11483 11492
2 11477 11469 11442 11405 11414 11472
3
4
5 Value:

Highest limit: 11542
Lowest limit: 11462

I would like the highest or lowest limit VALUES (11542 OR 11462) to show in the corresponding cell when it is matched. I only want this to show the first time it gets matched.

In this example the value would be 11462 and show in D5 .

Any help on this would be much appreciated.

Simon