Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Im in trouble!!! Please Help!! JS
Hello,
Ive bitten off a bit more than I can chew and said I would do a database for my mum but have become stuck. Here is problem in a nut shell. its a data base of employees but need a multi-criteria query but can't work out how to: Set criteria so when seraching for gender, you can not only do male or female but also search for both. Any ideas??? Also how do I set criteria for tick boxes?? What to serach for all people who ticked/didn't tick the box. Thanks so much for your help. I will be forever in your debt!!! |
#2
|
|||
|
|||
If I understand what you're asking, say gender is in Column D, denoted by a
"F" and a "M". Gender search criteria is entered in E1 - either M or F or MF or FM. *No Quotes* should be used in either the gender column (D1:D100) or the criteria cell (E1). =LEFT(E1)&" Count = "&COUNTIF(D1:D100,LEFT(E1))&IF(LEN(E1)=2," & "&RIGHT(E1)&" Count = "&COUNTIF(D1:D100,RIGHT(E1)),"") As to your second question, how are these "ticks" being entered? What form are they in? -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "JimmyS" wrote in message ... Hello, Ive bitten off a bit more than I can chew and said I would do a database for my mum but have become stuck. Here is problem in a nut shell. its a data base of employees but need a multi-criteria query but can't work out how to: Set criteria so when seraching for gender, you can not only do male or female but also search for both. Any ideas??? Also how do I set criteria for tick boxes?? What to serach for all people who ticked/didn't tick the box. Thanks so much for your help. I will be forever in your debt!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have had trouble with textbox text to worksheet | Excel Discussion (Misc queries) | |||
Trouble opening an Excel file that contains macros | Excel Worksheet Functions | |||
Trouble with Dates between 2 seperate worksheets | Excel Discussion (Misc queries) | |||
Graphing Trouble | Excel Discussion (Misc queries) | |||
Maps.........Having Trouble Loading things | Excel Worksheet Functions |