Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I have a really hard one and hope I can explain it. I am using XL 2002 SP3 I have two sets of two columns. In each case, in column A is a list of code, column B shows the product name, the second set of columns have the same type of list, but not exactly the same content. Some of the products in column B of the second pair of Columns have the wrong product name. Is it possible to do a query where if the codes in columns A are the same but the adjacent name in column B is not, it is highlighted in some way. I can put the second two columns into the same spreadsheet making them A, B, C and D. Please note that the codes will not be aligned as the lists are not complete duplicates. I hope you understand this and someone can help. thanks |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
One way:
E1: =IF(ISNA(MATCH(C1, A:A, FALSE)), "", IF(VLOOKUP(C1, A:B, 2, FALSE)=D1, "", "Different")) In article , Daniel - Sydney wrote: Hi I have a really hard one and hope I can explain it. I am using XL 2002 SP3 I have two sets of two columns. In each case, in column A is a list of code, column B shows the product name, the second set of columns have the same type of list, but not exactly the same content. Some of the products in column B of the second pair of Columns have the wrong product name. Is it possible to do a query where if the codes in columns A are the same but the adjacent name in column B is not, it is highlighted in some way. I can put the second two columns into the same spreadsheet making them A, B, C and D. Please note that the codes will not be aligned as the lists are not complete duplicates. I hope you understand this and someone can help. thanks |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for helping but I must be doing something wrong, or did not explain
well enough. The query is not working, I even did a cut and paste in case I was typing it wrong. thanks "JE McGimpsey" wrote: One way: E1: =IF(ISNA(MATCH(C1, A:A, FALSE)), "", IF(VLOOKUP(C1, A:B, 2, FALSE)=D1, "", "Different")) In article , Daniel - Sydney wrote: Hi I have a really hard one and hope I can explain it. I am using XL 2002 SP3 I have two sets of two columns. In each case, in column A is a list of code, column B shows the product name, the second set of columns have the same type of list, but not exactly the same content. Some of the products in column B of the second pair of Columns have the wrong product name. Is it possible to do a query where if the codes in columns A are the same but the adjacent name in column B is not, it is highlighted in some way. I can put the second two columns into the same spreadsheet making them A, B, C and D. Please note that the codes will not be aligned as the lists are not complete duplicates. I hope you understand this and someone can help. thanks |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Without knowing what you mean by "not working", it's hard to know what
to suggest. Are you getting an error? an incorrect result? a crash? something else? In article , Daniel - Sydney wrote: Thanks for helping but I must be doing something wrong, or did not explain well enough. The query is not working, I even did a cut and paste in case I was typing it wrong. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
changing query source | Excel Worksheet Functions | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
"Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
Difficult matrix query | Excel Worksheet Functions |