How can we sort below column in excel
Price
$8.83
€ 98.76
£4.77
$3.74
$6.07
€ 3.32
£4.82
€ 3.66
$0.29
$0.51
€ 14.42
€ 1.56
£1.98
£14.32
like this..
Price
$0.29
$0.51
$3.74
$6.07
$8.83
€ 1.56
€ 3.32
€ 3.66
€ 14.42
€ 98.76
£1.98
£4.77
£4.82
£14.32
How can we sort below column in excel
Price
$8.83
€ 98.76
£4.77
$3.74
$6.07
€ 3.32
£4.82
€ 3.66
$0.29
$0.51
€ 14.42
€ 1.56
£1.98
£14.32
like this..
Price
$0.29
$0.51
$3.74
$6.07
$8.83
€ 1.56
€ 3.32
€ 3.66
€ 14.42
€ 98.76
£1.98
£4.77
£4.82
£14.32
with an helpcolumn in B and C
b2=if(left(a2,1)="$";a2;"")
c2=if(left(a2,1)="€";a2;"")
after that just count the columns.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Depends on your Excel version you can create a Custom Sorting list.
For Excel 2007:
http://office.microsoft.com/en-gb/ex...010222142.aspx
If you are happy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks