anthonyexcel
Active Member
- Joined
- Jun 10, 2011
- Messages
- 258
- Office Version
- 365
- Platform
- Windows
I have some sample data that I AutoFilter. (My real data is about 100000 rows) I need to keep a running total on the data. The formula I use normally is =COUNTIF($B$2:B2,B2) . I know that that will not work with filtered data. The criteria is 111 and B
As you can see gives not the desired results: The desired result would be 1, 2 ,3
Any help would be appreciated!
|
As you can see gives not the desired results: The desired result would be 1, 2 ,3
|
Any help would be appreciated!