View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CR Optiker
 
Posts: n/a
Default 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