Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-03-2018, 01:39 PM
Marcia's Avatar
Marcia Marcia is offline Return Multiple values from data except blanks with two criteria Windows 7 32bit Return Multiple values from data except blanks with two criteria Office 2007
Expert
Return Multiple values from data except blanks with two criteria
 
Join Date: May 2018
Location: Philippines
Posts: 553
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
 

Thread Tools
Display Modes


Similar Threads
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
Return Multiple values from data except blanks with two criteria How to return a value in a data table using vertical and horizontal criteria oswald Excel 1 02-08-2015 02:01 AM
Return Multiple values from data except blanks with two criteria using if and compare with multiple criteria and ranges of values bill3kradio Mail Merge 7 11-17-2014 01:06 PM
Return Multiple values from data except blanks with two criteria I need to add multiple values based on multiple criteria in a cell not sure what to do 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:49 PM.


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