ed9213
12-29-2010, 12:24 PM
OK, I'm the new guy and was given the task of reconciling the winning 2010 Powerball numbers with the team's purchased tickets.
They don't think they've won, but I have to prove it. Yes, they're all QuickPicks.
I've tried Excel Conditional Formatting, row-by-row comparisons, but the means of automating this process is escaping me.
I have the list of winning numbers, and lists of numbers purchased.
Excel likes to compare columns, but even transposing the rows into columns hasn't worked for me.
I have to compare the winning numbers in one row with the rest of the numbers on only that same row, highlight the duplicates, then do the process again for each ticket date.
It ought to be a simple find duplicates in the same row and highlight them, but it's not working out.
Internal Excel features can't handle it, and I'm sure VB will, but I don't know how to go about it.
The sample spreadsheet is attached. Only the duplicate numbers on the same row need to be highlighted.
Thanks, in advance, for your help.
Ed9213
They don't think they've won, but I have to prove it. Yes, they're all QuickPicks.
I've tried Excel Conditional Formatting, row-by-row comparisons, but the means of automating this process is escaping me.
I have the list of winning numbers, and lists of numbers purchased.
Excel likes to compare columns, but even transposing the rows into columns hasn't worked for me.
I have to compare the winning numbers in one row with the rest of the numbers on only that same row, highlight the duplicates, then do the process again for each ticket date.
It ought to be a simple find duplicates in the same row and highlight them, but it's not working out.
Internal Excel features can't handle it, and I'm sure VB will, but I don't know how to go about it.
The sample spreadsheet is attached. Only the duplicate numbers on the same row need to be highlighted.
Thanks, in advance, for your help.
Ed9213