Sort one 1 column and keep corresponding rows

[Luuck234]

Hello everybody,

I've been struggling with a set of data using Vlookup and keeping other data in cells in the same row as well.

Attached is an example file in which:

- A - E is raw data
- H - L is desired data

What I would like to achieve is that every row in column A-E is copied in which the first 11 is encountered in column E (yellow marked rows).

I was trying some V-lookup functions but that did not really work out. Do you have any suggestions on this problem?

Thanks!
Lucas

[Glenn Kennedy]

Hi. I added a header row. I created a helper column (which can be hidden) in column F. In F2, copied down

=IF(AND(E2=11,E1<>11),1,"")

I then used this array formula, copied across and down, to return your result:

Please Login or Register  to view this content.

[Glenn Kennedy]

Odd. The attachment disappeared...

In The Netherlands, you'll have to use ; not , s a separator, of course.

[Luuck234]

Great, thanks for the quick reply. This was exactly what I was looking for!

[Glenn Kennedy]

You're very welcome.