SORTING DATA IN TWO COLUMNS (salary and name ) - sorting as perdescending order of salary

V

vijay.ganesh.yadav

Dear Excel experts,

I have to sort data in two columns ,first column contains name and second column contains salary.
The new columns should contain salary in descending order and name in corresponding cell.


A small example is given below -
DATA available-
Column A(name) Column B(salary)
KISHAN 60000
AJAY 24000
SANGEETA 60000



OUTPUT required with help of formulae -
Column C(name) Column D(salary)
KISHAN 6000
SANGEETA 60000
AJAY 24000


Kindly help WITH THE FORMULA TO BE USED IN NEW COLUMNS.

Regards
Vijay Yadav
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting in Excel 2
help: sorting rows by lesser value of two columns 1
sorting column order 1
Macro/SUB to merge two columns of text 3
Sort on last two digits of data 3
VBA - splitting name and re building in specific order 2
Sorting Multiple Columns in a single operation? 2
To enter data in columns in required order in some special way and toensure this 2

Top