Remember Me?

#1
December 10th 09, 09:30 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2008 Posts: 49
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
December 10th 09, 10:44 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jun 2008 Posts: 140
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post jennifer Excel Worksheet Functions 2 August 28th 09 07:26 PM BlindShelter Excel Discussion (Misc queries) 2 December 19th 08 08:45 PM SNAP TO GUIDES DON''T SNAP Excel Discussion (Misc queries) 1 September 10th 08 10:28 PM dk New Users to Excel 15 March 28th 08 07:41 AM jimar Excel Discussion (Misc queries) 5 April 3rd 06 04:59 AM

All times are GMT +1. The time now is 03:38 AM.