Auto Volume

  • Thread starter Thread starter ianripping
  • Start date Start date
I

ianripping

In Column A I have a Volume Number, Ie 1,2,3,
When a name is entered into Column B, I put 1, 2,3 depending on how far
I am down the list.

Could I enter a formula into A that adds one the previous Volume Number
when a Name is entered into the B Column?
 
Ian,

Use in cell A2 and below :
=IF(ISBLANK(B5),"",A4+1)

In cell A1 you have to enter an initial value (most likely 1)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Hi
one way:
in A1 enter
=IF(B1="","",1)
in cell A2 enter
=IF(B2="","",A1+1)
copy this down

another way if you increment by one: Enter the following in A1:
=IF(B1="","",ROW())

Note: Sorting this list may cause problems

HTH
Frank
 
Pffff. Not my day today.

Formula in A2 should be :
=IF(ISBLANK(B2),"",A2+1)
and copy THAT formula as far down as you expect to fill in values in column
B.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

A.W.J. Ales said:
Ian,

Use in cell A2 and below :
=IF(ISBLANK(B5),"",A4+1)

In cell A1 you have to enter an initial value (most likely 1)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel Vlookup formula based on cell data 7
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Having Blank Cells, etc. ? 1
Index and match formulas 1
Adding a column if two ranges match 4
Last Modified By in a cell by user 3
Excel Help to copy information from one row at a time to another sheet 1

Back
Top