LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Sequential numbering when X column repeats records

I have excel file that has 2 rows

Row 1 has records
A
A
A
B
B
C
A
Row 2 need to have the number of times row one repeats a record.
Something like this
1
2
3
1
2
1

Any formula that will find records on column one and sequentially number
column B depending on amount of records?

Thank you

-RoMo
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove Sequential Repeats Jakobshavn Isbrae Excel Discussion (Misc queries) 2 February 9th 09 03:27 PM
sequential numbering Connie Excel Discussion (Misc queries) 2 June 20th 08 09:50 PM
PO with sequential numbering with start / end numbering [email protected] Excel Discussion (Misc queries) 1 April 24th 07 03:38 PM
Sequential Numbering Mel Excel Discussion (Misc queries) 10 May 9th 06 03:12 PM
Populate column in sequential order by number of records araki Excel Discussion (Misc queries) 1 April 28th 06 07:13 PM


All times are GMT +1. The time now is 12:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"