Building a tracker - a bit lengthy

Chico

New Member
Joined
Nov 17, 2005
Messages
5
:unsure: I have a spreadsheet with a list of all requests received from a customer daily, each request has a priority of high , medium or low depending on the category it falls into, so eg a customer who have 10 issues are considered low , a customer who has 20 problems is considred medium and a customer who requires 50 issues is considered HIGH priority.

All high priority customers will take 5 days to turnaround - all medium take 3 and all low take 2 days. I need to create a tracker on a seperate sheet in the same workbook showing how many requests are received daily , how many lows /mediums and highs are received and then how many are turned around . so basically after 2 days i need the tracer to automatically flag all lows which do not have a completed flag and also show all completed lows.

hope this makes sense - appreciate any helps out there - Thanks :)
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
two recommendations. no time to post detailed reply:

1. search this site for the syntax and use of "SUMPRODUCT"

2. search this site for "pivot table."
 

Watch MrExcel Video

Forum statistics

Threads
1,118,433
Messages
5,572,080
Members
412,439
Latest member
BKPE
Top