Hi,
I have attached the file with the resolution to your query.
Let me know if this works out for you.
Thanks & Regards,
Varun Mathur
Please reference the attached file.
Basically what I am attempting to do is use VLOOKUP to fill in the "???". I need to calculate the percentage of completion that is 100% for each person. For example Jason Smith would be 27% complete (3/11), Jessica Pruitt would be 25% complete (1/4). Anything other than 100% is "not complete". How can I use VLOOKUP (or other method) to accomplish this?
Hi,
I have attached the file with the resolution to your query.
Let me know if this works out for you.
Thanks & Regards,
Varun Mathur
Make a slight change. IN E2 use then drag down.
Code:=COUNTIFS($A$1:$A$23,$D2,$B$1:$B$23,100%)/COUNTIF($A$1:$A$23,$D2)
Bookmarks