Find max value every day from multiple daily values (Solarpanels daily yield)

[jakobscafe]

Hello
My solarpanels reports every 10 minutes how much they're producing.
This gives me about 150 entries every day.
I would like to select the total daily yield each day, but it is difficult, what to choose. The export from the panels may look like this:

Total KWH Datetime
32,458 01-05-2013 15:30
33,290 01-05-2013 15:40
34,095 01-05-2013 15:50
34,877 01-05-2013 16:00
35,643 01-05-2013 16:10
36,387 01-05-2013 16:20
37,108 01-05-2013 16:30
37,810 01-05-2013 16:40
----
29,091 02-05-2013 15:00
29,886 02-05-2013 15:10
30,629 02-05-2013 15:20
31,397 02-05-2013 15:30
32,175 02-05-2013 15:40
32,936 02-05-2013 15:50
33,704 02-05-2013 16:00

For each date in column 2 I would like to show the max value of column 1,
and list it like this
37,810 01-05-2013
33,704 02-05-2013
etc.

So for a month, where I have something like 4000 entries I would like to end up with 30/31 entries with the max values each date.

What to do?

[wenqq3]

Since you have 150 entry each day.
Let Total at column A.
then we can use =MAX(A2:A151) to find the max.

[Fotis1991]

Pls upload a small sample workbook.

[humdingaling]

i assume KWH date and time are split into 3 columns
whereby KWH = A, Date = B
E1 = 1st date

Please Login or Register  to view this content.

press SHIFT + CTRL + Enter when entering formula

[jakobscafe]

Hello again
Actually I have 2 columns, one for kwh and one for the date and time. I could split the date and time so I have 3 columns.

I don't have 150 entries every day, sometimes I have fewer and sometimes more entries.

In SQL I might write something like
select max(kwh), max(date, "dd-mm-yyyy") from yield
group by max(kwh),max(date, "dd-mm-yyyy");

But in Excel I have to deal with an alternating amount of entries per date

[Fotis1991]

Without to split your date in column B, you can use this ARRAY formula.

=MAX(IF(INT($B$2:$B$858)=E2;$A$2:$A$858))

[Kevin UK]

Hi jakobscafe

As you are using Excel 2013, you can use the AGGREGATE function.
I have used cell D2 for the date "01/05/2013" then put the aggregate function in E2.

Please Login or Register  to view this content.

Select both cells and click the bottom right corner of cell E2 drag down for the max values of the other days.

[Ghozi Alkatiri]

see this attachment

[Teethless mama]

Try PIVOT table

See the attached file