Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-06-2018, 01:58 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


Big big thanks to both of you Jeffrey and ArviLaanamets. I'll keep on tweaking your formulas to accommodate more than one criteria until I get the correct result. Nested formula boggles me but I am getting there.
Reply With Quote
Reply



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 05:38 AM.


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