Home 
Search 
Today's Posts 
#1




Using a Text / Data output as a cell reference
I am trying to use the end of a column as a divisor and need to convert what
i guess is text into an actual cell reference if possible. In column A, say there are 13 data points ending at cell A13. I then try to turn that into a cell reference with the formula ="A"&TEXT(COUNTA(A1:A13,),"0") I put this formula in B1 the output of this is then A13 what i need this to do, is be able to divide any cell by A13. The reason I am going through all this trouble is that there are many columns and each has a different # of data points. I hope this is somewhat clear. Thanks for any help 
#2




For what you have asked you can just wrap it with INDIRECT(......) which
converts a textual representation of a reference to an actual reference. Another way to find the last value: =LOOKUP(9.99999999999999E+307,A:A) for last numeric entry in a column =LOOKUP(9.99999999999999E+307,1:1) for last numeric entry in a row =LOOKUP(REPT("z",255),A:A) for last text entry in a column =LOOKUP(REPT("z",255),1:1) for last text entry in a row  Regards Ken....................... Microsoft MVP  Excel Sys Spec  Win XP Pro / XL 97/00/02/03  It's easier to beg forgiveness than ask permission :)  "Jimboski" wrote in message ... I am trying to use the end of a column as a divisor and need to convert what i guess is text into an actual cell reference if possible. In column A, say there are 13 data points ending at cell A13. I then try to turn that into a cell reference with the formula ="A"&TEXT(COUNTA(A1:A13,),"0") I put this formula in B1 the output of this is then A13 what i need this to do, is be able to divide any cell by A13. The reason I am going through all this trouble is that there are many columns and each has a different # of data points. I hope this is somewhat clear. Thanks for any help 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
match data to reference then vlookup  Excel Discussion (Misc queries)  
inserting data from a row to a cell, when the row number is specified by a formula in a cell  New Users to Excel  
Hide text that doesn't fit in the cell  Excel Discussion (Misc queries)  
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable.  Excel Worksheet Functions  
name of another worksheet in cell for reference  Excel Worksheet Functions 