MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Height (as in how tall)

Posted by Bill E. on July 31, 2000 7:32 PM

Creating a player roster for my hockey team and I'm stumped as to how to get an average and mean for height (in feet and inches). Do I need to create a seperate column for feet and inches? HELP!

Posted by Ivan Moala on July 31, 0100 9:26 PM

Getting avg + mean height in ft & inch depends
on how you have entered your data eg either as
decimal (6.1 ft) or 6'2" as a formated text.
You can create seperate columns BUT there is always
another way depending on your data format.
Let us know.