Which function should I use?

**evanandrews03** · 03-04-2024, 11:13 AM

Hello, I do not use Excel that often and I normally only use the basic functions but I am looking to make my life a little easier if possible. Im hoping someone can help me figure out which function I should use in my case.

The function I am looking for is one that would act like a condition statement (if x is true then a) for a range of cells, and compile a list from a different cell instead of having two outcomes (true or false).

My example:

Business Names	Gold Sponsor	Silver Sponsor
A	Yes	No
B	No	Yes
C	Yes	Yes

I have a list of businesses (A,B,& C) and two different levels of sponsors (Gold & Silver). I would like to find the function that creates a list of Business Names for each the gold and silver sponsors like below:

Gold Sponsors
A
C

Silver Sponsors
B
C

Thank you!

**AliGW** · 03-04-2024, 11:16 AM

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Administrative Note:

Is your forum profile showing the Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.

**AliGW** · 03-04-2024, 11:19 AM

Try this:

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	F	G
1	Gold Sponsor	Silver Sponsor
2	A	B
3	C	C

Sheet: Sheet1

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	F	G
2	=FILTER(A2:A4,FILTER(B2:C4,B1:C1=F1)="Yes")	=FILTER(A2:A4,FILTER(B2:C4,B1:C1=G1)="Yes")

Sheet: Sheet1

Which function should I use?

LinkBack

Thread Tools

Rate This Thread

Display

Which function should I use?

Re: Which function should I use?

Re: Which function should I use?

Thread Information

Users Browsing this Thread

Similar Threads

Remove Spaces between words with dashes (TRIM function, SUBSTITUTE function, CLEAN or LEN)

[SOLVED] Left function, Right Function, or Mid Function to extract values to three decimal places

Right function, Left function, Mid function to extract values in column A

COUNTUNIQUE Function in Google Sheets; Excel lacks a direct counterpart to this function?

Calling function inside function. (aka nested function)

Excel 2010 VBA Sheets Copy function works, but then jumps to the beginning of a function

Excel NORM.DIST function gives results greater than 1 with probability mass function. How

Bookmarks

Bookmarks

Posting Permissions