Looking to use 'h' in an attendance record to denote 1/2 day's holiday taken,
then the 'H' denotes a whole day

How would this be possible? Can't see how to get the function to recognise
'h' as being different to 'H' in order to use a function

Use =EXACT()
--
Gary's Student


"Suza" wrote:

Looking to use 'h' in an attendance record to denote 1/2 day's holiday taken,
then the 'H' denotes a whole day

How would this be possible? Can't see how to get the function to recognise
'h' as being different to 'H' in order to use a function

Use the "Code" function... =CODE(A1)
It returns 72 for "H" and 104 for "h".
(it reads the first character in a cell)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Suza"
wrote in message
Looking to use 'h' in an attendance record to denote 1/2 day's holiday taken,
then the 'H' denotes a whole day

How would this be possible? Can't see how to get the function to recognise
'h' as being different to 'H' in order to use a function

Boy, you guys are quick. I had to take a call and came back to find
all these answers. But I'll still throw my answer into the ring, on
the "more than one way to skin a cat" theory:
=SUMPRODUCT(--(ISNUMBER(FIND("h",A1:A10,1))))

Try something like this:

With
A1:F1 containing any values, including "H" and "h" values

This formula counts each "H" as 1 and each "h" as 0.5 then sums those values.
G1: =SUMPRODUCT(EXACT(A1:F1,"H")+EXACT(A1:F1,"h")*0.5)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Suza" wrote:

Looking to use 'h' in an attendance record to denote 1/2 day's holiday taken,
then the 'H' denotes a whole day

How would this be possible? Can't see how to get the function to recognise
'h' as being different to 'H' in order to use a function