Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting groups of blank cells
Hey,
Need some help with a simple problem. I currently have 3 columns. In column A, there is numbers ranging from 0 to 10. Depending on the number, I will either get a "x" in Column B or Column C. What I'm trying to do in Column D count the string of blank cells in Column C. So... A B C D 1 x 7 x 5 x 2 3 x 3 x 2 x 8 x 0 x 9 x 5 x 4 Any help would be great :) Thanks, Matt |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting groups of blank cells
Try this...
Assuming the data starts on row 1. Entered in **D2**: =IF(AND(C2="x",C1=""),COUNTBLANK(C$1:C1)-SUM(D$1:D1),"") Copy down as needed. -- Biff Microsoft Excel MVP "mpenkala" wrote in message ... Hey, Need some help with a simple problem. I currently have 3 columns. In column A, there is numbers ranging from 0 to 10. Depending on the number, I will either get a "x" in Column B or Column C. What I'm trying to do in Column D count the string of blank cells in Column C. So... A B C D 1 x 7 x 5 x 2 3 x 3 x 2 x 8 x 0 x 9 x 5 x 4 Any help would be great :) Thanks, Matt |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting groups of blank cells
Thanks T.Valko,
worked perfect. Cheers, Matt "T. Valko" wrote: Try this... Assuming the data starts on row 1. Entered in **D2**: =IF(AND(C2="x",C1=""),COUNTBLANK(C$1:C1)-SUM(D$1:D1),"") Copy down as needed. -- Biff Microsoft Excel MVP "mpenkala" wrote in message ... Hey, Need some help with a simple problem. I currently have 3 columns. In column A, there is numbers ranging from 0 to 10. Depending on the number, I will either get a "x" in Column B or Column C. What I'm trying to do in Column D count the string of blank cells in Column C. So... A B C D 1 x 7 x 5 x 2 3 x 3 x 2 x 8 x 0 x 9 x 5 x 4 Any help would be great :) Thanks, Matt |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting groups of blank cells
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "mpenkala" wrote in message ... Thanks T.Valko, worked perfect. Cheers, Matt "T. Valko" wrote: Try this... Assuming the data starts on row 1. Entered in **D2**: =IF(AND(C2="x",C1=""),COUNTBLANK(C$1:C1)-SUM(D$1:D1),"") Copy down as needed. -- Biff Microsoft Excel MVP "mpenkala" wrote in message ... Hey, Need some help with a simple problem. I currently have 3 columns. In column A, there is numbers ranging from 0 to 10. Depending on the number, I will either get a "x" in Column B or Column C. What I'm trying to do in Column D count the string of blank cells in Column C. So... A B C D 1 x 7 x 5 x 2 3 x 3 x 2 x 8 x 0 x 9 x 5 x 4 Any help would be great :) Thanks, Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Non Blank Cells | Excel Discussion (Misc queries) | |||
Counting Non Blank Cells | New Users to Excel | |||
Counting non-blank cells | Excel Discussion (Misc queries) | |||
Counting blank cells | Excel Discussion (Misc queries) | |||
counting blank cells | Excel Discussion (Misc queries) |