Search results

Thanks a lot. That was really helpful.

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...

Thanks for the Post. I will go through it and see what I can come up with. Thanks for your time. I appreciate it.

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...

Thanks so much !!!!

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 a lot!!!!!!!!!!!! It works wonderful...... Cheers

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...