I have a list of values. These particular values are numbered 1 to 90 (in A2:A91). The values in column B (B2:B91) are 1 to 45 with each occurring twice.
I want to setup formulas on a different location on the sheet so that I can have a list of the where each occurrence of the values occurs in the list... For example, if I were looking for the second occurrence of value 27 in column B a formula that would return number 55 from column A....assuming that that is the corresponding location related to that value.
Make sense? Is it possible?
I want to setup formulas on a different location on the sheet so that I can have a list of the where each occurrence of the values occurs in the list... For example, if I were looking for the second occurrence of value 27 in column B a formula that would return number 55 from column A....assuming that that is the corresponding location related to that value.
Make sense? Is it possible?