Sequential Numbering Positive/Negative Amounts
Results 1 to 2 of 2

Thread: Sequential Numbering Positive/Negative Amounts
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Nov 2006
    Posts
    916
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Sequential Numbering Positive/Negative Amounts

    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 by neodjandre; Jun 28th, 2019 at 06:18 AM.

  2. #2
    Rules violation
    Join Date
    Jan 2012
    Posts
    912
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sequential Numbering Positive/Negative Amounts

    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 by theBardd; Jun 28th, 2019 at 06:37 AM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •