VBA code to select distinct rows from an Excel Spreadsheet
Posted on 2006-06-26
I have a spreadsheet that will have a column that contains either True or False. Another column contain the Job Number.
I'm attempting to write a function(I think that's the best approach) that will search and find the first "False" line item for each Job Number.
Each Job Number will have 5 - 10 rows in the spreadsheet and I'm currently not doing any grouping or subset of rows for each job number so I'm really looking at fairly raw data and would like to be able to use only the first line with a False value for each job in a seperate calculation I'm doing.
Any thoughts or sample code would be much appreciated.