Search results

GraH - Guido Sir, Thank you very much. Can you please guide how to do step by step process.

sir, 2 Nos of vendor code against invoice no - 24136. if you filter invoice no - 24136, then you get 2 nos of vendor code i.e, 2023000648 & 2023000923

Sir, Kindly help to resolve the below issue. I have a data range B5:J24, as per my requirement I have solved by formula. But, I want in by power query? Is it possible my requirement which I get by formula is solved by power query? If yes, then please guide how to do. Example data is...

Hans Sir, Thank you very much. working fine.

vletm sir, Thank you for your response. it is working fine on column H. but as per my requirement we can not change anything in column H. What ever the changes in column I. My request you to please review again.

Luke M Sir, The above formula is not working.

Sir, Please help to resolve the issue. Balance amount should be continue after put some amount in subsequent cell. Example file attached for your reference.

Dear p45cal Sir, Thank You very much. Great sir! Wish You Happy New Year - 2024

vletm sir, Thank you very much.

Sir, Please help to highlight the latest entry of the name list. Example attached for your reference. NAME LIST ABC PVT LTD XYZ ENTERPRISES BDC & CO CAT LIMITED ZBC PVT LTD BDC & CO ABC PVT LTD ABC PVT LTD CAT LIMITED XYZ ENTERPRISES ZBC PVT LTD XYZ ENTERPRISES...

Sir, Please help to resolve the below issue. Shop no has multiple customer. What is the formula for Unique customer in column c. Shop No customer No of Customer (Count) 23623 A 23623 A 23623 A 23623 B 23623 B 23674 C 23674 C 23674 C 23674 C...

vletm sir, Thank you very much for resolve the issue. 1st formula is working fine. A lot of thanks for your quick response.

vletm sir, we have to put manually bill date, it should be check in report sheet (Bill starting date column & Bill Ending date column). i have used Index + Match array formula it will give correct result. but i have not consider bill date. the formula will not work for bill date criteria...

vletm sir, we do not want any pivot table report. in report sheet the data is static. we have to put manually i.e, Bill date, source, destination and size

Sir, Please help to fetch the amount in report sheet from data sheet. In Report sheet Amount data is a combination of source, destination & size field of data sheet and Bill date is the Bill starting date & Ending date of data sheet.

Sir, We have input data field, i.e, PO No After insert PO No, We have to click on Report Bottom, After click on Report Bottom the Invoice No fetch from Invoice No Colum of Data Sheet & Payment Reference No from Payment Reference Colum of Data Sheet. After that when we click on Clear Bottom, data...

Bosco_yip Sir, Thank you very much.

Sir, Highlight minimum price between vendor A & C. Note:- position of the vendor column can not change Enclose example file for your reference Vendor - A Vendor - B Vendor - C Item Price Price Price Apple 100 80 90 Orange 20 50 30 Grape 120 100 110 Banana 40 70 50 Guava 80 90...

Sir, I have a data sheet in Excel file. where I have maintain Invoice details vendor wise. i have a word file using mail merge. i want to fetch relevant data related to vendor name wise. while i change vendor name, the related data extract from excel file. Example file attached 1. Data File...

Belleke Sir, Thank you very much for resolve the issue. is it possible without VBA ?

Sir, please help to resolve the below mention issue. How to delete data which is not highlight ? data range F3:V16 Example file attached for your reference.

Bosco_yip Sir, Thank you very much.

Sir, Please help to resolve the issue. The amount should be distributed as per First in First Out Basis. Example File is attached for your reference.

Marc L Sir, After Insert the VBA Code in worksheet module, its working fine. Thanks a lot.

Marc L Sir, after inserting your code, Sheet is create and header data will also create but data will not transfer. Example file attached for your kind information. pl check the attached file.