Given below is a sample of my worksheet. I have 8 service areas and there are about 10 defined inquiries under each service area. So when an inquiry comes I will first select the service area and then the inquiry (I have data validation to avoid typing error). Service area selection is alright...
Thanks for your reply, I have given below a sample. Here when I enter Recruitment under Function then under inquiry column only the 4 inquiries related to recruitment should come for selection. I think filters only will help after the data is entered.
Date Function Inquiry...
Thanks a lot for your help. Can I please ask another question?
For the same spreadsheet above, I have my inquiries grouped under functions that is, Leave of absence will have 5 existing inquiries, Recruitment will have 4 existing inquiries. What I want is if i select Recruitment then I want...
Hello
I am using spreadsheet to track call inquiries that come on the phone in order to track new and existing(already mentioned in the Q&A company intranet) inquiries. My issue is I can give data validation for existing inquiries (helps me reduce typo error) but when a new inquiry comes I use...
I want to create a dashboard that tracks workload for 4 employees for 4 months. My issue is the tasks performed by each can differ sometimes and so altogether I will have about 50 tasks. The time and date for the start and end of the tasks will be recorded by the employees and then the...
Hello
I have given below a sample table where in the 2nd Column the output is shown.
Is there anyway to display the same output using Excel Formulas?
Name Duplicate/Not
Ann Not
Steve Duplicate
Tom Duplicate
Mark Not
Steve Duplicate
Tom Duplicate
Tom Duplicate
Thanks
Sony
Thanks for the Response
But my problem is I don't want Id's to figure in my Calculations.
It should be with respect to the Name and the Team.
Since the data volume I have is quite huge, using Id's is not practical.
My Summary sheet looks something similar to this...
Given below is a sample of data I work on :
Cov_Ids Name Team
13554 Ajay AUS
13554 Ajay AUS
13554 Ajay AUS
13555 Ajay AUS
13555 Ajay AUS
13555 Ajay AUS
13555 Ajay AUS
13555 Ajay AUS
13556 Allen Europe
13556 Allen Europe
13557 Steve USA
13557 Steve USA
13557 Steve USA
13557 Steve...