PDA

View Full Version : Need formula to get that output



amit_nalawad
09-02-2009, 04:41 AM
Hi,

Please refer an attached file. There are two sheets.
1. Data(data that i get from others)
2.Output(that i want to show using formula, no macro)

Please help me with this. I want to show the output data using some formula.

Thanks
Amit N

Benzadeus
09-02-2009, 06:42 AM
Well, I can't do that without VBA.

I may do it with formulas if I use some auxiliary hidden columns, could it be?

mdmackillop
09-02-2009, 01:09 PM
Have a look at Pivot Tables. I doubt you will get that layout, but maybe something you can use.

amit_nalawad
09-03-2009, 10:33 PM
Well, I can't do that without VBA.

I may do it with formulas if I use some auxiliary hidden columns, could it be?

That will be fine with me. Please suggest some formula.

amit_nalawad
09-03-2009, 10:35 PM
Have a look at Pivot Tables. I doubt you will get that layout, but maybe something you can use.

I have tried that using pivot table. But actual data is going to be for at least 2 or 3 months. So i can not manage that many days columns using Pivot Table.