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
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