0

I'm trying to create a formula which will in the absence of data for itself, reference a column for the first piece of numeric data. However, I'm not sure what formula I should be using. Below is a screenshot and link to create your own iteration of my sheet.

enter image description here

I've highlighted "???" in this formula thinking that perhaps I can solve this with a VLOOKUP formula, but perhaps I'm wrong. As a means to test this out, one of the cells towards the bottom is referencing the "600" value on the left.

https://docs.google.com/spreadsheets/d/1BX4NYKVlzR9pJwQfq2jdTbhIxr7MvC9w0mw5wi-21PY/copy

I don't know if I'm explaining this well or not, but essentially what I'd like to do is have it so that if a person decides to enter their weight and they don't start on December 26th, the value that shows up for December 26th is the first numeric value they enter for the year.

Thanks everyone!

New contributor
JustSnilloc is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
0

It looks like the function needed here was “SORTN” (as pictured below). This allowed the first numeric value to be returned, which in this case was 600. I tested this by adding more data to the two leftmost columns and whatever showed up first in Column D was the value returned.

In this case, the new formula for that specific section should be “SORTN(D4:D373,1)”.

enter image description here

New contributor
JustSnilloc is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

Your Answer

JustSnilloc is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.