Advertisement

07.23.2008 at 05:57AM PDT, ID: 23588260
[x]
Attachment Details

Using COUNTA() result in a cell reference

Asked by silchester in Microsoft Excel Spreadsheet Software

Tags: microsoft, excel, 2007

Hi

Is there a way to use the row number returned by COUNTA() function in a cell reference?

For example, COUNTA(A2:A65535) may return 182. This is the row number of the last cell with data. I then want to have this cell's value appear in another cell. The worksheet has dynamic ranges and so I cannot just explicitly state a reference to A182.

I was trying to put "=$A$(COUNTA(A2:A65535))" in the other cell...this does not work, and I do not want to do it in VBA.

Many thanksStart Free Trial
 
Keywords: Using COUNTA() result in a cell refer…
Title
1 Problems with COUNT/COUNTA
2 CountA Formula
3 COUNTA
4 COUNTA Where...
5 Count cells if ... VBA
6 Trying to use COUNTA in an IF Statement
 
Loading Advertisement...
 
[+][-]07.23.2008 at 06:12AM PDT, ID: 22068897

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Excel Spreadsheet Software
Tags: microsoft, excel, 2007
Sign Up Now!
Solution Provided By: webtubbs
Participating Experts: 4
Solution Grade: B
 
 
[+][-]07.23.2008 at 06:13AM PDT, ID: 22068906

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]07.23.2008 at 09:55AM PDT, ID: 22071251

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 03:50PM PDT, ID: 22074662

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 03:56PM PDT, ID: 22074706

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628