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
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
Well, I can't do that without VBA.
I may do it with formulas if I use some auxiliary hidden columns, could it be?
Have a look at Pivot Tables. I doubt you will get that layout, but maybe something you can use.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
That will be fine with me. Please suggest some formula.Originally Posted by Benzadeus
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.Originally Posted by mdmackillop