Search results

Great..... thanks a lot...but I cannot see the formula to apply in my sheet

Dear Sirs, I need to prepare the student attendance sheet from zoom meeting data file, Kindly need help to find the 1st joined time, last left time and total of minutes.( for understanding purpose used random figures) I have tried thru Pivot table but getting date 1900 whenever I use min/max...

Dear Sir, Kindly need help, I have multiple events in columns B and I am looking for the output in new sheet which event was 1st event. Example, the Row # 17 should show first. in this way I have around 4000 records. Thanking you in advance, I prefer the formula without macro.

I just saw, this is what exactly what I want and thanks I will youtube about power query to learn more about it.

Sir...... great respect. Yeah.... this is exactly what I wanted.... Kindly explain me the formula if you can....

Mr. Narayan, Please find attached. I need to do the compare column A & B (supplier invoice # & amount) with what we have received the materials which is in column C & D (we may have receive partial delivery in same invoice)

Mr. Narayan, I have tried as follows: 1. I have made pivot table to add all duplicate invoice amount. 2. I have copied all invoices in 1 column column A & C. 3. =INDEX('Sheet1 (2)'!$A$2:$D$20,MATCH(A2,'Sheet1 (2)'!$A$2:$A$20,0),2) & =INDEX('Sheet1 (2)'!$C$2:$D$20,MATCH(A2,'Sheet1...

Sir, the process of attached sheet is to compare the supplier statement of account. Column A & B - supplier invoice no and amount Column C & D - what we have received physically with the materials.(Inv & Amount) So, to have smooth payment, we need reconcile with supplier invoice data with us...

Dear Sir, I need help to compare 2 lists as attached, hope my file well understandable. thanking you in advance and waiting for your reply. regards, Manzoor

Great !!!! thanks a lot Naresh & Narayank....

Dear Sir, I want to get the duplicate values, sample attached.

Some times I feel Bosco is robot or from different world..... MASTER of Masters

A Grand Salute !!!!! Master of Master's. Thanks a lot.

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.

Wor, you are majestic !!! No words so say thanks for your great help and explanation !! Thanks once again.

great sir, thanks a lot. I am very new to this type of complicated formula's. if possible just give some small explanation of this formula. thanks again.

Dear Bosco, Need one more help, If you can suggest me which Excel course I need to take either in Chandoo or anywhere else just to learn at least 10 % formulas in the way you use. manzoor0076@gmail.com

SIR .... U ARE A LIFE SAVER ..... GREAT !!!! NO WORDS SO SAY THANKS. IS THERE ANYTHING I CAN DO FOR YOU.... PLEASE

Sir, I copied your code and its working but I am not that much good in VB and I prefer in formulas. I used some formulas and managed to get P/N's(column C) in cells as per my requirement but unable to get "supplier order no" column B. your profile pic so cute... God bless him....

Hi Guru's, Kindly help me on below.. Thanking you in advance.

Dear bosco nd Ashlee Previously the cells were not blank nd when i cleaned them the isblank perfectly working but i found that there are some duplicates...i will send the sheet on sunday because friday nd saturday is weekend here in middle east. thanks guys...

Thanks again sir, in my original data, I have some blank cells in B2, I applied If(isblank) function in your formula but is not working..... any suggestions ?

SIR, great respect !!!!! great, great , great. I was dying with multiple vlookups,index and Match.... are you robot ..:) thanks once again....

First, thanks a lot for your reply and please find attached sample file. hope it's clear.

Hello freinds, I have around 500 Rows and some cells are as shown below and I need to get the values by using Vlookup, any masters there who can guide me. Thanks in advance.