Good afternoon all,
I'm sorry if this has been answered already, but I am in desperate need of a more efficient way to count first occurrences in a workbook I frequently use. I am currently using the following:
=IF(MATCH($J2,$J$2:$J2,0)+1=ROW($J2),1,0)
Once this calculation is made for all the data entries, I use the following on a summary sheet to return the right quantity.
=COUNTIFS($J$2:$J:$1000000),1$J$R:$R:$1000000,"Non RTV",$Q$2:$Q:$1000000,"PAIR",$C$2:$C:$1000000,101,$O$2:$O:$1000000,"Cross Dock")
Since this workbook is typically between 40K and 60K rows, it takes up a tremendous amount of memory performing these calculations. I'm also working on automating this component of my process through VBA, but the amount of calculations often causes my excel to crash.
Any help will be greatly appreciated. Thanks!
I'm sorry if this has been answered already, but I am in desperate need of a more efficient way to count first occurrences in a workbook I frequently use. I am currently using the following:
=IF(MATCH($J2,$J$2:$J2,0)+1=ROW($J2),1,0)
Once this calculation is made for all the data entries, I use the following on a summary sheet to return the right quantity.
=COUNTIFS($J$2:$J:$1000000),1$J$R:$R:$1000000,"Non RTV",$Q$2:$Q:$1000000,"PAIR",$C$2:$C:$1000000,101,$O$2:$O:$1000000,"Cross Dock")
Since this workbook is typically between 40K and 60K rows, it takes up a tremendous amount of memory performing these calculations. I'm also working on automating this component of my process through VBA, but the amount of calculations often causes my excel to crash.
Any help will be greatly appreciated. Thanks!
