Excel - Dynamically select a range from a column in excel

Question

I'm attempting to dynamically select a range to find a minimum date.

My spreadsheet has several column headings which I need to ignore e.g.

Column A
Date Text
SomeOther Text
01/01/13
02/02/13
03/03/13

I'm using Min(A3:A5) which yields the correct answer, over time this column will grow and i'd like to not have to amend the values (A3:A5) each time. How can I dynamically create the range to insert into the min calculation?

Is it safe to assume that all the remaining rows in column A will contain only dates? Or might there exist other types of data on new rows added? — axiopisty
– axiopisty, Commented Dec 13, 2013 at 17:28

bto.rdz · Accepted Answer · 2013-12-13 16:59:18Z

0

try something like this:

Min (Range(Cells(3, 1), Cells(3, 1).End(xlDown)))

it will get all rows bellow a3

answered Dec 13, 2013 at 16:59

bto.rdz

6,7404 gold badges41 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

WGS · Accepted Answer · 2013-12-13 17:00:16Z

0

If you mean that you just want to track the expansion from A5 downward while looking for the MIN value, a lot of formulas are available. Off the top of my head:

=MIN(OFFSET(A3,,,COUNTA(A:A)-2,))

Or...

=MIN(A3:INDEX(A:A,COUNTA(A:A),))

Let us know if any of these helps.

answered Dec 13, 2013 at 17:00

WGS

14.2k5 gold badges50 silver badges51 bronze badges

Collectives™ on Stack Overflow

Excel - Dynamically select a range from a column in excel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related