How to Find Matching Date for Lowest Weight in Google Sheets?

Other Questions Google Sheets
1

Hey everyone! I’m trying to figure out something in my Google Sheets workout tracker. I’ve got dates in one column and weights in another. I want to find the date that matches my lowest weight. Right now I can get the lowest weight with =MIN(B:B), but I’m stumped on how to get the date for it.

My sheet looks kinda like this:

Date     | Weight
-----------------
1/1/2023 | 180
1/2/2023 | 179
1/3/2023 | 181
1/4/2023 | 178

I want to show both the lowest weight (178) and its date (1/4/2023) somewhere else on the sheet. I tried messing with HLOOKUP and other lookup functions, but I’m getting nowhere fast.

Any ideas on how to pull this off? I feel like I’m missing something obvious here. Thanks for any help!

2

I’ve been using Google Sheets for my weight loss journey too, and I stumbled upon a neat trick that might help you out. Try this formula:

=ARRAYFORMULA(A2:A&" - "&B2:B)

Then use SORT on the result, like this:

=SORT(ARRAYFORMULA(A2:A&" - "&B2:B),2,TRUE)

This will give you a sorted list of date-weight pairs, with the lowest weight at the top. You can then use LEFT and RIGHT functions to split the date and weight if needed.

It’s a bit of a roundabout way, but it’s flexible and lets you see your progress at a glance. Plus, you can easily modify it to show top 5 lowest weights, for example. Just remember to adjust the cell references to match your sheet!

3

I’ve encountered a similar challenge in my fitness tracking spreadsheet. The solution that worked for me was using a combination of MINIFS and FILTER functions. Here’s the formula I used:

=MINIFS(A:A, B:B, MIN(B:B))

This essentially finds the minimum value in column B (your weights) and then returns the corresponding date from column A. It’s particularly useful if you have multiple instances of the lowest weight, as it will return the earliest date.

For displaying both the lowest weight and its date, you could use something like this in two separate cells:

Lowest Weight: =MIN(B:B)
Date of Lowest Weight: =MINIFS(A:A, B:B, MIN(B:B))

This approach has been quite reliable in my experience. Let me know if you need any clarification on implementing these formulas.

4

hey there! i’ve dealt with this before. try using INDEX and MATCH together. something like:

=INDEX(A:A, MATCH(MIN(B:B), B:B, 0))

this should grab the date that matches your lowest weight. hope it helps!