bulletbikeguy
New Member
- Joined
- Jun 30, 2011
- Messages
- 4
Let me attempt to explain what I'm trying to accomplish. I typically have a lot of luck searching google, or browsing through forums for excel programming tips but I'm at a lose on how to even formulate the question.
I build a spreadsheet a while back to help me track my work outs. It tracks several key areas like: duration, distance, type of work out, number of push-ups, pull-ups, sit-ups etc. It then compiles the data into a organized little group of cells to give an overview.
Well I decided to modify the sheet to include my brother. I was able to use 'IF' statements to compare the two sets of data and turn the whole thing into a big competition. Now if I have done more push-ups it shows my stats and his stats and the top row shows who is winning that category. It's pretty motivating honestly.
Well I guess I'm onto something here because now his wife wants in, and two of my good friends want to join. I'm using google docs so getting them access is easy but the coding is a bit beyond my knowledge.
I learned how to use QUERY function to pull data and arrange it by participant name. I can't however figure out how to compare the data so it displays who is winning in each category. The IF arguments aren't working because a simple true/false will no longer do the job.
I have tried using the MAX command but that only gives me the greatest cell value. Instead of cell value I would need the corresponding participant name
For example
Bob = 100
Sarah = 20
Robert = 40
=Max(A1:A5),"Bob", "Sarah", "Robert" (obviously this doesn't work but you get the idea.)
Sorry about the lengthy description but if I've learned one thing it's that vague descriptions are very frustrating.
Any help is very welcome!
I build a spreadsheet a while back to help me track my work outs. It tracks several key areas like: duration, distance, type of work out, number of push-ups, pull-ups, sit-ups etc. It then compiles the data into a organized little group of cells to give an overview.
Well I decided to modify the sheet to include my brother. I was able to use 'IF' statements to compare the two sets of data and turn the whole thing into a big competition. Now if I have done more push-ups it shows my stats and his stats and the top row shows who is winning that category. It's pretty motivating honestly.
Well I guess I'm onto something here because now his wife wants in, and two of my good friends want to join. I'm using google docs so getting them access is easy but the coding is a bit beyond my knowledge.
I learned how to use QUERY function to pull data and arrange it by participant name. I can't however figure out how to compare the data so it displays who is winning in each category. The IF arguments aren't working because a simple true/false will no longer do the job.
I have tried using the MAX command but that only gives me the greatest cell value. Instead of cell value I would need the corresponding participant name
For example
Bob = 100
Sarah = 20
Robert = 40
=Max(A1:A5),"Bob", "Sarah", "Robert" (obviously this doesn't work but you get the idea.)
Sorry about the lengthy description but if I've learned one thing it's that vague descriptions are very frustrating.
Any help is very welcome!
Last edited:
