By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,080 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

Excel - Count Blank Rows to Next Value

P: 9
I am trying to come up with a formula that from a value say in A1, will count itself and the number of blank rows, which will vary between values and change on a daily basis, to the next value in column A and put the result on the same row as the value (blue values in example data).

Thanks, any help is greatly appreciated in advance and please let me know if I need to provide additional information.
Attached Files
File Type: xlsx Sample.xlsx (9.9 KB, 521 views)
Feb 7 '12 #1
Share this Question
Share on Google+
2 Replies


P: 45
This isn't the most beautiful solution, sorry, but it works.

Hopefully someone superior to myself can come up with a better solution for you, there probably is one.
Attached Files
File Type: xlsx Sample.xlsx (11.2 KB, 437 views)
Feb 13 '12 #2

P: 45
In case you're still checking back.

I was just thinking about this again. A better way to do it would be to have the same reference number in all the blank cells. You could then use a pivot table to summarise the list. This would also give you the ability to analyse the data far more effectively.

It also means you'll need a simple formula to count the instances:

=IF(A2=A1,"",COUNTIF(A:A,A2))

See the attached sample.
Attached Files
File Type: xlsx Sample (3).xlsx (13.7 KB, 494 views)
Feb 14 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.