How to Make Excel Continue to Count Up for Each Row. Entering a series of sequential numbers into an Excel spreadsheet, one per row, can be a time-consuming and repetitive task.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.