Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Duplicates From VLOOKUP Result
Good Morning All,
I am trying to remove duplicate results for a VLOOKUP query. See example below, A B 1 REFERENCE REVENUE 2 DC001 9999.99 3 DC001 9999.99 4 DC001 9999.99 5 MB002 1111.11 6 MB002 1111.11 The Values in (B) are a VLOOKUP result of (A) from another table/worksheet. The list in (A) is imported from an SQL query so cannot be altered. I would like to know how to eliminate the duplicates so that only the first result shows, eg B3, B4 & B6 would be blanks (or zero) The context of this question, is that when I summarize the data in a Pivot Table, the SUM of Revenue for REFERENCE DC001should be 9999.99, and NOT 29999.97 ( I have got round it by using MAX for Pivot output for REVENUE, but this does not to be very flexible for further analysis) I hope I have explained okay, and that my formatting remains when posted! Thank you in advance for any help - always appreciated. Mathew |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Duplicates From VLOOKUP Result
If using excel, you could use the function "remove Duplicates", before using
the data in your Pvoit Table. Mathew P Bennett wrote: Good Morning All, I am trying to remove duplicate results for a VLOOKUP query. See example below, A B 1 REFERENCE REVENUE 2 DC001 9999.99 3 DC001 9999.99 4 DC001 9999.99 5 MB002 1111.11 6 MB002 1111.11 The Values in (B) are a VLOOKUP result of (A) from another table/worksheet. The list in (A) is imported from an SQL query so cannot be altered. I would like to know how to eliminate the duplicates so that only the first result shows, eg B3, B4 & B6 would be blanks (or zero) The context of this question, is that when I summarize the data in a Pivot Table, the SUM of Revenue for REFERENCE DC001should be 9999.99, and NOT 29999.97 ( I have got round it by using MAX for Pivot output for REVENUE, but this does not to be very flexible for further analysis) I hope I have explained okay, and that my formatting remains when posted! Thank you in advance for any help - always appreciated. Mathew -- Matt Lynn Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove duplicates | Excel Worksheet Functions | |||
remove duplicates | Excel Discussion (Misc queries) | |||
How to remove row duplicates | Excel Discussion (Misc queries) | |||
Remove Duplicates | New Users to Excel | |||
Remove #N/A in vlookup result | Excel Discussion (Misc queries) |