Formula to extract values based on criteria

excelos

Active Member
Joined
Sep 25, 2011
Messages
355
Office Version
  1. 365
Platform
  1. Windows
Hello!

I have data in three columns: A,B,C and each columns has several rows with numbers.

I want to return all the A numbers that match:

B= 4 or 3
AND
C = 5

Any idea?

I have been browsing through several websites but most at horrible in explaining bit by bit the formulas.

Thanks!
 
Last edited:

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,594
Office Version
  1. 2007
Platform
  1. Windows
You could give some examples of what you have and also show the expected result.
 

jmacleary

Well-known Member
Joined
Oct 5, 2015
Messages
1,054
Office Version
  1. 365
  2. 2007
Platform
  1. Windows
Can't you accomplish this using filters? Set the custom filter for column B to be 4 or 3 and the filter for column C to 5. Once filtered you can copy/paste the data or do whatever else you want to do with it.
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,594
Office Version
  1. 2007
Platform
  1. Windows

ADVERTISEMENT

:confused:
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680

ADVERTISEMENT

Thanks!

Will this return the whole array so that I can feed it in a SMALL formula to extract the nth values?

You are welcome ...

To answer your question : Yes ... absolutely ...
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Just out of curiosity ...

Have you carried out your own tests ... ???
 

excelos

Active Member
Joined
Sep 25, 2011
Messages
355
Office Version
  1. 365
Platform
  1. Windows
Yes I am working on it.
But it is confusing that formulas can return a single reference or a range (array).
Which formulas are these?
I never expected that the IF formula can return an array.
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Feel free to share your obstacles and progress in dealing with array formulas ... :)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,841
Messages
5,598,388
Members
414,234
Latest member
grlevesq

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top