R
Rob
Hello.... I've looked through a lot of posts here and unfortunately I cannot
find a formula that helps in my issue. What I am looking to do is within an
Excel 2003 worksheet I have several columns and I need to count all the
unique values of Column "A" that also have a criteria of Column "K" being
either; "In Work", "Completed", or "Not Started". I found many formulae that
sort of did what I am looking for but they involved performing division and
the end results keep coming up as a non-whole number, e.g. '14.12'. In order
to combat this issue I have used a "Roundup" with the formula however this
does not fully operate correctly when low decimals are continuous.
For example... If I start off with '14.01' = ~15 and I add one more unique
value the result is '14.45' = ~15.... but it should now be 16.
Here is the formula I am working with that best suited what I am trying to
do, (roundup added).
=ROUNDUP(SUMPRODUCT((K2:K100="In
Work")/COUNTIF(A2:A100,A2:A100&"")*(A2:A100<>"")),0)
If I can count all the "Unique" Column "A" items that happen to also be
Column "K" - "In Work" without having to roundup I would feel that the data
is actually accurate. Any help would be outstanding.
Thanks In Advance!
find a formula that helps in my issue. What I am looking to do is within an
Excel 2003 worksheet I have several columns and I need to count all the
unique values of Column "A" that also have a criteria of Column "K" being
either; "In Work", "Completed", or "Not Started". I found many formulae that
sort of did what I am looking for but they involved performing division and
the end results keep coming up as a non-whole number, e.g. '14.12'. In order
to combat this issue I have used a "Roundup" with the formula however this
does not fully operate correctly when low decimals are continuous.
For example... If I start off with '14.01' = ~15 and I add one more unique
value the result is '14.45' = ~15.... but it should now be 16.
Here is the formula I am working with that best suited what I am trying to
do, (roundup added).
=ROUNDUP(SUMPRODUCT((K2:K100="In
Work")/COUNTIF(A2:A100,A2:A100&"")*(A2:A100<>"")),0)
If I can count all the "Unique" Column "A" items that happen to also be
Column "K" - "In Work" without having to roundup I would feel that the data
is actually accurate. Any help would be outstanding.
Thanks In Advance!