| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup to return true() values only and list
Hi
i have column a1 : a10 with true() or false() values. Column b1 : b10 I have text eg A, B C - J. In column C, if a1 : a10 is true() then b1 : b10. The problem I have is if only 3 values are true() I need to have the 3 values in C1, C2, C3 ie if a3 = true() then in c1 "C", a10 = true() then c2 = "J" Hope you can help Regards |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lookup to return true() values only and list
See if I understand. Column A has TRUE/FALSE. Column B has text. You want
column C to have the column B values, but only for TRUE: answer text TRUE Cordelia Cordelia FALSE Ophelia Bianca TRUE Bianca Desdemona FALSE Cressida Portia TRUE Desdemona Mab FALSE Juliet Perdita TRUE Portia Cupid FALSE Rosalind Francisco TRUE Mab FALSE Belinda TRUE Perdita FALSE Puck TRUE Cupid FALSE Miranda TRUE Francisco FALSE Ariel 1. turn-on AutoFilter on column A and select TRUE 2. copy the visible cells in column B 3. turn-off the AutoFilter 4. paste in C1 -- Gary''s Student - gsnu200827 "Robbie" wrote: Hi i have column a1 : a10 with true() or false() values. Column b1 : b10 I have text eg A, B C - J. In column C, if a1 : a10 is true() then b1 : b10. The problem I have is if only 3 values are true() I need to have the 3 values in C1, C2, C3 ie if a3 = true() then in c1 "C", a10 = true() then c2 = "J" Hope you can help Regards |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lookup to return true() values only and list
Thank you
"Gary''s Student" wrote: See if I understand. Column A has TRUE/FALSE. Column B has text. You want column C to have the column B values, but only for TRUE: answer text TRUE Cordelia Cordelia FALSE Ophelia Bianca TRUE Bianca Desdemona FALSE Cressida Portia TRUE Desdemona Mab FALSE Juliet Perdita TRUE Portia Cupid FALSE Rosalind Francisco TRUE Mab FALSE Belinda TRUE Perdita FALSE Puck TRUE Cupid FALSE Miranda TRUE Francisco FALSE Ariel 1. turn-on AutoFilter on column A and select TRUE 2. copy the visible cells in column B 3. turn-off the AutoFilter 4. paste in C1 -- Gary''s Student - gsnu200827 "Robbie" wrote: Hi i have column a1 : a10 with true() or false() values. Column b1 : b10 I have text eg A, B C - J. In column C, if a1 : a10 is true() then b1 : b10. The problem I have is if only 3 values are true() I need to have the 3 values in C1, C2, C3 ie if a3 = true() then in c1 "C", a10 = true() then c2 = "J" Hope you can help Regards |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lookup to return true() values only and list
Hi Gary
I have tried as explained, problem is that when I change the values in column a, I have to re select true() in auto filter. I am trying to get this to work automatically Hope you can help "Gary''s Student" wrote: See if I understand. Column A has TRUE/FALSE. Column B has text. You want column C to have the column B values, but only for TRUE: answer text TRUE Cordelia Cordelia FALSE Ophelia Bianca TRUE Bianca Desdemona FALSE Cressida Portia TRUE Desdemona Mab FALSE Juliet Perdita TRUE Portia Cupid FALSE Rosalind Francisco TRUE Mab FALSE Belinda TRUE Perdita FALSE Puck TRUE Cupid FALSE Miranda TRUE Francisco FALSE Ariel 1. turn-on AutoFilter on column A and select TRUE 2. copy the visible cells in column B 3. turn-off the AutoFilter 4. paste in C1 -- Gary''s Student - gsnu200827 "Robbie" wrote: Hi i have column a1 : a10 with true() or false() values. Column b1 : b10 I have text eg A, B C - J. In column C, if a1 : a10 is true() then b1 : b10. The problem I have is if only 3 values are true() I need to have the 3 values in C1, C2, C3 ie if a3 = true() then in c1 "C", a10 = true() then c2 = "J" Hope you can help Regards |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lookup to return true() values only and list
This can be automated in two different ways:
1. a VBA macro or 2. formulas with a helper column The formula method is well-described in: http://office.microsoft.com/en-us/ex...260381033.aspx -- Gary''s Student - gsnu200827 "Robbie" wrote: Hi Gary I have tried as explained, problem is that when I change the values in column a, I have to re select true() in auto filter. I am trying to get this to work automatically Hope you can help "Gary''s Student" wrote: See if I understand. Column A has TRUE/FALSE. Column B has text. You want column C to have the column B values, but only for TRUE: answer text TRUE Cordelia Cordelia FALSE Ophelia Bianca TRUE Bianca Desdemona FALSE Cressida Portia TRUE Desdemona Mab FALSE Juliet Perdita TRUE Portia Cupid FALSE Rosalind Francisco TRUE Mab FALSE Belinda TRUE Perdita FALSE Puck TRUE Cupid FALSE Miranda TRUE Francisco FALSE Ariel 1. turn-on AutoFilter on column A and select TRUE 2. copy the visible cells in column B 3. turn-off the AutoFilter 4. paste in C1 -- Gary''s Student - gsnu200827 "Robbie" wrote: Hi i have column a1 : a10 with true() or false() values. Column b1 : b10 I have text eg A, B C - J. In column C, if a1 : a10 is true() then b1 : b10. The problem I have is if only 3 values are true() I need to have the 3 values in C1, C2, C3 ie if a3 = true() then in c1 "C", a10 = true() then c2 = "J" Hope you can help Regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup values vertically in a list and return the repeats | Excel Worksheet Functions | |||
| only return true values | Excel Discussion (Misc queries) | |||
| Lookup a value in a list & return multiple corresponding values | Excel Worksheet Functions | |||
| trying to lookup a value and return if true or fals | Excel Worksheet Functions | |||
| Lookup values in a list and return multiple rows of data | Excel Worksheet Functions | |||
Linear Mode
