aUTO nUMBERING
Help me please.
Is there any way to automatically number in column A only if there is any data in column B. SL Item ----------------------- 1 have data no data 2 have data 3 have data 4 have data no data 5 have data |
aUTO nUMBERING
In A1 enter:
1 In A2 enter: =IF(B2="","",MAX($A$1:A1)+1) and copy down -- Gary''s Student - gsnu200838 |
aUTO nUMBERING
You are a Gent and Thanks a Lot "Gary''s Student" wrote: In A1 enter: 1 In A2 enter: =IF(B2="","",MAX($A$1:A1)+1) and copy down -- Gary''s Student - gsnu200838 |
All times are GMT +1. The time now is 07:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com