Search results

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 :(

Hello, Can someone pls help me in this?

Hi SirBJ7, PSB my comments please - Source data - For all the controls used in user-form, data will be available in "Master" sheet Yes, whenever user opens this file, a user-form will be opened Selection Process - There will only be one criteria as whenever user key-in any data in relevant...

Hi SirBJ7, Thanks for your revert :) and sorry as i forgot to mention that part in my first post. Here are the details - This file will be published at particular shared drive or network. Individual employee of the org will open this file and a form will be populated when file gets opened...

Hi, Greetings there! Trying to create an application in excel VBA for maintaining few basic employee data points. Stuck somewhere and need help. Problem Statement - Have EmpID, EmpName and Department as the textbox fields in form. Whenever any employee start key-in his EmpID in id textbox...

Greetings there! Can someone reply to my post please? Problem statement - Table contains the weekly captured data for particular products sale in that region. Currently I have considered only 2 regions data here but in realty I have more than 8 regions data for same number of weeks. With...

Hi Hui, Thanks for your prompt response. i have uploaded the input file @link - http://speedy.sh/EMkzA/Trend-Analysis-BaseData.xlsx please have a look at the same and also i have metioned the problem statement in excel sheet only. Thanks & Regards, Krishna

Hello Everyone! I have 3 quarters data for 2011 and 1 quarter data for 2012 captured in week patern. i want to analyze this whole data in one go just like a trend for all instances till now. can someone please help me out in acheiving the same? i tried something which was very basic and...