| Home |
| Search |
| Today's Posts |
|
#3
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. |
| 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 | |||
Threaded Mode
