automatically numbering rows
I wish to have rows automatically numbered in column "A" according to the
content in column "B". If column "B" has text or numbers in a cell I do not want to number that row in column "A". If column "B" is blank in a cell I want to number that row in column "A". I found the following formula that works the opposite of what I want "=IF(B1<"",COUNTA($B$1:B1)&".","")" . What would the formula be if I wanted to numerically count the blank cells in "B" and skip the context cells in "B"? Thanks for you consideration. Regards |
automatically numbering rows
Hi
The formula for A1 =IF($B1="",ROW()-COUNTIF($B$1:$B1,"<"),"") , and copy it down Arvi Laanemets "cox ng (1)" wrote in message news:FvSyf.114914$oG.114783@dukeread02... I wish to have rows automatically numbered in column "A" according to the content in column "B". If column "B" has text or numbers in a cell I do not want to number that row in column "A". If column "B" is blank in a cell I want to number that row in column "A". I found the following formula that works the opposite of what I want "=IF(B1<"",COUNTA($B$1:B1)&".","")" . What would the formula be if I wanted to numerically count the blank cells in "B" and skip the context cells in "B"? Thanks for you consideration. Regards |
automatically numbering rows
The following formula should work
=IF(B2="",COUNTA($B$1:B2),"") -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "cox ng (1)" wrote: I wish to have rows automatically numbered in column "A" according to the content in column "B". If column "B" has text or numbers in a cell I do not want to number that row in column "A". If column "B" is blank in a cell I want to number that row in column "A". I found the following formula that works the opposite of what I want "=IF(B1<"",COUNTA($B$1:B1)&".","")" . What would the formula be if I wanted to numerically count the blank cells in "B" and skip the context cells in "B"? Thanks for you consideration. Regards |
All times are GMT +1. The time now is 05:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com