Hello all ,
Not have a lot of luck today .
The macro in this sheet is very slow over 490,000 rows , can it be improved .
It simply just counts how many horses are there , run it and it will give results . Just need more speed .
Thanks .
Hello all ,
Not have a lot of luck today .
The macro in this sheet is very slow over 490,000 rows , can it be improved .
It simply just counts how many horses are there , run it and it will give results . Just need more speed .
Thanks .
I am grateful for all answers to my questions .
Also i give a reputation even if not answered .
.
Is the goal to count the number of rows that are used ... or ... how many unique horses names exist ?
Try this as it doesn't use looping:
Bear in mind that a data set 42 columns wide by 490,000 rows (there is "only" a maximum of 1,048,576 rows on a tab) is a huge data set and will slow Excel.Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
.
Another method if you are only checking Column AH for unique terms :
Please Login or Register to view this content.
Logit it is to count unique horses names that exist .
I will test out these two macros . Thanks .
Another optiontakes me approx 2secs for 530,000 rows.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks