Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Count continuous duplicates
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Ashish Mathur, post: 3835509"] Hi, Try this array formula (Ctrl+Shift+Enter) in cell C5 and copy down. I have assumed that the numbers are in range B5:B9. Please ensure that you leave a couple of blank rows below the table blank =IF(B5=B4,"",MATCH(FALSE,($B6:$B9=B5),0)) -- Regards, Ashish Mathur Microsoft Excel MVP [URL="http://www.ashishmathur.com"]www.ashishmathur.com[/URL] [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Count continuous duplicates
Top
