P
pieman3
Hi
I am trying to create a list of products in one column that are rated either
good or excellent in another column on the same sheet. So I need the list to
display in one column based upon the values of two other separate columns.
For example, I have 3 columns in total, column A is where I want the product
names to be displayed, column B is the text I want to display in column A
only if the corresponding cell in column C contains the words 'excellent' or
'good'. So if cell B1 contains the text 'widget 1' and the text in cell C1
contains the text 'excellent' or 'good' then 'widget 1' should be shown in
cell A1. Ideally i want the list to only contain the qualifying products
without empty cells caused by products that don't meet the criteria.
Is there a formula to create this? Any ideas would be much appreciated as
I've spent hours trying to find the solution.
Thanks
Simon
I am trying to create a list of products in one column that are rated either
good or excellent in another column on the same sheet. So I need the list to
display in one column based upon the values of two other separate columns.
For example, I have 3 columns in total, column A is where I want the product
names to be displayed, column B is the text I want to display in column A
only if the corresponding cell in column C contains the words 'excellent' or
'good'. So if cell B1 contains the text 'widget 1' and the text in cell C1
contains the text 'excellent' or 'good' then 'widget 1' should be shown in
cell A1. Ideally i want the list to only contain the qualifying products
without empty cells caused by products that don't meet the criteria.
Is there a formula to create this? Any ideas would be much appreciated as
I've spent hours trying to find the solution.
Thanks
Simon