Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-25-2018, 03:40 AM
VBA-User VBA-User is offline Excel formel for sort data Windows 7 64bit Excel formel for sort data Office 2013
Novice
Excel formel for sort data
 
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
  #2  
Old 10-25-2018, 08:32 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Excel formel for sort data Windows 7 64bit Excel formel for sort data Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 10-26-2018, 03:42 AM
VBA-User VBA-User is offline Excel formel for sort data Windows 7 64bit Excel formel for sort data Office 2013
Novice
Excel formel for sort data
 
Join Date: Dec 2015
Posts: 5
VBA-User is on a distinguished road
Default

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
File Type: xlsx Book (1).xlsx (9.3 KB, 9 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel formel for sort data Sort data by month and by dates Marcia Excel 4 05-30-2018 01:51 AM
Excel formel for sort data 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
Excel formel for sort data 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
Excel formel for sort data Sort Data rkeles Excel 6 02-04-2012 01:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft