Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match
In columns A & B in ascending order I have the following
A B 1 200801 200700 2 200830 200701 153 208905 200830 200 209006 208905 In column C I want a formula that "match" or "not match column A with B Regards Carl |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match
On Sep 3, 1:10*pm, Xavie wrote:
In columns A & B in ascending order I have the following * * * *A * * * * * *B 1 * * 200801 *200700 2 * * 200830 *200701 153 208905 *200830 200 209006 *208905 In column C I want a formula that "match" or "not match column A with B Regards Carl Define Match? Do you want if the value in A2 is matching the value in B2? OR do you want if the value in A2 is somewhere in the BXXX list? Or do you want if the value in B2 is somewhere in the AXXX list? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match
the value in A2 is somewhere in the BXXX list
"Reeza" wrote: On Sep 3, 1:10 pm, Xavie wrote: In columns A & B in ascending order I have the following A B 1 200801 200700 2 200830 200701 153 208905 200830 200 209006 208905 In column C I want a formula that "match" or "not match column A with B Regards Carl Define Match? Do you want if the value in A2 is matching the value in B2? OR do you want if the value in A2 is somewhere in the BXXX list? Or do you want if the value in B2 is somewhere in the AXXX list? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match
Assuming your data starts in row 1, in cell C1 enter
=countif(B$1:B$200,A1) and copy it down. If the value in A1 appears in column B, the result will be 1 or greater. "Xavie" wrote: the value in A2 is somewhere in the BXXX list "Reeza" wrote: On Sep 3, 1:10 pm, Xavie wrote: In columns A & B in ascending order I have the following A B 1 200801 200700 2 200830 200701 153 208905 200830 200 209006 208905 In column C I want a formula that "match" or "not match column A with B Regards Carl Define Match? Do you want if the value in A2 is matching the value in B2? OR do you want if the value in A2 is somewhere in the BXXX list? Or do you want if the value in B2 is somewhere in the AXXX list? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match
On Sep 3, 1:50*pm, Xavie wrote:
the value in A2 is somewhere in the BXXX list "Reeza" wrote: On Sep 3, 1:10 pm, Xavie wrote: In columns A & B in ascending order I have the following * * * *A * * * * * *B 1 * * 200801 *200700 2 * * 200830 *200701 153 208905 *200830 200 209006 *208905 In column C I want a formula that "match" or "not match column A with B Regards Carl Define Match? Do you want if the value in A2 is matching the value in B2? OR do you want if the value in A2 is somewhere in the BXXX list? Or do you want if the value in B2 is somewhere in the AXXX list?- Hide quoted text - - Show quoted text - =if(countif(B$1:B$200, A1)=1, "MATCH", "NOT MATCH") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)... | Excel Worksheet Functions |