Sort by color function

RAJESH1960

Well-known Member
Joined
Mar 26, 2020
Messages
856
Office Version
  1. 2019
Platform
  1. Windows
I am trying to sort the data by Line and cell color, but it is not displaying the sort correctly. In the data it should display 2 before 3,4,5,6,7, and so on... but it is showing wrong sort. Can anyone tell me what could be the problem.?
Book1
ABCDEFGHI
1LineDateNo.ParticularsVch TypeDebitCredit
2301-10-20204358JanuaryReceipt4400
3401-10-20204358FebruaryReceipt1300
4501-10-20204358MarchReceipt1450
5601-10-20204358AprilReceipt850
61203-10-20202185MayPayment21016
71303-10-20202185JuneReceipt1213
82103-10-20204422JulyReceipt1550
92203-10-20204422AugustReceipt7000
102303-10-20204422SeptemberReceipt1223
112403-10-20204422OctoberReceipt2610
122503-10-20204422NovemberReceipt2330
132603-10-20204422DecemberReceipt5400
142703-10-20204422JanuaryPayment113
154705-10-20204461FebruaryReceipt10740
164805-10-20204461MarchPayment740
17201-10-2020EAs Per DetailsReceipt8000
181103-10-2020EAs Per DetailsPayment19803
192003-10-2020EAs Per DetailsReceipt20000
204605-10-2020EAs Per DetailsReceipt10000
21101-10-2020JanuaryReceipt240
22702-10-2020FebruaryReceipt984
23802-10-2020MarchReceipt2785
24902-10-2020AprilReceipt100
251003-10-2020MayReceipt200000
261403-10-2020JunePayment90000
271503-10-2020JulyReceipt5079.28
281603-10-2020AugustReceipt41004
291703-10-2020SeptemberPayment1800
301803-10-2020OctoberReceipt4590
311903-10-2020NovemberReceipt3805.61
322804-10-2020DecemberReceipt200000
332905-10-2020JanuaryPayment21420
343005-10-2020FebruaryPayment18040
353105-10-2020MarchPayment190000
363605-10-2020AprilReceipt53.61
373705-10-2020MayReceipt754.84
383805-10-2020JunePayment236
393905-10-2020JulyPayment12147
404005-10-2020AugustReceipt389.85
414105-10-2020SeptemberReceipt3150
424205-10-2020OctoberReceipt4112
434305-10-2020NovemberPayment3800
444405-10-2020DecemberReceipt2340
454505-10-2020JanuaryReceipt4370
464905-10-2020FebruaryReceipt27720
475006-10-2020MarchPayment8734
48
Query
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
14,611
Office Version
  1. 365
Platform
  1. Windows
Best guess would be that you sorted it on the wrong column. Looks like it has been sorted by column C instead of column A.
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
37,633
Office Version
  1. 2019
  2. 2010
Platform
  1. Windows
It worked for me. How did you set up your sort? What I did was select Columns A:G, sort by cell color (green on top) for Column A, then I added another sort condition and again sorted by Column A but this time by value (lowest to highest) and that worked for me.
 
Solution

RAJESH1960

Well-known Member
Joined
Mar 26, 2020
Messages
856
Office Version
  1. 2019
Platform
  1. Windows
I had given only one sort function. With your suggestion, after adding another level of sort it worked for me too. I didn't think of it before....😉. Thanks Rick
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,821
Messages
5,766,638
Members
425,364
Latest member
jstubs99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top