Generating a Record Number when another cell is not blank

[Mettaya1]

I can't get this simple function to work.
I know that;

=ROW($A2)-1

Returns the row number just fine if I write it into the cell and drag it.

As I prefer to use conditional formatting if a cell is doing something I am trying to make the following work.

=IF(($B2)<>"",ROW($A2)-1)

I need the row number to be the actual record and not include the first row which is a heading hence the -1.

Regards

Steve

 

[azumi]

For actual numbering if the cell is non blank, try this:

Must be input in cell A2:
=IFERROR(IF(B2="","",COUNTIF($A$1:A1,">0")+1),"")

and try it fill up data on Column B, and try to skip it with blank

 

[liveinhope]

I'm not sure what you are trying to do here. Do you want to

enter a formula in another column eg "C" that returns the row# if "B" is non-blank ?

OR

format a column (any column A,B,C , etc ) based on the value in "B" ? eg make Cell A2 bold if Cell B2 is not blank
[TABLE="width: 218"]
<TBODY>[TR]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]

<TBODY>
</TBODY>

[/TD]
[/TR]
[TR]
[TD="align: right"]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
</TBODY>[/TABLE]

 

[azumi]

The formula copied down as necessary

 

[Mettaya1]

The formula copied down as necessary

Hi,
What I am trying to do is replace the Row numbers with a generated Record Number.

The First Row (1) is used by the headings and if I need to move a record up or down I have to manually change all the record numbers.
I want to use a function that in Column A generates the correct record number

 

[Mettaya1]

Would be nice to have a function that I can use in conditional formatting