 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / December 2005Need help in numbering a column while skipping lines
data that i have is a b c d jh address telephone number ar address telephone number address telephone number ar address telephone number column a needs needs number 1,2,3,4,5, etc. but only if column be is jh or ar and they need to be consecutive like you use with autofill numbering but it needs to skip the spaces and yet keep the numbering in order Gary Reger wrote... >data that i have is > [quoted text clipped - 9 lines] >and they need to be consecutive like you use with autofill numbering >but it needs to skip the spaces and yet keep the numbering in order If your topmost row is in row 1, so the topmost col A cell would be A1, then try these formulas. A1: =IF(OR(B1={"jh","ar"}),1,"") A2: =IF(OR(B2={"jh","ar"}),1+MAX(A$1:A1),"") Fill A2 down as far as needed. it did not work here is what i got 1 JH 1 JH 1 AR 1 AR 1 JH 1 JH 1 JH 2 AR 2 JH 2 JH 2 JH 2 JH 2 JH AR AR 3 JH 3 AR 4 JH 4 JH 4 JH 4 JH JH AR 5 AR 5 JH 5 JH 6 JH 6 AR 6 JH 6 JH > Gary Reger wrote... > >data that i have is [quoted text clipped - 21 lines] > > Fill A2 down as far as needed. I am sorry this did work. ignore my other reply please thank you very much for your help > Gary Reger wrote... > >data that i have is [quoted text clipped - 21 lines] > > Fill A2 down as far as needed. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.