Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi everyone, Im working with a Loc

Status
Not open for further replies.

Kiwi1950

Technical User
Oct 3, 2023
1
NZ
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.
 
This is what I get from the network and need to get the largest number for each day
Screenshot_2023-10-04_153135_ae2adh.jpg






With respect
Wicca

Believe in yourself, you are worth the investment.
 
Use Unique() to get a list of the dates.

Use Maxifs() to get the max for each date in the list of unique dates.
 
You can use pivot table:
- date as row field,
- value as data field, change summary function from default sum to max.


combo
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top