D
Denise
Good afternoon,
I have a spreadsheet that takes a file from a different
program in Text file format. It is a list of employee's
shifts and codes next to their name used to explain
exceptions to their shift like training. However if I
have a double shift the exception code appears twice
because it is just the way the putside program does it.
When I do a sumif statement the code counts/sums twice. is
there a function that says count "Training" only once per
employee number.... something like that.
My brain is fried. Can someone help?
Denise
I have a spreadsheet that takes a file from a different
program in Text file format. It is a list of employee's
shifts and codes next to their name used to explain
exceptions to their shift like training. However if I
have a double shift the exception code appears twice
because it is just the way the putside program does it.
When I do a sumif statement the code counts/sums twice. is
there a function that says count "Training" only once per
employee number.... something like that.
My brain is fried. Can someone help?
Denise