Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page List all possible results from a table against criteria
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 10-19-2022, 03:57 AM
tinfanide tinfanide is offline List all possible results from a table against criteria Windows 7 64bit List all possible results from a table against criteria Office 2010 32bit
Expert
List all possible results from a table against criteria 		 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default List all possible results from a table against criteria

How can I achieve the effect shown by the table from Columns E to I (as below)?

Both via formulas and Power Query?

Thanks!



Reply With Quote
  #2  
Old 10-19-2022, 09:52 AM
kilroyscarnival kilroyscarnival is offline List all possible results from a table against criteria Windows 10 List all possible results from a table against criteria Office 2021
Expert
  
Join Date: May 2019
Posts: 361
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default
Hi, I'm not seeing an "as below." Was there supposed to be an attachment? If so, I don't see it's there.
Reply With Quote
  #3  
Old 10-20-2022, 12:06 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline List all possible results from a table against criteria Windows 10 List all possible results from a table against criteria Office 2021
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Quote:
Originally Posted by tinfanide View Post
Both via formulas and Power Query?Thanks!

Are you still using XL2010 as stated in your profile? ( the PQ addin is not supported anymore by MS)
__________________
Using O365 v2503 - 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
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
List all possible results from a table against criteria Numbered list with cross reference strange results twgonder Word 7 06-07-2021 03:35 PM
How to keep a list of search results Jedothek Word 2 08-19-2020 07:22 AM
vlookup with two digit criteria with multiple text results Gmiller0503 Excel 3 03-09-2017 01:00 PM
List all possible results from a table against criteria Create a unique list of values that match a criteria, sorted in order of another criteria BradRichardson Excel 2 01-03-2017 12:25 AM
List all possible results from a table against criteria Sort by criteria: number of results p0k Excel 1 10-22-2009 08:33 PM

Other Forums: Access Forums

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

Contact Us - Privacy Statement - Top

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