# Sequential Numbering Positive/Negative Amounts

#### neodjandre

##### Well-known Member
Hey all,

I have column A containing positive and negative numbers and I am looking for a formula in column B for sequential numbering as follows

col A col B
20 PS001
32 PS002
20 PS003
-20 NE001
10 PS004
20 PS005
-10 NE002
10 PS006

Could this be done without an array formula? Can't seem to figure it out although it could be easy enough for someone smarter than me?

many thanks,
Andrew

Last edited:

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

#### theBardd

##### Rules violation
Yes

Code:
``=IF(A2>0,"POS"&TEXT(COUNTIF(\$B\$1:\$B1,"POS*")+1,"000"),"NEG"&TEXT(COUNTIF(\$B\$1:\$B1,"NEG*")+1,"000"))``

Last edited:

1,102,262
Messages
5,485,740
Members
407,511
Latest member
Arunabh

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
• Please i need your help to create formula
I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
• Got error while adding column and filter
Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...