| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking whether a value in a list is present in a second list
I have two lists of values. Some of list A are in List B and I want a
formula to tell me which ones. I would like it to return a value of PRESENT, NOT PRESENT for every value in List A depending on whether it appears in B. Can anyone help with this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Checking whether a value in a list is present in a second list
On 1 Jun, 14:09, wrote:
I have two lists of values. Some of list A are in List B and I want a formula to tell me which ones. I would like it to return a value of PRESENT, NOT PRESENT for every value in List A depending on whether it appears in B. Can anyone help with this? I may have found it - =MATCH(C3,$E$3:$E$210,0) If so I congratulate myself. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Checking whether a value in a list is present in a second list
On Jun 1, 4:09 pm, wrote:
I have two lists of values. Some of list A are in List B and I want a formula to tell me which ones. I would like it to return a value of PRESENT, NOT PRESENT for every value in List A depending on whether it appears in B. Can anyone help with this? =IF(COUNTIF(B:B,A2)0,"PRESENT","NOT PRESENT") HTH Kostis Vezerides |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Checking whether a value in a list is present in a second list
=isnumber(match(a1,b:b,0))
will return True or false if A1 occurs in B. =if(isnumber(match(a1,b:b,0)),"Present","Not Present") would return those strings. wrote: I have two lists of values. Some of list A are in List B and I want a formula to tell me which ones. I would like it to return a value of PRESENT, NOT PRESENT for every value in List A depending on whether it appears in B. Can anyone help with this? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Checking whether a value in a list is present in a second list
On 1 Jun, 14:23, Dave Peterson wrote:
=isnumber(match(a1,b:b,0)) will return True or false if A1 occurs in B. =if(isnumber(match(a1,b:b,0)),"Present","Not Present") would return those strings. wrote: I have two lists of values. Some of list A are in List B and I want a formula to tell me which ones. I would like it to return a value of PRESENT, NOT PRESENT for every value in List A depending on whether it appears in B. Can anyone help with this? -- Dave Peterson Many thanks - problem solved. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Checking whether a value in a list is present in a second list
On 1 Jun, 14:21, vezerid wrote:
On Jun 1, 4:09 pm, wrote: I have two lists of values. Some of list A are in List B and I want a formula to tell me which ones. I would like it to return a value of PRESENT, NOT PRESENT for every value in List A depending on whether it appears in B. Can anyone help with this? =IF(COUNTIF(B:B,A2)0,"PRESENT","NOT PRESENT") HTH Kostis Vezerides Many thanks - problem solved. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking for a value in a list | Excel Discussion (Misc queries) | |||
| List all sheets present in Workbook | Excel Worksheet Functions | |||
| Checking if different items are in a list | Excel Discussion (Misc queries) | |||
| How to identify entries in a matrix also present in another list | Excel Worksheet Functions | |||
| Checking if value is in a list | Excel Worksheet Functions | |||
Linear Mode
