View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RC RC is offline
external usenet poster
 
Posts: 39
Default Restart row count each time the value in a specific column changes

Is there a formula that will restart the row count when the value in a
specific column changes --- such as shown below when the value in column A
changes the row count in column B restarts?

A B
1 452 1
2 452 2
3 452 3
4 452 4
5 329 1
6 329 2
7 548 1
8 548 2
9 548 3

Thanks in advance

--
RC