Hi, Please see attached file for details. Please help if possible.
ThrottleWorks Excel Ninja Sep 4, 2015 #1 Hi, Please see attached file for details. Please help if possible. Attachments Multiple CountIfs.xlsb 9.2 KB · Views: 4
Marc L Excel Ninja Sep 4, 2015 #4 Hi ! I don't understand the VBA need 'cause a single formula in Conditional Formula rocks that !? Maybe with a crystal clear and complete presentation … But wait first for NARAYANK's answer.
Hi ! I don't understand the VBA need 'cause a single formula in Conditional Formula rocks that !? Maybe with a crystal clear and complete presentation … But wait first for NARAYANK's answer.
ThrottleWorks Excel Ninja Sep 4, 2015 #5 Hi @Marc L , You are right however since the Column are not static I did not try C.F. I will try and give it a go. Thanks for the help. Good night.
Hi @Marc L , You are right however since the Column are not static I did not try C.F. I will try and give it a go. Thanks for the help. Good night.
N NARAYANK991 Excel Ninja Sep 4, 2015 #6 Hi Sachin , See if this is OK. Narayan Attachments Multiple CountIfs.xlsb 9.6 KB · Views: 7
ThrottleWorks Excel Ninja Sep 4, 2015 #7 Hi Sir, Thanks a lot for the help. I will check and will revert with details. Good night.
ThrottleWorks Excel Ninja Sep 7, 2015 #8 Hi @NARAYANK991 Sir, it's working perfectly. The way you have used Counta function is just amazing. Also, there is no need to consider Column G (or A) while using this formula ! Thanks a lot. Have a nice day ahead.
Hi @NARAYANK991 Sir, it's working perfectly. The way you have used Counta function is just amazing. Also, there is no need to consider Column G (or A) while using this formula ! Thanks a lot. Have a nice day ahead.