![]() |
#1
|
||||
|
||||
![]()
I have a problem extracting multiple data from a table that contains blanks. My array formula is
=IFERROR(INDEX(Transaction_No.,SMALL(IF(Status=B$1 5,ROW(Transaction_No.)-ROW(C$3)+1),ROWS(C$3:C3))),"") Please help me in: 1. When the formula reaches a blank cell in the lookup range, there is also a blank row in the resulting table.There should be no blank rows. 2. In another sheet, I need to extract data with two criteria. How could I tweak this formula to come up with the correct list? 3. In column I of the source data, I would like a formula to automate the assigning of numbers to approved transactions starting from number 2018-1. In between the transactions are data that awaits processing. Sample transactions attached for clarity Last edited by Marcia; 09-03-2018 at 02:25 PM. Reason: additional information |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Want to return a value from my pricing table into my raw data sheet given criteria in the data sheet | mcronin | Excel | 1 | 05-09-2016 09:43 AM |
![]() |
oswald | Excel | 1 | 02-08-2015 02:01 AM |
![]() |
bill3kradio | Mail Merge | 7 | 11-17-2014 01:06 PM |
![]() |
AUHAMM | Excel | 3 | 10-27-2014 09:11 PM |
Data analysis with four conditions then copies certain values that meets the criteria | AieMPhy | Excel | 0 | 04-24-2014 08:41 PM |