I'm relatively new to excel and have no experience with vba and macros, so any help is greatly appreciated!
I am working on a spreadsheet to track physical fitness tests.
I need the formula in the Pass/Fail column to auto-populate based on the age I have entered. Each formula is unique to each age group (20-29, 30-39, 40-49, 50-59) and what their qualifying times are.
Are there any macros that may be able to help me?
Thanks
What are the criteria for each age range to Pass?
Edit: OOPS! I see them in your formulae.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
No VBA necessary. Used Vlookups. Look at the attached.
That's perfect, thank you.
Couple more questions:
-Is there a way to fill the cells red/green in the formula based on passing/failing scores without using the conditional formatting?
-Can the gender be factored into this formula where females have different requirements?
Thanks!
Coloring of the cells would require conditional formatting. Because requirements for gender will vary, I suspect that you will need to replicate the look up table I provided and use a similar formula, but on a separate worksheet. Vlookup can only support one value being looked up. However, having said that, I can think of a work around. Suppose you used the age for men as 120, 130, 140, 150 and for women you used 220, 230, 240, 250. Then you could do it in one lookup table and one spreadsheet of data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks