Dueling Excel 98


Extract & Lookup Number When Table Of Numbers Is In A Single Cell

DESCRIPTION

See Mr Excel and excelisfun use two methods to:
1. Check whether Numbers In Cell C2 Also In F2?
2. Mr Excel does VBA solution
3. Excelisfun does Formulas Solution. See how to increment the numbers 1, 4, 7,… with ROWS Function; extract Characters from a cell with MID function.; use MID function and array constant to create a lookup table from data in a single cell; Use MATCH and ISNUMBER functions to check whether or not numbers in cell C2 are also in F2.

WORKBOOKS




Be the first to comment

Leave a Reply