Thread: [Solved] Return Multiple values from data except blanks with two criteria
View Single Post
 
Old 09-03-2018, 01:39 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 551
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Return Multiple values from data except blanks with two criteria
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
Attached Files
File Type: xlsx Sample Transactions.xlsx (18.1 KB, 10 views)
Last edited by Marcia; 09-03-2018 at 02:25 PM. Reason: additional information
Reply With Quote