Need formula to return list of matches
Posted by Ghentry Meeks on July 18, 2001 6:15 AM
I am using a simple 5 column spreadsheet. I am trying to find a formula where I can enter a value in a cell, and it will return a corresponding value on the same row in another column. I have used the index and match functions and they have worked fine. However, if there are more than one occurence of that value in the column, it will only recognize the first occurence of that value. Is there anyway that it will return all occurences of that value?
Posted by Mark W. on July 18, 2001 6:58 AM
> Is there anyway that it will return all
> occurences of that value?
A formula is entered into a single cell or a
set of contiguous cells of pre-determined height
and width. The results of the formula are returned
to the cells in which it is entered. How is
Excel to treat 5, 6 or 10 occurances of the same
value?
Posted by Ghentry Meeks on July 18, 2001 7:14 AM
My original posting must not have been very clear. What I need is to search for a value and it return results such as it would when using a search engine on the internet(listing all matches found). Index and match will only find the first occurence of the value I am looking for. Is there any way to write the formula where it would list all occurences of the value I am looking for?
Posted by Mark W. on July 18, 2001 7:24 AM
A *formula* cannot be employed for the reasons that
I stated earlier. At the time a formula is entered
into a worksheet there must be foreknowledge of how
many occurances must accommodated. If that isn't
known then even an array formula entered into mult-
iple cells might not return all such occurances.
You will need to write a procedural macro or use an
existing Excel feature such as AutoFilter.
