Posts by Pecoflyer

Please post a sample sheet ( no pics please) Thx

Just to be on the safe side, are you still using XL2007 as stated in your profile? If not please amend accordingly as answers are tailored to your XL version. thx

This being said, as OFFSET is a volatile function it should be used sparingly ( INDEX/MATCH is a good alternative)

And what would "ideal" be?

Is a Pivot Table an option?

Please post a sample sheet ( no pics please) with some data and some expected results

Thanks

Hi

could you please post a small sample sheet with expected results entered manually ? Thanks

Which excel version are you using? Your profile is incomplete in that aspect

You're welcome

See attached for a possible solution

As your data only runs till 03/08 I used a fake date in T5 to illustrate

You should of course replace T5 in your formulas with TODAY()

Could you please explain the logic of your values in col G ? It's all very obscure to me. Thx

Another option

=INDEX(C1:C19,SUMPRODUCT(ROW(A1:A19)*--(A1:A19=K3)*--(B1:B19=K4)))

Please post a sample sheet

Hi

please post a sample with some representative data. Are your dates real dates ( right aligned ) or text looking like dates ( left aligned). (assuming no manual alignment)

If the latter select the date range Click Data - Text to columns - Finish. If right aligned you are OK.

Please post a sample sheet with some data and a manually built desired result. thx

Hi

please post a sample sheet. Thx

Hi

does your edition mean to have solved the problem ? If not please post a sample sheet. Thx

18 year old-thread...

Or try ="Q"&CEILING(a3,3)/3 ( where A3 holds the month)