Find right next passed value and sum a number depending on 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
 
I

isabelle

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 :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Changing column reference for number of formulas at once 1
Search for a sum! 4
Formula for summing purchases and sales 8
formula tu sum up to a number till 7 5
MACRO RUN random percentage and copy of column values 1
Macro for comparing columns and highlighting matching/differences 14
Sum every Nth Row (almost working) 1

Top