#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sort data by month and by dates | Marcia | Excel | 4 | 05-30-2018 01:51 AM |
Please Help. I need to sort Data A-Z not sure if i need to use Macros | steveyjohn | Excel | 1 | 11-14-2014 06:19 PM |
When I sort my data, the sumif report changes | amaka | Excel | 6 | 03-19-2014 04:55 AM |
sort data in excel | cabot | Excel | 1 | 08-17-2012 09:41 AM |
Sort Data | rkeles | Excel | 6 | 02-04-2012 01:31 PM |