View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] justin.creamer@gmail.com is offline
external usenet poster
 
Posts: 1
Default Help with Excel Function

Hello,

I work for a small nonprofit who has a fee for service with our local
Division of Rehabilitation Services providing Assistive Technology and
Computer Access services.

We generally provide services in one of the following categories:

Evaluations
Training
Setup
Technical Support

I am trying to create a spreadsheet that will help us track our client
services for these clients as we frequently need to report in our
annual report how many clients we have served etc...

I also would like to add a function to determine what type of services
we most frequently provide (as listed above). I have been able to get
the =Mode() function to work on a 1, 2, 3, 4 basis in that I have
stated in the sheet that 1 = Evaluations, 2 = Training and so on.

I was wonder if i could do the same but have it so we can type in
Evaluation, Training etc... and then have a formula which will present
Evaluation if this is the most frequently used feild. SO I guess I
need to tie a label to a number or something. Any help you could
provide me with would be greatly appretiated as I am an idiot when it
comes to excel

Thanks,

Justin