retriving data from list

  • Thread starter Thread starter skc
  • Start date Start date
S

skc

I have an ordered list associated with strings and am trying to retriv
and then order those that match a given string (that needs to b
dynamic) I used the match formula to retrival relevant strings and the
a vlookup to insert the labels in a column next to them resulting in
list like this:

column 1 column 2
1 (indicating a match) 5
N/A N/A
N/A N/A
1 8
n/A N/A
n/A N/A
1 15
n/A n/a
1 41

I now want to end up with a list like:
5
8
15
41

It must be dynamic (change as the user specifies a need desired strin
to match) so I can't do a past values and data sort.

Is there a way to do a dynamic data sort? I had this suggested to m
and played around with it using a macro but cant figure out a solution


Any advice would be great
 
Hi
one way (using a third column)
enter the following in C1 (as array formula with CTRL+SHIFT+ENTER):
=INDEX($B$1:$B$1000,SMALL(IF(ISNA($B$1:$B$1000,1),10000,ROW($B$1:$B$100
0)),ROW()))
and copy this down (will create a #REF error after the last valid
entry - you may hide this with conditional formating, you can also hide
column B)

Frank
 
Back
Top