software

Hello, I need to have excel fill a cell only if there is a value in the cell
to the right. I.e Column A1 increases by 1 whenever I enter a value in column
B2 and so on down the sheet. Thanks

quot;CJRollsquot; wrote:
gt; Hello, I need to have excel fill a cell only
gt; if there is a value in the cell
gt; to the right. I.e Column A1 increases by 1
gt; whenever I enter a value in column
gt; B2 and so on down the sheet. Thanks

One guess ..

Assuming B1 contains a label,
put in A1: =IF(COUNTA(B:B)=1,quot;quot;,COUNTA(B:B)-1)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
Thanks Max but I can only show a value in column A if there is a value in
column B. I enter information in to column B and need a formula to fill down
in column B that counts the lines as information is entered into B. Many
thanks.

A B
1 1 25623
2 2 214
3 3 587455
4

quot;Maxquot; wrote:

gt; quot;CJRollsquot; wrote:
gt; gt; Hello, I need to have excel fill a cell only
gt; gt; if there is a value in the cell
gt; gt; to the right. I.e Column A1 increases by 1
gt; gt; whenever I enter a value in column
gt; gt; B2 and so on down the sheet. Thanks
gt;
gt; One guess ..
gt;
gt; Assuming B1 contains a label,
gt; put in A1: =IF(COUNTA(B:B)=1,quot;quot;,COUNTA(B:B)-1)
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt;
gt;
gt;


Try this formula in A1 copied down

=IF(B1,COUNT(B$1:B1),quot;quot;)

if column B just contains numbers, if possibly text

=IF(LEN(B1),COUNTA(B$1:B1),quot;quot;)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=513069CJRolls:

Believe you've changed your specs in your response lt;ggt;

Couldn't help but feel that what you're looking for
is a simple auto-row numbering in col A
which appears quot;blankquot; until something is entered in col B

In which case, think we could also place in A1:
=IF(B1=quot;quot;,quot;quot;,ROWS($A$1:A1))
and copy A1 down as far as required

--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
gt; In which case, think we could also place in A1:
gt; =IF(B1=quot;quot;,quot;quot;,ROWS($A$1:A1))
gt; and copy A1 down as far as required

The above presumes data in col B will be entered sequentially down the col
w/o skips (as per post). If there's the possibility of skips, go with
daddylonglegs's suggestions. And if you were to insert new rows in-between
subsequently,
just re-fill the formula in col A from the top cell.
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---

I'm using this formula to count my records =IF(LEN(B1),COUNTA(B$1:B1),quot;quot;)
Is there a way to add letters to the count. I want it to count like this in
the spreadsheet.

ALE1
ALE2
ALE3
ALE4
ALE5...

quot;daddylonglegsquot; wrote:

gt;
gt; Try this formula in A1 copied down
gt;
gt; =IF(B1,COUNT(B$1:B1),quot;quot;)
gt;
gt; if column B just contains numbers, if possibly text
gt;
gt; =IF(LEN(B1),COUNTA(B$1:B1),quot;quot;)
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=513069
gt;
gt;