Linked Questions
33 questions linked to/from Last non-empty cell in a column
0 votes
2 answers
97 views
Function referring to the last entered cell in a column
I want a function that refers to the last entered cell in a particular column. For example, consider column A and the entries are as follows. 1st entry in column is in cell A1, 2nd in A2, 3rd in A5, ...
-1 votes
1 answer
93 views
excel - find last non blank cell in row from alternating columns
i have an excel sheet in which the first few columns contain titles and information and the rest are repetitive 3 columns sets (i'll refer to as col1,col2,col3), containing dates. i added an other 3 ...
0 votes
1 answer
70 views
Sending a dynamic range to a function
Newbie here, so please bear with me. I'm just not getting something about properly putting a dynamic column of values into an array. The following lines of code work properly for me: Set RangeD = ...