This is the formula i'm using (see below). It works fine when I have just numbers in the data. When text is added it goes haywire. I've tried a couple different things but can't get it to work. I'm not sure how to write this so it only extracts numbers; and not text. I'm guessing there needs to be something in the criteria that tells it to exclude text. The example below shows how I would like the results to look. Thanks in advance.
{=IFERROR(INDEX($E$5:$E$14,MATCH(0,COUNTIF($E$4:E4,$E$5:$E$14),0)),"")}
{=IFERROR(INDEX($E$5:$E$14,MATCH(0,COUNTIF($E$4:E4,$E$5:$E$14),0)),"")}
| Excel 2010 | ||||
|---|---|---|---|---|
| E | F | |||
| 4 | Data | Results | ||
| 5 | 4 | 4 | ||
| 6 | Late | 2 | ||
| 7 | 2 | 7 | ||
| 8 | On Time | 1 | ||
| 9 | 7 | 11 | ||
| 10 | Late | 14 | ||
| 11 | 1 | |||
| 12 | 11 | |||
| 13 | 14 | |||
| 14 | On Time | |||
Sheet1 | ||||
