Thread: How can I get the Amount only once of same PO Order No.
View Single Post
 
Old 12-22-2016, 04:21 AM
LearnerExcel LearnerExcel is offline Windows 7 32bit Office 2003
Advanced Beginner
  
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default How can I get the Amount only once of same PO Order No.
How can I get the Amount only once of same Order No. which is repeated in two or three columns. Duplicate values with same Order No. to be Blank.

Like in the attachment.
Attached Images
File Type: png Calculations.PNG (21.6 KB, 15 views)
Attached Files
File Type: xlsx Calcualations.xlsx (9.5 KB, 10 views)
Reply With Quote