View Single Post
 
Old 10-25-2018, 03:40 AM
VBA-User VBA-User is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Dec 2015
Posts: 5
VBA-User is on a distinguished road
Default 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.
Reply With Quote