Recent content by krishnabsharma

Yes, it will be checking basis today's date.

Hi Team, Greetings! Need your help on issue i am facing - Information: Have 6 Date columns (Date1 to Date6) and 2 resulting columns as "12M" & "36M" which are dependent on these 6 date columns. Problem Statement: If any of 4 Dates columns out of 6 are less than a Years duration then "12M"...

Hi There, Greetings! I am looking for monthly dashboard to track the engagements/opportunities. Problem Statement - Need a monthly dashboard with below requirements - Current State wise data DM wise data Current State & Last Month State comparison (Not sure how to derive Last month state...

Hi Jake & tobediff, Thanks a ton for your efforts :) you guys made my life drastically easier :), thanks. Jake, I have a question for you here - I did not get the use of "(COLUMN(P4)-1)/1.5" {3rd parameter in vlookup()}. Could you please help me understanding the same?

Hi, I am preparing a sheet for tax calculation at an organization level (Same is attached herewith). Here i am facing some challenges which are mentioned below. Data - There are two sheets - 1) Sheet1 - Output with all data points 2) Sheet2 - Input sheet Problem Statement - For an EMP...

That's awesome! Grt, thnx for your help...

So sorry for that Narayan :(. This is perfect sir :). This is something what i was looking for. Now i can easily get unique count in summary sheet at each dept through PIVOT table. Thanks a ton :) ! One more help if there is any way - How about if i have to display this dept level summary...

Sorry but i want the result at each department level and not at resource level. E.g. In Dept1, Resource1 is appearing 3 times, Resource2 is appearing 5 times,Resource3 is appearing 1 time; then the resulting cell should show me the unique count of Dept1/Resource wise as 3 only [(Resource1 -1)...

Hi Deb, Thanks for your efforts. Formula seems to be correct but it is having one dependency or a manual intervention - In formula you kept resource name in CELL F2 which will not be the case. Is there any way we can map that parameter directly to the basedata resoruce name column and fetch the...

Hi, I have a set of data records in excel sheet. I want to display unique count of employees per department. E.g. - In Dept1, if there are 3 entries for Resoruce1 then i want to show only 1 and not 3. Attached herewith is the sample data. Looking forward for help. Thanks. Regards, Krishna

Hi Srinidhi, Thanks for the efforts you put-in, however unfortunately this won't work for me. Reason being many clients with whom this dashboard/report will be shared are using MS EXCEL 2007 version which does not support and slicer doesn't support the earlier versions. This is the main reason i...

now how can i close this thread as i got the resolution?

Hi Lymm, thanks for efforts you put-in to solve this. this is what i was looking for. really many many thanks for your help. :)

As a Sr. Manager, want to create a report with 3 main filter criteria’s as – Client Group, Project Name and Delivery Manager. Whenever any manager selects values from these dropdowns, tabular report should get generated in report sheet from the BASEDATA Available data - · Basedata for...

Hi All, Thanks for revert. Its fine if you can give me in next 2-3 days, please :(