Hi Excel Gurus,
I am having a problem with a Pick 3 analysis that I am trying to run.
I am trying to set up a skip table of all the Pick 3 possible Vtrac Boxed combos (35 of them).
I have set up the spreadsheet with drawn numbers in Column D and all possibles in row 1, starting a column E.
I am using the formula
=IF($D6=E$1,0,E5+1)
The problem that I am having is that the formula doesn't recognize the numbers in column D. These were originally in 3 seperate columns, so I used CONCATENATE to combine them and then copy, paste values to convert the formula to numbers. They are formatted as number, special 000, to show leading zeros.
If I type the number into the cells in column D the formula works perfectly, so I am thinking it is a format issue. But, I don't want to type all 650 numbers over -- think of the possibility of error!
Can someone help?
I am having a problem with a Pick 3 analysis that I am trying to run.
I am trying to set up a skip table of all the Pick 3 possible Vtrac Boxed combos (35 of them).
I have set up the spreadsheet with drawn numbers in Column D and all possibles in row 1, starting a column E.
I am using the formula
=IF($D6=E$1,0,E5+1)
The problem that I am having is that the formula doesn't recognize the numbers in column D. These were originally in 3 seperate columns, so I used CONCATENATE to combine them and then copy, paste values to convert the formula to numbers. They are formatted as number, special 000, to show leading zeros.
If I type the number into the cells in column D the formula works perfectly, so I am thinking it is a format issue. But, I don't want to type all 650 numbers over -- think of the possibility of error!
Can someone help?