M mu4you New Member May 17, 2016 #1 Hi Guru's, I have uploaded the file with desired output. Please note that there are 2 files (master data and Sales order data) in Sales order data file which I need the formula to get the desired results. I am using excel 2013. Thanking you in advance. Attachments Book1.xlsx Book1.xlsx 10.2 KB · Views: 9
Hi Guru's, I have uploaded the file with desired output. Please note that there are 2 files (master data and Sales order data) in Sales order data file which I need the formula to get the desired results. I am using excel 2013. Thanking you in advance.
N NARAYANK991 Excel Ninja May 17, 2016 #2 Hi , I doubt that what you want can be done using Excel formulae. Even with VBA , it is not so easy. Narayan
Hi , I doubt that what you want can be done using Excel formulae. Even with VBA , it is not so easy. Narayan
B bosco_yip Excel Ninja May 17, 2016 #3 Try this formula way with helper columns 1] Input data range : A1:C8 2] Helper columns range : E1:J13 3] Output data range : A15:C24 4] Attached file. Regards Bosco Attachments PurchaseOrderStatus.xlsx PurchaseOrderStatus.xlsx 11.9 KB · Views: 7
Try this formula way with helper columns 1] Input data range : A1:C8 2] Helper columns range : E1:J13 3] Output data range : A15:C24 4] Attached file. Regards Bosco
B bosco_yip Excel Ninja May 18, 2016 #4 Find some formula cells did not copied down fully. Enclosed herein the revised file and the formulae remain unchanged. Attachments PurchaseOrderStatus2.xlsx PurchaseOrderStatus2.xlsx 12 KB · Views: 10 Last edited: May 18, 2016
Find some formula cells did not copied down fully. Enclosed herein the revised file and the formulae remain unchanged.
