All articles with 'rows()' Tag

The other day I was watching Formula 1 on TV. I think it is the ideal game to follow for a lazy dude like me. It is on every other weekend. It takes .32 seconds to understand the game and 3.2 seconds to know the points and scoring mechanism. But I am not here to convince you to follow the game. While looking at score boards, it struck me,

“how about writing excel formulas for sorting a list of durations (or numbers) in the formula 1 order?”

Cheryl asks via e-mail, “I was wondering if you could help me figure out how to combine the round formula with the rank formula? I need to first round all the numbers and then rank them.”

Of course we can solve this by simply using array formulas. Curious? Find out more by reading the rest of this post.