formula or condition to search for missing text in a consecutive string

[rtabaldi]

Hi all. I apologize if this should be else where. I am using Excel 2007, but it might be the same across all versions.

I have a large excel sheet with a column containing the data below:

A
B
.
. .
Z

and

1
2
3
.
.
.
29

There are other columns associated to these and so the A-Z and 1-29 range repeats itself several times in one column.

Is there a way to tell excel to search a certain string (or range) on cells and have excel spit back, either by 1's and 0's or error messages, where a string is missing a number/letter in the link. So for example, the letter string is missing, say letter E? Or the number string is missing, say, # 6?

Thanks,
Ryan

[DonkeyOte]

I'd suggest posting a small yet representative sample file with both "before" and "after" so people get an idea of the required output.

I think you're basically saying you want to identify where you have missing items in your custom sequence.
However, if I am honest I can't really tell from your post if you wish to run this check adjacent to the source values or do something else entirely ? Hence the sample.... that said it's early so I'm probably being dense.

[Marcol]

Let's see if this gets the ball rolling.

In B2

Please Login or Register  to view this content.

Drag/Fill Down.