I have got 100's of pages all in the same format.
Please look at the information in column 'C'. If the text is formatted in a certain way, I wish to insert an alphabetic reference in column B.
So referring to screen shot 1, anywhere a cell contains text with "NO underline" I wish to give an alphabetic label in column B.
I also require every page to re-start the sequence at A.
If the correct formula is used in column B cells, screen shot 2 shows the desired effect.
So referring to screen shot 2 in the example, if I used the correct formula, cell B21 would contain the letter B, and as a result cells B23, B25 and B27 would be corrected automatically in the sequence.
Edit : 13/November/2012 - Excel file added
Bookmarks