|
|
|
 |
Overclock.net - Overclocking.net > Software, Programming and Coding > Coding and Programming > Application Programming | |
Help quickly checking sheets for matching entries? Countif
|
||
 |
|
|
LinkBack | Thread Tools |
05-06-09
|
#1 (permalink) | |||||||||||||
|
Luck : 10pts
 
|
Help quickly checking sheets for matching entries? Countif
Ok going through this application i've hit more bumps then i would have ever expected. I have three sheets. I check 1 against the other two, needing to match 2 names an a date.
Currently i am working on an algorithm using Countif and Find. I was wondering if there is a way to use Countif to return only results from a single column. Try as i might can't get it to work with any expression other then WorkSheetFunction. I also want to as if there is a way so that when a name is put into the list it is automatically alphabatised. Edit : I also want to mention the lists are god forsakenly massive. Processing time using a quick brute-force checker was 12 minutes.
__________________
|
|||||||||||||
|
|
|
05-09-09
|
#2 (permalink) | |||||||||||
|
Programmer
 
|
Bump for those with knowledge who haven't see this
__________________
|
|||||||||||
|
|
|
|
05-09-09
|
#3 (permalink) | |||||||||||||
|
Luck : 10pts
|
Code:
WorksheetFunction.CountIf(Sheet.Columns(1),"SearchValue")
__________________
|
|||||||||||||
|
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
|
|
