Multiple Criteria Lookup? If/And Statement??? Closed

Question

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!



Configuration: Windows 7 / Internet Explorer 9.0

rizvisa1 · Answer

cant you use filter to remove blank from view ?

Stupidbear · Answer

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!

Multiple Criteria Lookup? If/And Statement???

2 responses

Similar discussions

Subscribe To Our Newsletter!