Find right next passed value and sum a number depending on date

  • Thread starter Thread starter Sir martel
  • Start date Start date
S

Sir martel

Hi,

I have one worksheet. I am needing to match up column G with value on $E$3 and give consecutive numbers on column F depending if the matched column G with value on $E$3 is on same date of column L; I have plenty blankcells and other values on column G.
I trying catch up with excel..
Thanks 4 your helpalues on column G
 
hi,

array formula, press CTRL + SHIFT + ENTER to validate

=INDEX(F:F,MATCH($E$3&$E$3,G:G&L:L,0))

isabelle

Le 2014-05-22 16:05, Sir martel a écrit :
 
Back
Top