Finding MIN date in a range of incomplete data

MaxWaynecrest

New Member
Joined
Jul 24, 2013
Messages
4
Hello,

I am having difficulty finding a solution to make a range dynamic. I found my total row by using MATCH("Totals:",A2:A100,1)+1). Because I want to add addtional rows to the range (up to 100), I want to find the MIN of that range and I tried using this formula: MIN (A2:A&MATCH("Totals:",A2:A100,1)+1) but I get an error. Is there a solution outside of VBA that will allow me to keep the function dynamic?

Any input will help.

Thanks!
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

shift-del

Well-known Member
Joined
Aug 28, 2009
Messages
512
Office Version
  1. 365
Platform
  1. Windows
Hello

Try:
Code:
[COLOR=#222222]=MIN[/COLOR][COLOR=#0000dd](A2:INDEX[/COLOR][COLOR=#222222](A:A,MATCH[/COLOR][COLOR=#0000dd]("Totals:",A2:A100,0)[/COLOR][COLOR=#222222]+1)[/COLOR][COLOR=#0000dd])[/COLOR]
 

Watch MrExcel Video

Forum statistics

Threads
1,108,843
Messages
5,525,177
Members
409,629
Latest member
McGuilliam

This Week's Hot Topics

Top