Hi,
Needs some help with my problem.
1) Remove duplicates based the on "Column F" in "Booking". The "booking" in general can be 2 rows up to 200 rows.
2) Sum values in "Column P" & "Column Q".
I want "FEX" to be without duplicates
Can this be done with a Macro-button?
Insert Pivot table.
You don't need current FEX sheet at all and you are faster and more flexibile.
You are on the right way but it doesn't really do the trick.Originally Posted by zbor
I need alot values from "Booking" for "FEX" and the values in "Booking" is gonna be different everyday.
Remove the duplicates,
sum up "Column P" & "Column Q",
keep the existing values after the duplicates have been removed.
Last edited by ScaniaR730; 04-22-2016 at 01:56 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks