using MATCH for multiple matches

M

Mat

Greetings

Is it possible to use the MATCH function to list all matches in a column
rather than just the first one, or is there another way of doing this?

Many thanks.
 
B

Bernie Deitrick

Mat,

Not sure what you want to extract, but the easiest way is to autofilter your
list: Data | Filter | Autofilter....

HTH,
Bernie
MS Excel MVP
 
R

RagDyer

This old post may help.

http://tinyurl.com/2qddv
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Greetings

Is it possible to use the MATCH function to list all matches in a column
rather than just the first one, or is there another way of doing this?

Many thanks.
 
T

TKT-Tang

Have encountered similar difficulty previously.

Vaguely recall that it could be Match-ed as follows :-

1. Make use of a helper column ; and there, it means that the
space-time of manouevrability is enhanced.

OR,

2. Search for all the Match-es (recording the Row addresses) ; for the
non-Match-es, the Row addresses to be thrown to cloud-nine (meaning,
outside the range of search).

3. Use Small or Large to re-arrange the combo of Match-es and
non-Match-es ; list them, by using the Row numbers as a counter
(meaning, the Row numbers where the Match-es are displayed ; Not the
Row addresses of item 2 above). The non-Match-es would be displayed as
Error values.

Regards.
 
Top