LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Len Len is offline
external usenet poster
 
Posts: 162
Default Sum of Value for duplicate number

Hi,

I'm having a difficulty to deal with the sum of value for all the
duplicate number, is there any excel function or excel vba can be
helped to solve this problem as per sheet1 and give the correct result
as shown in sheet2

e.g.

Sheet1
Col A B C D E
Date P/O No. Supplier Job No. RM $
04/01 07-0001 MrYS PP-06-013 150.00
04/01 07-0002 MrT PW-06-014 340.70
04/01 07-0003 MS RD PW-06-014 1,260.00
04/01 07-0004 MRS PV PP-04-001 20,510.50
04/01 07-0004 MRS PV PP-04-001 -
04/01 07-0005 MrH PW-06-014 12,000.00
04/01 07-0006 MS RFM PP-05-020 759.50
04/01 07-0007 S & H PP-06-012 1,070.00
04/01 07-0007 S & H PP-06-012 -
04/01 07-0007 S & H PP-06-012 -
04/01 07-0007 S & H PP-06-012 -
05/01 07-0008 Mr Hean PW-06-007 300.00
05/01 07-0009 Mr Pro Fib PW-06-014 23,000.00
05/01 07-0010 Ms M.E.A. VW-06-047 2,100.00

Total 61,490.70

Sheet2
Col A B
Job No. RM $
PP-06-013 150.00
PW-06-014 36,600.70
PP-04-001 20,510.50
PP-05-020 759.50
PP-06-012 1,070.00
PW-06-007 300.00
VW-06-047 2,100.00

Total 61,490.70

Thanks in advance
Best Rgards
Len

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i give unique number in set of duplicate number? Vilish Excel Discussion (Misc queries) 2 May 12th 09 03:33 PM
Do not duplicate number Wanna Learn Excel Discussion (Misc queries) 3 June 25th 08 07:36 PM
duplicate a range a specified number of times Tbone Excel Programming 2 May 4th 07 09:37 PM
How Excel can tell me i have entered a duplicate number Autofill Excel Discussion (Misc queries) 2 July 12th 06 12:08 PM
duplicate number Daniell Excel Discussion (Misc queries) 1 March 16th 05 07:02 PM


All times are GMT +1. The time now is 08:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"