PDA

View Full Version : Count blank cells against criteria



tqm1
03-03-2008, 02:19 AM
DEAR EXPERTS

Coulmn A ??.Column B
51 DB--------- 1
52 DNB--------
58 DB 2-------
53 DB --------
41 DRB------- 4
2 DNB -------
25 DRB ------
26 DNB------- 3
13 DNB-------
17 DRB-------
8 DNB--------

I want to get following results

Number of blank cells in column "B" against column "A" That has word DB= 1
Number of blank cells in column "B" against column "A" That has word DNB= 4
Number of blank cells in column "B" against column "A" That has word DRB= 2

Please help

Bob Phillips
03-03-2008, 02:34 AM
You have asked this question before here http://vbaexpress.com/forum/showthread.php?t=18072 and received an answer.

Simon Lloyd
03-03-2008, 04:20 AM
Bob, i was just looking at this thread and thought exactly the same! so much so that just from the mouse over i loked for the other thread to paste here!