Help with Excel Function

[justin.creamer]

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

 

[Biff]

Hi!

Try this:

Assume the data is in the range A1:A15.

Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=INDEX(A1:A15,MODE(MATCH(A1:A15,A1:A15,0)))

Biff

 

[Epinn]

I did not confirm the formula with CSE and it seemed to return the correct result. Am I missing something here?

Thanks.

Epinn

Hi!

Try this:

Assume the data is in the range A1:A15.

Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=INDEX(A1:A15,MODE(MATCH(A1:A15,A1:A15,0)))

Biff