Find MIN MAX values of a column for each date

**shanuv** · 12-28-2011, 09:14 AM

hi,

I need to find MIN MAX values of columns B to H separately from a huge list of values for every day.

I have attached sample excel sheet.
This has to be done for 120 days in multiple sheets.There are around 156-160 values for each date.
Starting date and end date is available.

Please give a solution for this.

**dilipandey** · 12-28-2011, 10:15 AM

Hi Shanuv,

See the attached file and let us know if this solves your purpose. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**shanuv** · 12-28-2011, 10:47 AM

Thanks for quick reply...

Actually, i need the MIN MAX of a particular column separately, say column E, for each date.

eg: If I do manually, for 6th Dec =MIN(E8:E35) and for 7th Dec =MIN(E36:E158)

Then for every date i will have to select manually, that too for 120 days,50 sheets.
Also the number of entries in one column are not same for all dates. For 6th Dec it is 28, 7th dec it is 123, 8thdec it is 124.

I think, its clear from this.
Thanks in Advance....

**dilipandey** · 12-28-2011, 11:20 AM

Hi Shanuv,

Not sure how you wanted to use this or for what purpose, but I have done this for all the columns i.e., from Column E to G.
I wish there should be some usage criteria as well i.e, if you need to find min/max for only one column or for two columns and all this for some defined dates or a period ... and so on....

But anyways, this is done as of now. Let us know if this solves your purpose.

Regards,
DILIPandey

<click on below 'star' if this helps>

**reachhari** · 12-28-2011, 11:31 AM

Hi,

My suggestion would be going for a pivot would solve your purpose. Only work from your end would be getting the dates in way how dilipandey has got it. Later if you know how to consolidate multiple ranges using pivot then that would do the process for you.

I have attached worked out excel file for two sheets of data, you can get it done for how many ever sheets you have.

Regards,
Hariharan R

**shanuv** · 12-28-2011, 03:39 PM

Thanks Dilipandey and Hari for the help

This is exactly how I need.

**dilipandey** · 12-30-2011, 11:33 AM

you are welcome shanuv ..

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>

Thread: Find MIN MAX values of a column for each date

Thread Tools

Display

Find MIN MAX values of a column for each date

Re: Find MIN MAX values of a column for each date

Re: Find MIN MAX values of a column for each date

Re: Find MIN MAX values of a column for each date

Re: Find MIN MAX values of a column for each date

Re: Find MIN MAX values of a column for each date

Re: Find MIN MAX values of a column for each date

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions