Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi!

I can think of solving it using nested IF statements. Suppose your letters are start in cell A1 and go down to cell 900000. The you just use this formula on column B to filter through the possible values:

=IF(A1="AAA",1,IF(A1="BBB",2,IF(A1="CCC",3)))

You can add more "DDD"s and "EEE"s if you want. Hope that helps!

Regards