Question about Computers & Internet
I'm finding problem to comeup with a formula for the below problem assocaited with 2 columns. Column A has 5-6 various strings (AA,BB,CC,DD,EE) and Column B has some fields empty and some non empty. The non empty ones in Column B are always prefixed by String "CSC". Now i'm trying to find out how many of each type of Column A are present which is having empty fields in coulmn B.
For this i tried the blow formula's which is not working. Pls help me.
Create a dummy column (columnC) containing columnA&columnB
use countif at columnD to count the number of observations per combination of columnA and columnB (in particular those with blank entries in columnB).
Posted on Nov 21, 2008
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Oct 17, 2014 | Microsoft Excel for PC
Sep 06, 2009 | Microsoft Office Professional 2007 Full...
Mar 11, 2009 | Microsoft Office Excel 2003 for PC
Jan 03, 2009 | Microsoft Computers & Internet
Dec 21, 2008 | Microsoft Excel for PC
Dec 10, 2008 | Microsoft Excel for PC
Sep 30, 2008 | Microsoft Excel for PC
Aug 30, 2008 | Microsoft Excel for PC
Jul 08, 2008 | Microsoft Computers & Internet
Feb 03, 2008 | Microsoft Excel for PC
Jan 21, 2018 | Amazon Computers & Internet
90 people viewed this question
Usually answered in minutes!