Using The IF and Max function to separate the largest record for a range of items

**aabbey** · 10-23-2018, 06:04 AM

Effectively I would like my to separate my best results from a range of exercises. Then have these appear in a records box.

I had a crack at it, but it doesn’t work.

Please see attachment.

**FerdyHar** · 10-23-2018, 06:10 AM

Try this in J5

Formula:

Please Login or Register  to view this content.

It is an Array formula, so confirm with CTRL+SHIFT+ENTER instead of just enter.

You will notice if it worked, if you see these curly brackets "{" "}" around the formula (do not add these manually, this doesn't work)

Drag the formula down to J6 and J7

Ferdy

**Bo_Ry** · 10-23-2018, 07:21 AM

Please try J5 drag down
=AGGREGATE(14,,RMFA1[Max Rep]*(RMFA1[Exercise]=I5),1)

**aabbey** · 10-23-2018, 07:40 AM

Originally Posted by FerdyHar

Try this in J5

Formula:

Please Login or Register  to view this content.

It is an Array formula, so confirm with CTRL+SHIFT+ENTER instead of just enter.

You will notice if it worked, if you see these curly brackets "{" "}" around the formula (do not add these manually, this doesn't work)

Drag the formula down to J6 and J7

Ferdy

Thank you both. They both performed the task well.

Using The IF and Max function to separate the largest record for a range of items

LinkBack

Thread Tools

Rate This Thread

Display

Using The IF and Max function to separate the largest record for a range of items

Re: Using The IF and Max function to separate the largest record for a range of items

Re: Using The IF and Max function to separate the largest record for a range of items

Re: Using The IF and Max function to separate the largest record for a range of items

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Function to look up largest value whose record meets criteria?

[SOLVED] Function to look up largest value whose record meets criteria?

[SOLVED] Function to look up largest value whose record meets criteria?

Function to look up largest value whose record meets criteria?

[SOLVED] Function to look up largest value whose record meets criteria?

Function to look up largest value whose record meets criteria?

[SOLVED] Function to look up largest value whose record meets criteria?

Function to look up largest value whose record meets criteria?

Bookmarks

Bookmarks

Posting Permissions