RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- 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 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
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 |