Excel formel for sort data
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
Last edited by VBA-User; 10-26-2018 at 03:31 AM.
|