Saved Bookmarks
| 1. |
Solve : Excel; how to filter categories.? |
|
Answer» For example, cell C9, I will type "sally" and I WANT it to automatically appear under FEMALE on the right hand side (cell O9). nothing in c9. just a name "sally"How is he dissatisfied? What does he not like about the way your formula works? Quote from: CARBON Dudeoxide on August 07, 2009, 06:28:30 AM I believe you're going to want to make the names and gender a table and use the VLOOKUP command along with the IF statement. Thanks, I couldnt remember an had to learn that Quote from: soybean on August 07, 2009, 06:42:29 AM How is he dissatisfied? What does he not like about the way your formula works? because it doesn't work... Quote from: BC_Programmer on August 11, 2009, 07:55:33 PM because it doesn't work...She didn't say it doesn't work. She said she figured out a way but he was still not satisfied. Quote from: And 1 on August 05, 2009, 07:24:40 PM nothing in c9. just a name "sally"Knowing why he was not satisfied with it would help clarify the requirements. Hmm, looking at the requisites, that would satisfy them... (assuming the same is done for the "male" column. Additional information as to why it was not satisfactory would definitely help. You just need a VLOOKUP statement: If the names you have are in A1:B3 A B 1 James 2 John 3 Sally and you type in D1 eg James Target cell say F1 needs =VLOOKUP(D1,A1:B3,2,FALSE) D1 is the source A1:B3 is the table of names 2 is the column to look into A1:B3 FALSE says look at exact matches only. Hope this helps |
|