Search results

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

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

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