Insert row number into a cell?
On Fri, 30 Dec 2005 10:37:52 +1100, Govind wrote:
Hi,
Modify your formula to
=IF(flat!A1=255,row(A1),0)
and copy it down to the array to return the row number.
Regards
Govind.
CR Optiker wrote:
=IF(flat!A1=255,$A1,0)
Govind...thank you very much.
Optiker
|