Name sequence with letter in Excel

Question

Hi,

I have two columns in microsoft excel. A1 and B1

A1 is for User Display Name. B1 is for User's E-mail id.

I want to set User Display Name in sequence (letter wise) for example, the names which are starting with A. It should be shown first. Then B, C and so on.

But when Display Names will make in sequence. User's email id should be in sequence according to the display name.

Please tell me any formula in Microsoft excel. Thanks

Answer 1

@HASSAN BIN NASIR DAR

If you are not a Microsoft 365 subscriber, you could use the formula to get the sort of "User Display Name", then get the search results as "User's E-mail id based" on "User Display Name".

Sort of "User Display Name", please enter following formula, and then press Ctrl+Shift+Enter at the same time.
=INDEX(A$2:A$5,MATCH(ROWS(A$2:A2),COUNTIF(A$2:A$5,"<="&A$2:A$5),0))

"User's E-mail id based", please enter below formula.
=VLOOKUP(F2,A$2:B$5,2,FALSE)

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

@HASSAN BIN NASIR DAR

Could you please tell us which version of Office are you using now?

If you are using Microsoft 365 apps, please try the SORTBY function.
For my simple sample, we could use the formula =SORTBY(A2:B5,A2:A5,1).

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.