Multiple Criteria Lookup? If/And Statement???

[Closed]
Report
Posts
3
Registration date
Monday September 10, 2012
Status
Member
Last seen
September 10, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello Everyone,

This is my first time I'm at this forum and I would hope that someone can help me with a excel situation that I'm trying to resolve now. I will try my best to explain my questions here for your kind assistance. I am using Excel 2010.

Group Age Gender
A 9 F
F 10 M
A 12 F
E 7 F
C 11 M

I am trying to list the Group for a girl under 10 years old and I can use the following, IF/AND Statement, If(and(Age<10,Gender=F),Group,""). However, using this IF/AND formula, my result will have a lot of blanks. For Example,

A
"BLANK"
"BLANK"
E
"BLANK"

Are there anyway to have the result to show only the following?

A
E

Any insights on this?
Thanks for reading and your efforts in clarifying my doubts! Appreciate that!



2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
cant you use filter to remove blank from view ?
Posts
3
Registration date
Monday September 10, 2012
Status
Member
Last seen
September 10, 2012

The purpose of the question is because i am thinking of reducing the steps required to acheive the outcome in my spreadsheet. The different categories will require me to filter every category which is not efficient.

I am wondering if any gurus here would be able to advice if there a "live reading" of information sent to the database worksheet and them, reflect the information like how I've presented earlier, without the blanks in Excel 2010.

Thanks for your time in reading this problem of mine and would appreciate any feedbacks or solutions which might help my case.
Thanks!
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
It would be easy if one knows what is the full problem and goal. Same thing can be done in various ways with relative degree of efficiencies. So knowing the complete story is helpful