Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 13 December 2017
  0 Replies
  1.7K Visits
0
Votes
Undo
Hello ,

I have to select the min of dates based on the first occurence of a value for example

Type|StartDt|

S|
D|1/4/2017
D|1/6/2017
S|
D|2/4/2017
D|2/2/2017

In this for every S row i would have to fill in the Min date like for the 1st row formula would return date as 1/4/2017 , i want to run the Min as Min(from the s row to the occurrence of the next s row). Currently was trying to use MIN(G3,CELL("address",INDEX(A4:A100,MATCH("S",A4:A100,0)))). Here but the result of the Cell Formula would Return as "$A$4" within quotes hence the Min doesnt work

Any ideas ?

Also i would want the first parameter of the range as dynamic like Index ( A of Current row +1 ) so that it start looking from the next row rather than the current row. I am able to get the Row as Row()+1 but how do i pass this to the range like Index("A"&Row()+1,"A100") , how to get this working

Appreciate your time

Thanks
Prajith
There are no replies made for this post yet.