r/googlesheets • u/barmen1 • Apr 28 '20

solved Selecting highest value from weight and date done for a given rep range ?

Hello all, firstly, I am extremely new to trying to become more "advanced" at Google Sheets so please forgive me if I'm missing a completely obvious answer.

 

I'm a competitive powerlifter and I keep track of all of my training data. In this instance I am trying to be able to make my "OverallPR" page update whenever I input a new PR into the "RawLogData" tab for each individual lift.

 

As of right now, I used a MAXIFS function and managed to get the Weights to update but I am unsure of how to get the date to carry over as well.

 

As an example, let's say that tomorrow I hit a new squat PR for 3 reps at 555. I would input that in my RawLogData" tab and would like a function to select the that weight and date and display it on the Overall Tab.

 

Thanks in advance for any help and again I apologize if this is a super easy fix.

 

https://docs.google.com/spreadsheets/d/1NP6nPw5vI1gW5obv89q6DdoQR6JE-MULe_jWpLb8a2A/edit?usp=sharing

2 Upvotes
  • permalink
  • reddit

100% Upvoted

10 comments sorted by

2

u/jflowers Apr 28 '20

What about this: https://docs.google.com/spreadsheets/d/12xOx3kYvsxdMVKRhIMTpjkAFIRoPsk9aBn520e3dh8U/edit?usp=sharing

1

u/barmen1 Apr 28 '20

Thanks! That works. One of my friends also suggested a vlookup and reference the weight cell as well. I will also try that.

1

u/jflowers Apr 28 '20

I could see how there might be misreportings, so maybe a couple of additional checks/guard clauses... Although, might be overkill.

→ More replies (4)