Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match help
Hello,
Report One In Column A I have account numbers from one report, In Column B:H is the data that I'm counting. Each column has headers. Not all cells have data returned, but when it is returned it shows a 1. Report Two In column J I have account numbers from the second report In Columns K:Q is the data that I'm counting Each column has headers. Not all cells have data returned, but when it is returned it shows a 1 What I need help with, is matching column A and J and then matching columns B:H and K:Q. I need to be alerted if any of the data is different. I hope this is clear. And thank you very much for the help. Jim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match help
Let's see if we understand this:
Report 1 ......A.....B...C...D...E...F...G...H ......x......1....1.........1...1....1...... Report 2 ......J.....K...L...M...N...O...P...Q ......x....1....1......................1....... I need to be alerted if any of the data is different. Ok, what result do want based on the above? -- Biff Microsoft Excel MVP "Jim" wrote in message ... Hello, Report One In Column A I have account numbers from one report, In Column B:H is the data that I'm counting. Each column has headers. Not all cells have data returned, but when it is returned it shows a 1. Report Two In column J I have account numbers from the second report In Columns K:Q is the data that I'm counting Each column has headers. Not all cells have data returned, but when it is returned it shows a 1 What I need help with, is matching column A and J and then matching columns B:H and K:Q. I need to be alerted if any of the data is different. I hope this is clear. And thank you very much for the help. Jim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match help
I put shared a doc through google with you. I hope it helps
http://spreadsheets.google.com/ccc?k...NmTctL5Rkujg7Q "T. Valko" wrote: Let's see if we understand this: Report 1 ......A.....B...C...D...E...F...G...H ......x......1....1.........1...1....1...... Report 2 ......J.....K...L...M...N...O...P...Q ......x....1....1......................1....... I need to be alerted if any of the data is different. Ok, what result do want based on the above? -- Biff Microsoft Excel MVP "Jim" wrote in message ... Hello, Report One In Column A I have account numbers from one report, In Column B:H is the data that I'm counting. Each column has headers. Not all cells have data returned, but when it is returned it shows a 1. Report Two In column J I have account numbers from the second report In Columns K:Q is the data that I'm counting Each column has headers. Not all cells have data returned, but when it is returned it shows a 1 What I need help with, is matching column A and J and then matching columns B:H and K:Q. I need to be alerted if any of the data is different. I hope this is clear. And thank you very much for the help. Jim |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match help
also a web page link if you prefer:
http://spreadsheets.google.com/pub?k...NmTctL5Rkujg7Q "T. Valko" wrote: Let's see if we understand this: Report 1 ......A.....B...C...D...E...F...G...H ......x......1....1.........1...1....1...... Report 2 ......J.....K...L...M...N...O...P...Q ......x....1....1......................1....... I need to be alerted if any of the data is different. Ok, what result do want based on the above? -- Biff Microsoft Excel MVP "Jim" wrote in message ... Hello, Report One In Column A I have account numbers from one report, In Column B:H is the data that I'm counting. Each column has headers. Not all cells have data returned, but when it is returned it shows a 1. Report Two In column J I have account numbers from the second report In Columns K:Q is the data that I'm counting Each column has headers. Not all cells have data returned, but when it is returned it shows a 1 What I need help with, is matching column A and J and then matching columns B:H and K:Q. I need to be alerted if any of the data is different. I hope this is clear. And thank you very much for the help. Jim |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match help
The first link asks for login credentials.
This link shows me a sample file. The layout is what I thought it would be. Ok, so tell me what result you're looking for? Account # 1183-06, all the data matches so what result do you want ? If all the data didn't march what result would you want? -- Biff Microsoft Excel MVP "Jim" wrote in message ... also a web page link if you prefer: http://spreadsheets.google.com/pub?k...NmTctL5Rkujg7Q "T. Valko" wrote: Let's see if we understand this: Report 1 ......A.....B...C...D...E...F...G...H ......x......1....1.........1...1....1...... Report 2 ......J.....K...L...M...N...O...P...Q ......x....1....1......................1....... I need to be alerted if any of the data is different. Ok, what result do want based on the above? -- Biff Microsoft Excel MVP "Jim" wrote in message ... Hello, Report One In Column A I have account numbers from one report, In Column B:H is the data that I'm counting. Each column has headers. Not all cells have data returned, but when it is returned it shows a 1. Report Two In column J I have account numbers from the second report In Columns K:Q is the data that I'm counting Each column has headers. Not all cells have data returned, but when it is returned it shows a 1 What I need help with, is matching column A and J and then matching columns B:H and K:Q. I need to be alerted if any of the data is different. I hope this is clear. And thank you very much for the help. Jim |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match help
I would like a third table that will return the account number when data from
one of the adjacent columns do not match. Although 1183-06 matches, some of them do not. I gave you a sampling of the spreadsheet, there are several dozens rows. For example: Report One: . ..577 386-05..... 1 .... 1 ..... .... .... 1 ...... 455-05..... 1 .... 1 ..... .... .... 1 ...... Report Two: . ..577 386-05..... 1 .... ..... .... .... 1 ...... 455-05..... 1 .... 1 ..... .... .... 1 ...... Return . ..577 386-05..... .... 1 ..... .... .... ...... The result will be a third table that shows me that 386-05 did not have a count for column 325. I hope this helps. and thanks so much. Jim "T. Valko" wrote: The first link asks for login credentials. This link shows me a sample file. The layout is what I thought it would be. Ok, so tell me what result you're looking for? Account # 1183-06, all the data matches so what result do you want ? If all the data didn't march what result would you want? -- Biff Microsoft Excel MVP "Jim" wrote in message ... also a web page link if you prefer: http://spreadsheets.google.com/pub?k...NmTctL5Rkujg7Q "T. Valko" wrote: Let's see if we understand this: Report 1 ......A.....B...C...D...E...F...G...H ......x......1....1.........1...1....1...... Report 2 ......J.....K...L...M...N...O...P...Q ......x....1....1......................1....... I need to be alerted if any of the data is different. Ok, what result do want based on the above? -- Biff Microsoft Excel MVP "Jim" wrote in message ... Hello, Report One In Column A I have account numbers from one report, In Column B:H is the data that I'm counting. Each column has headers. Not all cells have data returned, but when it is returned it shows a 1. Report Two In column J I have account numbers from the second report In Columns K:Q is the data that I'm counting Each column has headers. Not all cells have data returned, but when it is returned it shows a 1 What I need help with, is matching column A and J and then matching columns B:H and K:Q. I need to be alerted if any of the data is different. I hope this is clear. And thank you very much for the help. Jim |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match help
Let's try this...
The sample file at this link you posted: http://spreadsheets.google.com/pub?k...NmTctL5Rkujg7Q How about filling in the 3rd table with the results you expect. -- Biff Microsoft Excel MVP "Jim" wrote in message ... I would like a third table that will return the account number when data from one of the adjacent columns do not match. Although 1183-06 matches, some of them do not. I gave you a sampling of the spreadsheet, there are several dozens rows. For example: Report One: . ..577 386-05..... 1 .... 1 ..... .... .... 1 ...... 455-05..... 1 .... 1 ..... .... .... 1 ...... Report Two: . ..577 386-05..... 1 .... ..... .... .... 1 ...... 455-05..... 1 .... 1 ..... .... .... 1 ...... Return . ..577 386-05..... .... 1 ..... .... .... ...... The result will be a third table that shows me that 386-05 did not have a count for column 325. I hope this helps. and thanks so much. Jim "T. Valko" wrote: The first link asks for login credentials. This link shows me a sample file. The layout is what I thought it would be. Ok, so tell me what result you're looking for? Account # 1183-06, all the data matches so what result do you want ? If all the data didn't march what result would you want? -- Biff Microsoft Excel MVP "Jim" wrote in message ... also a web page link if you prefer: http://spreadsheets.google.com/pub?k...NmTctL5Rkujg7Q "T. Valko" wrote: Let's see if we understand this: Report 1 ......A.....B...C...D...E...F...G...H ......x......1....1.........1...1....1...... Report 2 ......J.....K...L...M...N...O...P...Q ......x....1....1......................1....... I need to be alerted if any of the data is different. Ok, what result do want based on the above? -- Biff Microsoft Excel MVP "Jim" wrote in message ... Hello, Report One In Column A I have account numbers from one report, In Column B:H is the data that I'm counting. Each column has headers. Not all cells have data returned, but when it is returned it shows a 1. Report Two In column J I have account numbers from the second report In Columns K:Q is the data that I'm counting Each column has headers. Not all cells have data returned, but when it is returned it shows a 1 What I need help with, is matching column A and J and then matching columns B:H and K:Q. I need to be alerted if any of the data is different. I hope this is clear. And thank you very much for the help. Jim |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match help
Thanks for the attempt - I'm going to re-post the question, I going to seek
more specific formula help from other users. "Jim" wrote: Hello, Report One In Column A I have account numbers from one report, In Column B:H is the data that I'm counting. Each column has headers. Not all cells have data returned, but when it is returned it shows a 1. Report Two In column J I have account numbers from the second report In Columns K:Q is the data that I'm counting Each column has headers. Not all cells have data returned, but when it is returned it shows a 1 What I need help with, is matching column A and J and then matching columns B:H and K:Q. I need to be alerted if any of the data is different. I hope this is clear. And thank you very much for the help. Jim |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match help
Good luck!
-- Biff Microsoft Excel MVP "Jim" wrote in message ... Thanks for the attempt - I'm going to re-post the question, I going to seek more specific formula help from other users. "Jim" wrote: Hello, Report One In Column A I have account numbers from one report, In Column B:H is the data that I'm counting. Each column has headers. Not all cells have data returned, but when it is returned it shows a 1. Report Two In column J I have account numbers from the second report In Columns K:Q is the data that I'm counting Each column has headers. Not all cells have data returned, but when it is returned it shows a 1 What I need help with, is matching column A and J and then matching columns B:H and K:Q. I need to be alerted if any of the data is different. I hope this is clear. And thank you very much for the help. Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
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 |