liquidlightning
New Member
- Joined
- Nov 16, 2021
- Messages
- 4
- Office Version
- 2016
- Platform
- Windows
Hey all,
I have a spreadsheet with landmarks for an upcoming long run listed, and I'd like to have Excel calculate the mileage until the next available water source. I've provided a simplified version of the spreadsheet below. I'm comfortable using basics commands, like IF, AND, COUNT, etc., but upon browsing some threads I was quickly in over my head. The LOOKUP and INDEX commands legitimately intimidate me.
Essentially I want Column D to calculate miles until the next "Y" in Column C. It's easy enough to do myself on a small enough range, but where's the satisfaction in that?
Thanks!
I have a spreadsheet with landmarks for an upcoming long run listed, and I'd like to have Excel calculate the mileage until the next available water source. I've provided a simplified version of the spreadsheet below. I'm comfortable using basics commands, like IF, AND, COUNT, etc., but upon browsing some threads I was quickly in over my head. The LOOKUP and INDEX commands legitimately intimidate me.
Essentially I want Column D to calculate miles until the next "Y" in Column C. It's easy enough to do myself on a small enough range, but where's the satisfaction in that?
Thanks!