VBA learner ITG
Active Member
- Joined
- Apr 18, 2017
- Messages
- 272
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi all,
This should be something easy to sort.
But I have gone formula crazy after staring at the screen for so long i cannot figure out why my formula is not outputting correctly,
I have done everything in terms of recreating a new formula, google search and now i need your expertise if possible.
As you can see from the link to the spreadsheet the Countif should be creating a sequence number for all grouped values but for some reason its restarting after it hits 27 in the number sequence.
Any ideas to why this would be?
File In question
This should be something easy to sort.
But I have gone formula crazy after staring at the screen for so long i cannot figure out why my formula is not outputting correctly,
I have done everything in terms of recreating a new formula, google search and now i need your expertise if possible.
As you can see from the link to the spreadsheet the Countif should be creating a sequence number for all grouped values but for some reason its restarting after it hits 27 in the number sequence.
Any ideas to why this would be?
File In question