Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003 | Excel Worksheet Functions | |||
How do i execute a VBA function by clicking on an excel cell? | Excel Discussion (Misc queries) | |||
Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |