Hi Alan,

Thanks for response. My problem is in fact the inverse of your proposed
solution. However, I think I have found a solution, rather than comparing A1
with a variable row from the range A2-A10, I can compare the specific row,
say A7 with A1, placing the function in a cell in the variable row.

"Bryan Gnidrah" wrote:

I have a worksheet in which I want to compare the data in one cell (A1) with
that in another cell. The cell which is to be compared against is immediately
beneath A1 but being one of several which will be filtered, may not be Cell
A2. It could be any one of cells A2 - A10 for example. Can any one help me in
creating a function?