Hi all,
Example excel attached (without formula but with values input to show what i want).
Multiple, cumulative counts across multiple columns specific to person within column A.
Thanks for the help,
Ryan
Hi all,
Example excel attached (without formula but with values input to show what i want).
Multiple, cumulative counts across multiple columns specific to person within column A.
Thanks for the help,
Ryan
Hi Ryan, I've got formulas working in most cells but I have a different answer to you in Cell N3 (you had 1 originally).
Just in case you wanted to count failures over 50% on a per volume basis instead of cumulative basis, I added in columns O and P to show the difference.
Also, I noticed that Overall Success in Column G calculates success on a line by line basis, should it be cumulative as well?
Edit: updated file and comments since no one had seen my mistakes yet
Last edited by Beamernsw; 01-14-2020 at 01:41 AM.
This is so awesome thank you!
And more so for the extra effort. It's perfect!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks