Need to generate a list based off names and amounts, which occurred between two different dates. See attached for an example please.
Need to generate a list based off names and amounts, which occurred between two different dates. See attached for an example please.
not sure what you mean! should sean be included 01/04/2010 31/12/2010
as
01/04/2010 is later than start date of 01/01/2010
fill in the table with results you want
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
See attached. I changed it a little bit to make more sense.
Thanks!
i think you missed dawn or is that coz she wasn,t in iowa? what is your ultimate aim ?it would be easier if you just wanted teds total rather than ted twice, or even say everyones total only when in iowa
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks