Re: SUMPRODUCT Formula quirky....
- From: "Bob Phillips" <bob.ngs@xxxxxxxxxxxxx>
- Date: Wed, 28 Mar 2007 23:36:58 +0100
All I did was adjust whatever date that was in C1 to the Sunday of that
week, so it would match up with the data in Tabulation.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"j razz" <j.razz1@xxxxxxxxx> wrote in message
news:1175109914.446963.193120@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
The second part was just saying that there are no time issues that
would interfere with the formula.
Thanks for the formula as it is working thus far. Would you mind
taking a little time and explaining what you did in the formula so
maybe I can learn how it works so nextime I might be able to help
someone in return? Thanks Bob.
j razz
.
- References:
- SUMPRODUCT Formula quirky....
- From: j razz
- Re: SUMPRODUCT Formula quirky....
- From: Bob Phillips
- Re: SUMPRODUCT Formula quirky....
- From: j razz
- SUMPRODUCT Formula quirky....
- Prev by Date: Highlight highest / lowest number in a row
- Next by Date: Re: Convert text "date" (DDMMMYY) to datetime value of YYYY-MM-DD
- Previous by thread: Re: SUMPRODUCT Formula quirky....
- Next by thread: Re: Recovering an Excel File
- Index(es):
Relevant Pages
|