Values to Letters?? Possible?

  • Thread starter Thread starter DarklyCute1
  • Start date Start date
D

DarklyCute1

My boss has lately given me a new project an absence report for human
resources. It has 8 categories (sick, personal, vacation, funeral
leave, professional leave, jury duty, a.w.o.l., and worker's comp)
thereare 70 employees and each has to be recorded each day. (mon-fri).

Now that there's the background. Is there a way to give a letter a
value? Say I enter V for vacation can I get the program to recognize
it as a value of 1 then have all the v's total elsewhere? Sorry if
that's confusing, but if anyone has any ideas, it would be much
appreciated.

DarklyConfused
 
DarklyCute1 said:
My boss has lately given me a new project an absence report for human
resources. It has 8 categories (sick, personal, vacation, funeral
leave, professional leave, jury duty, a.w.o.l., and worker's comp)
thereare 70 employees and each has to be recorded each day. (mon-fri).

Now that there's the background. Is there a way to give a letter a
value? Say I enter V for vacation can I get the program to recognize
it as a value of 1 then have all the v's total elsewhere? Sorry if
that's confusing, but if anyone has any ideas, it would be much
appreciated.
Click to expand...

Hi DarklyCute1

Yes there is but it'll be easier to try:

=COUNTIF(A1:A10,"=V")

Amend the range to yours and amend the "=V" to whatever other letters
you use.

Regards

Steve
 
Try some variation of this:

# Of Employees out for Vacation
@COUNTIF(A1:A70="Vacation")

# Of Employees out Sick
@COUNTIF(A1:A70="Sick")

Ect...
 
Using the countif function would assign a value of 1 to each occurenc
of "V" for vacation. But how about if you only wanted it to have
value of .50? for a half day....??
 
Assign .5 to another letter or combination of letters like HD for half-day


Gord Dibben MS Excel MVP
 
Back
Top