vikas_newports
Board Regular
- Joined
- May 26, 2016
- Messages
- 121
- Office Version
- 365
- Platform
- Windows
Hello
I have more than 50000 records in my sheet and I am using the below formula to count the running occurrence of record
but it hangs my system and takes more than 5 min to run the formula
Is there any way to fast this process?
Prefer option is simple excel, the other option is VBA for solution
I have more than 50000 records in my sheet and I am using the below formula to count the running occurrence of record
Excel Formula:
=COUNTIF($A$2:A2,A2)
but it hangs my system and takes more than 5 min to run the formula
Is there any way to fast this process?
Prefer option is simple excel, the other option is VBA for solution