Search results

Can you share a sample worksheet to understand the requirement in better manner

Attaching the file basis image and getting the expected result. Hope that would help. Formula used sumifs & Countifs

Hi Joe it would be great if you share an excel sheet as an attachment Thanks

Formula used =TRANSPOSE(FILTER(D:D,G3=A:A)) Applicable for office 365

Attached

Dear Vletm...appreciate your response Please note the following : 1. Looking for results for search list mentioned in sheet 1 out of master data in sheet 2. Sheet 1 might contain 1 lakh records and master is comprising of 20 lakh rows data 2. In the file attached by me, macro is working very...

Thanks Ateeb for revert Challenge is I m dealing with millions of rows and hence formulas making it way slower

Hi All I am working with 2 million rows and come across a macro for fast lookup which states about Scripting Dictionary object. As i tried to use it, it worked tremendously fast but the issue is when it matches the value in Col A from sheet 1 and searches in master data in Sheet 2, it gives...

Yes, it was a trial and I got stuck there...

Thanks Narayan!!!!! You are a star

Hi.. I am trying to place data on secondary Y axis but no success. Tried but results are not as per expectation. Attaching herewith the sample data. Kindly help where I am missing Regards

hi... To clarify, "Desired data" sheet contains the subset and data to be pulled from sheet 1 of "Source1" and "Source2". Kindly ignore "Source 3" sheet.

Thanks P45cal for revert...the challenge is, the attached sheet is trying to pull out unique values from all the sheets and filling the values against them. I am trying to lookup and pull out values for specific data set from the multiple sheets

Regret for late reply Marc.... It would be multiple files with single worksheet (as given in "Source 1 & "Source 2"). You can eliminate "Source 3" file from consideration.

Hi All I tried very hard to figure out of fetching multiple match results from different workbooks/ sheets. To brief out, I have named "desired output" having input data in sheet1. There are two different workbooks "Source 1" & Source 2" from which all data to be matched and fetched. Scenario...

Yes ...result was copied from one sheet to another But the sequence does not matter...

Hi I have to 1. first filter data from Col A as Non Blanks and also Col C as non Blanks 2. Copy these filtered records and paste on sheet 2 3. Open the filter 4. Now have to filter on Col B and select "Rejected' cases 5. Copy these cases and paste in Sheet 2 beneath the data pasted in step 2...

Hi I was trying to pull data from different columns and paste on another sheet. In my sample data attached, trying to reach a result where Col A & D are non-empty and that data is pasted to another sheet. Now for col B only cases with status "Rejected" to be filtered and pasted with earlier...

Hi Peter My Bad...i didn't give a thought that data is growing immensely, hence array formula would enhance the time. Can you share the helper column resolution as the sheet attached is for array formula Regards

Thanks....the array formula without a helper column is working very fine....You are a rockstar

Thanks ,.....It is helpful

Dear All I am looking forward for a solution wherein the hourly productivity can be calculated on the basis of date and time. Date and time is in column A. Time is in 24 hours format. I tried countifs along with wild character but no luck Could you please suggest. I am attaching the sample...

Hi I am dealing in lakhs of rows on daily basis and has to compare sheets with huge data. The Vlookup when applied to such data obviously moves at snails pace. I have come across the double lookup methodology. I want to request you to please tell whether is it safe to use Vlookup with such...

Hii All I have been looking for the way out wherein attachments can get saved in a folder when the mail is received from a specific sender. The mail client is outlook 2010 Highly appreciate the help. Regards

Hii Please help me out to define the formula to compare the values in three columns with eachother. Sample data looks like as under Sno A B C Result 1 1000 1000 1000 All values are equal 2 1000 1500 2000 No Values are matching with eachother 3 1000 1000 1500 Value A & B are matching but both...