Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup returning true or false
Hi there
Been asked by a colleague if there's a function that is in essence a search function that returns true or false. I'm sure there is one but for the life of me I can't think what it is!! Basically what they're trying to do is have 6 columns of copious amounts of data, and then a 7th column with only a few bits of data, and in column 8 they would like a true or false depending on whether the data in column 7 appears anywhere in columns 1-6. Sounds pretty simple but I just can't think how to do it right now, help!!! Many thanks, Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup returning true or false
=if(countif(a:f,g1)0,true,false)
mike_vr wrote: Hi there Been asked by a colleague if there's a function that is in essence a search function that returns true or false. I'm sure there is one but for the life of me I can't think what it is!! Basically what they're trying to do is have 6 columns of copious amounts of data, and then a 7th column with only a few bits of data, and in column 8 they would like a true or false depending on whether the data in column 7 appears anywhere in columns 1-6. Sounds pretty simple but I just can't think how to do it right now, help!!! Many thanks, Mike -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup returning true or false
Hi Dave,
Thanks for that, works perfectly! Do you mind me asking how it works perfectly though? Just confused by the 0 for the countif? Thanks again "Dave Peterson" wrote: =if(countif(a:f,g1)0,true,false) mike_vr wrote: Hi there Been asked by a colleague if there's a function that is in essence a search function that returns true or false. I'm sure there is one but for the life of me I can't think what it is!! Basically what they're trying to do is have 6 columns of copious amounts of data, and then a 7th column with only a few bits of data, and in column 8 they would like a true or false depending on whether the data in column 7 appears anywhere in columns 1-6. Sounds pretty simple but I just can't think how to do it right now, help!!! Many thanks, Mike -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup returning true or false
=countif(a:f,g1)
will return the number of cells that match G1. So if that count is greater than 0 (1 or 2 or 999999), then put True, otherwise put False. Debra Dalgleish has a lot of info about counting stuff including using =countif() he http://contextures.com/xlFunctions04.html#CountIf mike_vr wrote: Hi Dave, Thanks for that, works perfectly! Do you mind me asking how it works perfectly though? Just confused by the 0 for the countif? Thanks again "Dave Peterson" wrote: =if(countif(a:f,g1)0,true,false) mike_vr wrote: Hi there Been asked by a colleague if there's a function that is in essence a search function that returns true or false. I'm sure there is one but for the life of me I can't think what it is!! Basically what they're trying to do is have 6 columns of copious amounts of data, and then a 7th column with only a few bits of data, and in column 8 they would like a true or false depending on whether the data in column 7 appears anywhere in columns 1-6. Sounds pretty simple but I just can't think how to do it right now, help!!! Many thanks, Mike -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup function problems with True/False | Excel Discussion (Misc queries) | |||
Not just True/False | Excel Discussion (Misc queries) | |||
Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
Reverse false and combine with true true value | Excel Worksheet Functions |