using MATCH for multiple matches

  • Thread starter Thread starter Mat
  • Start date Start date
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.
 
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
 
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.
 
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.
 
Back
Top