How to collect data in one page on a single date which has multiple entries

[JKALB]

I am trying to build a small single page report where we can enter data in one worksheet which has multiple entries for the same date, and at the same time keep a cummulative daily and monthly average of these data in the report page. I caanot do it with a simple lookup, as it will retrieve only the leftmost column. I was thinking some offset or index may do the trick.

I may submit a copy of the report if it makes my quest clearer.


Thnx to all chandoo warriors.

 

[Hui]

Jkalb


Firstly, Welcome to the Chandoo.org Forums


Start by reading Lukes post at: http://chandoo.org/wp/2011/11/18/formula-forensics-003/