A
aormonde
I am looking for a formula and this is really stumping me. I have a
worksheet that has one column w a name and one w a date that of things given,
since the name can be on their numberous times as can the date, I need to
find a formula that will look to see if the cell above is the same or not and
count only if it is different, (which I have that formula) however, I need to
go a step further, because not all the names recieve something on the same
day, so I need it to if the cell is blank then to leave it blank. How can I
do this in ONE formula....so, in short I am looking at something that will
look at a cell and see if it is blank, if it is leave it blank, if it isn't
then to look at the cell above it to see if it is the same, if it is not the
same then count it as 1.
worksheet that has one column w a name and one w a date that of things given,
since the name can be on their numberous times as can the date, I need to
find a formula that will look to see if the cell above is the same or not and
count only if it is different, (which I have that formula) however, I need to
go a step further, because not all the names recieve something on the same
day, so I need it to if the cell is blank then to leave it blank. How can I
do this in ONE formula....so, in short I am looking at something that will
look at a cell and see if it is blank, if it is leave it blank, if it isn't
then to look at the cell above it to see if it is the same, if it is not the
same then count it as 1.