Sort by color function

[RAJESH1960]

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
	A	B	C	D	E	F	G	H	I
1	Line	Date	No.	Particulars	Vch Type	Debit	Credit
2	3	01-10-2020	4358	January	Receipt	4400
3	4	01-10-2020	4358	February	Receipt	1300
4	5	01-10-2020	4358	March	Receipt	1450
5	6	01-10-2020	4358	April	Receipt	850
6	12	03-10-2020	2185	May	Payment		21016
7	13	03-10-2020	2185	June	Receipt	1213
8	21	03-10-2020	4422	July	Receipt	1550
9	22	03-10-2020	4422	August	Receipt	7000
10	23	03-10-2020	4422	September	Receipt	1223
11	24	03-10-2020	4422	October	Receipt	2610
12	25	03-10-2020	4422	November	Receipt	2330
13	26	03-10-2020	4422	December	Receipt	5400
14	27	03-10-2020	4422	January	Payment		113
15	47	05-10-2020	4461	February	Receipt	10740
16	48	05-10-2020	4461	March	Payment		740
17	2	01-10-2020	E	As Per Details	Receipt	8000
18	11	03-10-2020	E	As Per Details	Payment		19803
19	20	03-10-2020	E	As Per Details	Receipt	20000
20	46	05-10-2020	E	As Per Details	Receipt	10000
21	1	01-10-2020		January	Receipt	240
22	7	02-10-2020		February	Receipt	984
23	8	02-10-2020		March	Receipt	2785
24	9	02-10-2020		April	Receipt	100
25	10	03-10-2020		May	Receipt	200000
26	14	03-10-2020		June	Payment		90000
27	15	03-10-2020		July	Receipt	5079.28
28	16	03-10-2020		August	Receipt	41004
29	17	03-10-2020		September	Payment		1800
30	18	03-10-2020		October	Receipt	4590
31	19	03-10-2020		November	Receipt	3805.61
32	28	04-10-2020		December	Receipt	200000
33	29	05-10-2020		January	Payment		21420
34	30	05-10-2020		February	Payment		18040
35	31	05-10-2020		March	Payment		190000
36	36	05-10-2020		April	Receipt	53.61
37	37	05-10-2020		May	Receipt	754.84
38	38	05-10-2020		June	Payment		236
39	39	05-10-2020		July	Payment		12147
40	40	05-10-2020		August	Receipt	389.85
41	41	05-10-2020		September	Receipt	3150
42	42	05-10-2020		October	Receipt	4112
43	43	05-10-2020		November	Payment		3800
44	44	05-10-2020		December	Receipt	2340
45	45	05-10-2020		January	Receipt	4370
46	49	05-10-2020		February	Receipt	27720
47	50	06-10-2020		March	Payment		8734
48
Query

 

[jasonb75]

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]

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.

 

[RAJESH1960]

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