Creating a Priority List With #Excel by David Hager


In my previous article I demonstrated a technique to show a list based on priority.

Since I wanted the solution to be a single cell, single formula technique, the calculation was somewhat complex and the TEXTJOIN function was used to create the string. For that technique, you have to have the Excel version included in Office 365 in order for the TEXTJOIN formula to work. But, many people do not have access to that Excel version. So, I decided to publish a solution that does not require TEXTJOIN. Although this method uses several intermediate steps, in many ways it is much simpler to implement.

In the list are columns defined as Item and Priority respectively. To obtain the priority list, place consecutive numbers from 1 to 5 (per the values in Priority) in column C starting at C2. Then, put the following formula in cell D2 and fill down.


That gives the priority list in column D in cells. If you want to reproduce the text string as per the previous article, place this formula in cell F14 as shown in the figure.



You can download the example file here.


3 thoughts on “Creating a Priority List With #Excel by David Hager

  1. Pingback: #Excel Super Links #119 – shared by David Hager | Excel For You

  2. Mike Benstead

    What you have described here is a ranking system requiring no manual sorting.
    Consider utilising this with calendar dates also – very powerful.

  3. W-Hemant

    Hi David. Is it possible to do the things this android application do in excel – Prioritize Me! – Goals & Todos.
    If yes how to do it


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s