Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Questions: using match
I have uploaded the file, i need to compare the data in columns A and F. A
being a master list of numbers, F being the current list. I need to display True or False in column B if the number is present or not and also calculate how many we are missing etc. Currently it is not outputting the correct value. http://www.quickfilepost.com/downloa...a83fbe2b174502 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Questions: using match
In cell B1 apply formula and copy down as required
=COUNTIF(F:F,A1)0 To find the total missing ones try this formula =COUNTIF(B:B,FALSE) -- Jacob (MVP - Excel) "sdemtevym" wrote: I have uploaded the file, i need to compare the data in columns A and F. A being a master list of numbers, F being the current list. I need to display True or False in column B if the number is present or not and also calculate how many we are missing etc. Currently it is not outputting the correct value. http://www.quickfilepost.com/downloa...a83fbe2b174502 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Questions: using match
Thanks for replying, but that didnt help me.
I have 584 unique image numbers in column F, so I should logically have 584 FALSE OR TRUE, depending on how the formula is written, but at the moment I have 508 TRUE and 507 FALSE, which is wrong. "Jacob Skaria" wrote: In cell B1 apply formula and copy down as required =COUNTIF(F:F,A1)0 To find the total missing ones try this formula =COUNTIF(B:B,FALSE) -- Jacob (MVP - Excel) "sdemtevym" wrote: I have uploaded the file, i need to compare the data in columns A and F. A being a master list of numbers, F being the current list. I need to display True or False in column B if the number is present or not and also calculate how many we are missing etc. Currently it is not outputting the correct value. http://www.quickfilepost.com/downloa...a83fbe2b174502 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Questions: using match
I have had a look at the file...There are 77 items in ColF which are not
there in ColA eg: 30308049 -- Jacob (MVP - Excel) "sdemtevym" wrote: Thanks for replying, but that didnt help me. I have 584 unique image numbers in column F, so I should logically have 584 FALSE OR TRUE, depending on how the formula is written, but at the moment I have 508 TRUE and 507 FALSE, which is wrong. "Jacob Skaria" wrote: In cell B1 apply formula and copy down as required =COUNTIF(F:F,A1)0 To find the total missing ones try this formula =COUNTIF(B:B,FALSE) -- Jacob (MVP - Excel) "sdemtevym" wrote: I have uploaded the file, i need to compare the data in columns A and F. A being a master list of numbers, F being the current list. I need to display True or False in column B if the number is present or not and also calculate how many we are missing etc. Currently it is not outputting the correct value. http://www.quickfilepost.com/downloa...a83fbe2b174502 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Questions: using match
Hi
I'm using this =ISNUMBER(MATCH(F2,A$2:A$1200,0)) Will give True for Match, False no Match then =COUNTIF(B:B,FALSE) and get 77 =COUNTIF(B:B,True) and get 508 Is this what you want ? HTH John "sdemtevym" wrote in message ... Thanks for replying, but that didnt help me. I have 584 unique image numbers in column F, so I should logically have 584 FALSE OR TRUE, depending on how the formula is written, but at the moment I have 508 TRUE and 507 FALSE, which is wrong. "Jacob Skaria" wrote: In cell B1 apply formula and copy down as required =COUNTIF(F:F,A1)0 To find the total missing ones try this formula =COUNTIF(B:B,FALSE) -- Jacob (MVP - Excel) "sdemtevym" wrote: I have uploaded the file, i need to compare the data in columns A and F. A being a master list of numbers, F being the current list. I need to display True or False in column B if the number is present or not and also calculate how many we are missing etc. Currently it is not outputting the correct value. http://www.quickfilepost.com/downloa...a83fbe2b174502 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
Excel '07 Questions | Excel Discussion (Misc queries) | |||
lookup and match questions | Excel Discussion (Misc queries) | |||
several excel questions | Excel Discussion (Misc queries) |