Vlookup and Countif
Good Day!
I have a worksheet having "Names" in one column and "Status" (Pending or Complete) in the other column. I want to check name by comparing the status. I mean to say that suppose how many jobs "James" has completed and how many are pending with him and so on with other names. I tried to use Vlookup and countif functions at the same time but no required result found. Please help me to resolve this issue. Thanks & Regards, Umran |
All times are GMT +1. The time now is 05:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com