We have an issue dealing with customer enquiries in a timely and priority manner.

We want to be able to assign a level of importance and set a timescale for replying to each enquiry, so we're sort of looking to understand how to rank by time-verses-importance score in excel.

Ideally we would keep a list of outstanding enquiries and run the routine daily, giving us a list based on the score ranking

Any idea where to start ?

rgds