Hello,



I have an excel sheet with many unsorted data, i am only interested in the numbers from Column A. In column B i have an index nr which tells me the size of the product. I have 6 different sizes (A, B, C, D, E and F) for example ...With the formula i have i can sort for 1 size (in this example A). The Value in column A which is in the same row as my index A is written in an other excel sheet (in the cell with the formula). Now, i want to try to add an "Or", i want to say: if there is one of this 4 letters then write the values of same row in sheet 2.

The formula:

=Iferror(index(sheet1!A:A;Aggregate(15;6;row(AB$2: AB$999)/OR((left(Sheet1!B$2:B$999;1)="A");Left(Sheet1!B$2: B$999;1)="B");Row(AB2)));"")

I dont want an empty cell, when i remove the second rule then i wont get an empty cell. I would be thankful for any help.

Wennfehler = IfError
Links = left
Zeile = row
German - English

Regards

Please post a sample sheet with some data and expected results. Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Ok, here is a sample file. I can't translate the formula to english. In sheet2 i have the result, but i don't want empty rows.

Regards

Attached Files

Book (1).xlsx (9.3 KB, 9 views)