LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sam Sam is offline
external usenet poster
 
Posts: 1
Default Adding Counter to column for number of identical file numbers

Is there a formula or easy way to add a counter to a file? For example
if I have a file number that appears on a file 2 times and another 3
times and another 5 times I get the following results.

Column (A) Column (B)
File Number Results
9565845 1
9565845 2

9552456 1
9552456 2
9552456 3

5695695 1
5695695 2
5695695 3
5695695 4
5695695 5
 
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
Adding up cell values only with identical info in other cells rarch1 Excel Worksheet Functions 9 February 11th 08 04:54 PM
adding numbers from column B, while condition on column A The Fool on the Hill Excel Discussion (Misc queries) 4 February 1st 07 01:34 PM
Adding a % value to a column of numbers Morefeus Direct Excel Worksheet Functions 9 September 16th 06 09:41 PM
Adding to a column of numbers Colleen Excel Worksheet Functions 1 January 4th 06 06:26 AM
column filtering to match identical numbers sammc2 Excel Discussion (Misc queries) 1 July 14th 05 11:59 PM


All times are GMT +1. The time now is 04:41 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"