Hi everyone, Im working with a Loc

[Kiwi1950]

Hi everyone,
Im working with a Local Authority in NZ and I have a list of data that comes in minute by minute.
I cannot put a macro into the spreadsheet that downloads
I want to use a formula something like =IFERROR(INDEX('SCADA Data'!J$37:J$70,MATCH($B7,'SCADA Data'!$B$37:$B$70,0)),"")
but I want the MAXIMUM value for each day transferred to another tab, is there an easy way of doing this??

Thanks in advance
Good so see you are still around Skip, hope all is going well in your part of the world.

 

[Wicca]

This is what I get from the network and need to get the largest number for each day

With respect
Wicca

Believe in yourself, you are worth the investment.

 

[mintjulep]

Use Unique() to get a list of the dates.

Use Maxifs() to get the max for each date in the list of unique dates.

 

[combo]

You can use pivot table:
- date as row field,
- value as data field, change summary function from default sum to max.


combo

 

[Wicca]

Thanks Guys from a small Town Council in New Zealand.

Worked perfectly
I tried both methods and found that Unique() and MaxIfS() worked best for my application.
I didn't even know they existed until I got your emails.

Have a fantastic Day.

With respect
Wicca

Believe in yourself, you are worth the investment.