Search results

Hi Hui, Thank you for the formula. However, the countifs don't calculate for more than 8 criteria for me and gives me a count of zero directly wherease when i use the same with sumproduct it does not count the actual number but atleast it counts with some omissions, not sure why. the count...

Thank you for this jeffrey. However, the pivot table uses only the data dump where as I'm trying to use the default list from a solution to show up the data in the tabular format. I'm more than happy to use the slicer sent by you but not all information entered is correct and the idea was to...

Hi, Attached is the sheet for your reference. The table below the filter values would be the data dump and the information based on the filter above should be able to pick up the unique id's and based on which I should be able to pick up the remaining values. I used the index formula but...

Hi Narayan, I have attached the sheet that I'm working on presently with the same formula and logic stated by you in the sheet earlier but I cannot generate the value(s). Please let me know what is that I'm doing incorrectly? Thanks in advance. Regards, Anand

I'm creating it for reporting purposes and the requirement is for data based on filters which pivot wont show up, thats why jeffrey. regards, A!

Hi Narayan, I tried with your formula, renamed the named range and could not find the desire outcome whereas in the sheet sent by you it just works fine. I dont understand what is that I'm doing incorrectly. I also found in the sheet j13 has a formula which does not have any relevance. could...

Hi, Is there an easier way to get the data extracted? Kind regards, Anand

Please help...not able to resolve this issue, any suggestions? Thanks in advance

Hi, In the sheet that I included it has 7 filter's and the formulas work if there are values against each of it. the idea is to help users to navigate to the specific list which would also mean that they need not choose all the 7 filters and should be able to show up all the unique values...

Hi, In the sheet that I included it has 7 filter's and the formulas work if there are values against each of it. the idea is to help users to navigate to the specific list which would also mean that they need not choose all the 7 filters and should be able to show up all the unique values...

Hi Nebu, Thank you for the quick update on the request. However, the ID column should pick up unique numbers and at this point in time it shows up same numbers but I think I can resolve it for now. Thanks once again. Kind regards, A!

Hi, Attached is a sample data and I'm trying to pull data that match the criterias in highlighted cells to populate information for me in columns j through o. I can generate the values using a single criteria for levels and id however I dont know how to include multiple criteria to pick up...

Thank you Hui :), that really helped me resolve my issue.

Thank you....works like a charm :) Wish you a nice day ahead. Regards, A!

Yes I understand but for reporting purposes, it would be good if I can stay away from pivot table thats why. Thanks in advance.

Thank you for the quick update. However, I know that this can be resolved using sumproduct or countifs with text string criteria but I'm not sure how to... thanks in advance. Regards, A!

Hi, I'm trying to use Countifs to count the occurence with multiple criterias matching using either countifs or Sumproduct. Attached is the sheet that I'm using for the same. The users get to choose values in column L (highlighted in Orange) and based on the selection the counts should be done...

whao...thats why i was always getting a row/column with text and when deleted the content it went off. Thanks a ton for making it simpler and explaining it for me Luke. Many thanks, Regards.

wow...that worked like magic. However, I didn't get the code specially you had set the range for 'o7'. could you please let me know. Many thanks, Regards.

Hi team, Attached is the sheet I'm working on presently. The basic idea is to update the risk sheet with dependencies data. Risk sheet will have a command button when clicked it would get the data in sheet3 (mirror data of dependency sheet if they are not already registered as risk). I've...

Hi team, Would be grateful if you could help me solve the request. Thanks in advance. Regards.

Yes, I have already. The solution states only for all data under one sheet to powerpoint However what if there are multiple worksheets like the one i had shared. I'm not able to set ranges. Could you please help. Thanks in advance. Regards.

Dear Team, I've shared a sheet as an example. I would like to know how to create the following ranges of this sheet to powerpoint slide using vba? range1 = Sheetname(Table1).Range(a1:c4) Range2 = Sheetname(Table1).Range(F1:H4) Range3 = Sheetname(Table2).Range(a1:C4) Range4 =...

Thanks SgmPatnaik...!!!it worked :)

That worked. Thank you Mahaveer and Kaushik :) made my day!!! Bliss...