How can I get the Amount only once of same PO Order No.

		Microsoft Office Forums > Microsoft Excel > Excel
How can I get the Amount only once of same PO Order No.

FAQ

Thread Tools

Display Modes

12-22-2016, 04:21 AM

LearnerExcel LearnerExcel is offline

Windows 7 32bit How can I get the Amount only once of same PO Order No.

Office 2003

Advanced Beginner

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

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

Calculations.PNG (21.6 KB, 15 views)

Attached Files

Calcualations.xlsx (9.5 KB, 10 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Amount of specific word	Stimo	Word	1	09-17-2015 08:15 PM
Cost for x amount of tokens.	sparker366	Excel	3	07-16-2015 03:16 PM
Adding an amount to a min-max range	Nibbles	Excel	4	06-13-2013 08:05 AM
amount of work	ketanco	Project	3	04-06-2012 08:13 AM
Sum required without consider the negative amount	PRADEEPB270	Excel	2	08-22-2011 04:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:55 PM.