choose last cell with a value in a column
 

need to figure a function that identifies the last cell with a value (could
be a number or a letter) in a column....I will be updating this every other
day, it should be able to identify the next cell if I add a value to the
column. for your help I am very thankfull.

choose last cell with a value in a column
 

=SUMPRODUCT(MAX((ROW(A1:A65535))*(A1:A65535<""))) +(A65536<"")

will tell you where the last value is, number or not.
--
Gary''s Student - gsnu200909


"jcheko" wrote:

need to figure a function that identifies the last cell with a value (could
be a number or a letter) in a column....I will be updating this every other
day, it should be able to identify the next cell if I add a value to the
column. for your help I am very thankfull.

choose last cell with a value in a column
 

=INDEX(A1:A65535,MAX(ROW(A1:A65535)*(A1:A65535<"" )))

Copy and paste the above formula and give F2 and press CNTRL+SHIFT+ENTER,
since it is an array formula.

Change the cell reference to your desired cell, if required.
--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"jcheko" wrote:

need to figure a function that identifies the last cell with a value (could
be a number or a letter) in a column....I will be updating this every other
day, it should be able to identify the next cell if I add a value to the
column. for your help I am very thankfull.

choose last cell with a value in a column
 

On Dec 3, 9:19*pm, Ms-Exl-Learner wrote:
=INDEX(A1:A65535,MAX(ROW(A1:A65535)*(A1:A65535<"" )))

Copy and paste the above formula and give F2 and press CNTRL+SHIFT+ENTER,
since it is an array formula.

Change the cell reference to your desired cell, if required.
--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------



"jcheko" wrote:
need to figure a function that identifies the last cell with a value (could
be a number or a letter) in a column....I will be updating this every other
day, it should be able to identify the next cell if I add a value to the
column. for your help I am very thankfull.- Hide quoted text -

- Show quoted text -

Hi

I have a column that contain all the values end with comma,but i want
to remove comma from last cell value only.
Please suggest me to get this.

ex:

cell A

aa,
bb,
cc,

I want to remove comma from only "cc," value

choose last cell with a value in a column
 

This formula will get the values which is present before the first comma.
=LEFT(A1,FIND(",",A1)-1)

This function will replace all the comma and get you the values without
commas.
=SUBSTITUTE(A1,",","")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"ss" wrote:

On Dec 3, 9:19 pm, Ms-Exl-Learner wrote:
=INDEX(A1:A65535,MAX(ROW(A1:A65535)*(A1:A65535<"" )))

Copy and paste the above formula and give F2 and press CNTRL+SHIFT+ENTER,
since it is an array formula.

Change the cell reference to your desired cell, if required.
--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------



"jcheko" wrote:
need to figure a function that identifies the last cell with a value (could
be a number or a letter) in a column....I will be updating this every other
day, it should be able to identify the next cell if I add a value to the
column. for your help I am very thankfull.- Hide quoted text -

- Show quoted text -

Hi

I have a column that contain all the values end with comma,but i want
to remove comma from last cell value only.
Please suggest me to get this.

ex:

cell A

aa,
bb,
cc,

I want to remove comma from only "cc," value
.

choose last cell with a value in a column
 

On Dec 7, 12:06*pm, Ms-Exl-Learner wrote:
This formula will get the values which is present before the first comma.
=LEFT(A1,FIND(",",A1)-1)

This function will replace all the comma and get you the values without
comma’s.
=SUBSTITUTE(A1,",","")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------



"ss" wrote:
On Dec 3, 9:19 pm, Ms-Exl-Learner wrote:
=INDEX(A1:A65535,MAX(ROW(A1:A65535)*(A1:A65535<"" )))

Copy and paste the above formula and give F2 and press CNTRL+SHIFT+ENTER,
since it is an array formula.

Change the cell reference to your desired cell, if required.
--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------

"jcheko" wrote:
need to figure a function that identifies the last cell with a value (could
be a number or a letter) in a column....I will be updating this every other
day, it should be able to identify the next cell if I add a value to the
column. for your help I am very thankfull.- Hide quoted text -

- Show quoted text -

Hi

I have a column that contain all the values end with comma,but i want
to remove comma from last cell value only.
Please suggest me to get this.

ex:

cell A

aa,
bb,
cc,

I want to remove comma from only "cc," value
.- Hide quoted text -

- Show quoted text -

Hi ,
Firstly thank you so much for response.

Here i need to take off comma from only last cell in that column
(which is all other cells in that column need comma's)
I think your formula remove comma from all the cells.

please let me know if you need more explanation.

Thanks,

choose last cell with a value in a column
 

On Fri, 4 Dec 2009 07:24:34 -0800 (PST), ss wrote:

Hi

I have a column that contain all the values end with comma,but i want
to remove comma from last cell value only.
Please suggest me to get this.

ex:

cell A

aa,
bb,
cc,

I want to remove comma from only "cc," value

In an adjacent column, enter, e.g:

=IF(ISBLANK(A1),"",IF(COUNTA(A2:$A$65535),A1,SUBST ITUTE(A1,",","")))

where 65535 is some row number below the last row you might be using.

Fill down as far as required.

You can either use this directly, or copy the values over your original.

There are other methods using VBA to do this "in situ"
--ron