There are a couple of reasons that you have not received a resonse much earlier.
1.
You have not given any
logic of how group type and amount determine the category. You are obviously familiar with the data and what it means, but helpers here likely have no idea so you need to fill us in.
2.
Many of the helpers here choose not to download files from other sites or, due to security restrictions at their workplace, are unable to download such files.
You will generally get more potential helpers & faster if you explain your problem clearly in words and, if needed, post a small (copyable) screen shot or two directly in your post. My signature block at the bottom of this post has help regarding that - see the XL2BB link.
Anyway, see if this is what you want.
| Excel Task.xlsx |
|---|
|
|---|
| A | B | C |
|---|
| 7 | Amount | Group | Formula-Result |
|---|
| 8 | (498.31) | Borrowings | Borrowings |
|---|
| 9 | (850.00) | Borrowings | Borrowings |
|---|
| 10 | (656.25) | Borrowings | Borrowings |
|---|
| 11 | (758.77) | Payables | Trade Payables |
|---|
| 12 | (153.00) | Payables | Trade Payables |
|---|
| 13 | 2,021.74 | Assets | Assets |
|---|
| 14 | (1,525.00) | Payables | Trade Payables |
|---|
| 15 | (218.75) | Payables | Trade Payables |
|---|
| 16 | 697.70 | Assets | Assets |
|---|
| 17 | 2,424.00 | Payables | Other Receivables |
|---|
| 18 | 1,965.04 | Payables | Other Receivables |
|---|
| 19 | (1,260.00) | Payables | Trade Payables |
|---|
| 20 | 1,564.67 | Payables | Other Receivables |
|---|
| 21 | (315.00) | Payables | Trade Payables |
|---|
| 22 | 1,386.00 | Related Parties | Due from Related Parties |
|---|
| 23 | 262.50 | Related Parties | Due from Related Parties |
|---|
| 24 | (682.50) | Related Parties | Due to Related Parties |
|---|
| 25 | (472.50) | Related Parties | Due to Related Parties |
|---|
| 26 | (815.00) | Related Parties | Due to Related Parties |
|---|
| 27 | (584.00) | Related Parties | Due to Related Parties |
|---|
| 28 | 1,940.00 | Related Parties | Due from Related Parties |
|---|
| 29 | 75.00 | Related Parties | Due from Related Parties |
|---|
| 30 | 1,883.00 | Payables | Other Receivables |
|---|
| 31 | 353.63 | Payables | Other Receivables |
|---|
| 32 | 964.00 | Payables | Other Receivables |
|---|
| 33 | 102.42 | Cash & Bank | Cash & Bank |
|---|
| 34 | 146.00 | Cash & Bank | Cash & Bank |
|---|
| 35 | 2,696.57 | Cash & Bank | Cash & Bank |
|---|
| 36 | (244.20) | Trade Receivables | Other Payables |
|---|
| 37 | 622.81 | Trade Receivables | Trade Payables |
|---|
| 38 | (69.00) | Trade Receivables | Other Payables |
|---|
| 39 | 1,260.00 | Trade Receivables | Trade Payables |
|---|
| 40 | (1,495.00) | Trade Receivables | Other Payables |
|---|
| 41 | (1,500.00) | Payables | Trade Payables |
|---|
| 42 | 595.11 | Trade Receivables | Trade Payables |
|---|
| 43 | (580.75) | Payables | Trade Payables |
|---|
| 44 | 75.00 | Trade Receivables | Trade Payables |
|---|
| 45 | (269.66) | Payables | Trade Payables |
|---|
| 46 | (960.75) | Payables | Trade Payables |
|---|
| 47 | (1,342.12) | Payables | Trade Payables |
|---|
| 48 | 607.15 | Trade Receivables | Trade Payables |
|---|
| 49 | 488.00 | Trade Receivables | Trade Payables |
|---|
| 50 | (110.00) | Trade Receivables | Other Payables |
|---|
| 51 | (446.25) | Payables | Trade Payables |
|---|
| 52 | (39.07) | Trade Receivables | Other Payables |
|---|
| 53 | (52.11) | Trade Receivables | Other Payables |
|---|
| 54 | (31.84) | Trade Receivables | Other Payables |
|---|
| 55 | 720.00 | Payables | Other Receivables |
|---|
| 56 | (787.50) | Payables | Trade Payables |
|---|
| 57 | (525.00) | Payables | Trade Payables |
|---|
| 58 | 1,017.54 | Trade Receivables | Trade Payables |
|---|
| 59 | (667.86) | Payables | Trade Payables |
|---|
| 60 | 1,917.57 | Trade Receivables | Trade Payables |
|---|
| 61 | (603.75) | Payables | Trade Payables |
|---|
| 62 | (1,178.10) | Payables | Trade Payables |
|---|
| 63 | (692.75) | Payables | Trade Payables |
|---|
| 64 | 2,517.00 | Related Parties | Due from Related Parties |
|---|
| 65 | 609.78 | Trade Receivables | Trade Payables |
|---|
| 66 | (1,050.00) | Payables | Trade Payables |
|---|
| 67 | (259.39) | Payables | Trade Payables |
|---|
| 68 | (787.50) | Payables | Trade Payables |
|---|
| 69 | 807.43 | Payables | Other Receivables |
|---|
| 70 | 717.48 | Payables | Other Receivables |
|---|
| 71 | 823.32 | Payables | Other Receivables |
|---|
| 72 | (525.00) | Trade Receivables | Other Payables |
|---|
| 73 | 95.00 | Trade Receivables | Trade Payables |
|---|
| 74 | (315.00) | Payables | Trade Payables |
|---|
| 75 | 102.83 | Payables | Other Receivables |
|---|
| 76 | 682.80 | Related Parties | Due from Related Parties |
|---|
| 77 | (455.00) | Borrowings | Borrowings |
|---|
| 78 | (598.50) | Borrowings | Borrowings |
|---|
| 79 | (577.50) | Borrowings | Borrowings |
|---|
| 80 | (120.00) | Borrowings | Borrowings |
|---|
| 81 | (488.00) | Borrowings | Borrowings |
|---|
| 82 | (1,460.17) | Borrowings | Borrowings |
|---|
| 83 | (396.25) | Borrowings | Borrowings |
|---|
| 84 | (504.00) | Borrowings | Borrowings |
|---|
| 85 | (1,510.00) | Borrowings | Borrowings |
|---|
| 86 | 1,525.00 | Cash & Bank | Cash & Bank |
|---|
| 87 | (130.00) | Borrowings | Borrowings |
|---|
| 88 | (571.57) | Borrowings | Borrowings |
|---|
| 89 | (540.75) | Borrowings | Borrowings |
|---|
| 90 | 775.00 | Cash & Bank | Cash & Bank |
|---|
| 91 | (766.50) | Borrowings | Borrowings |
|---|
| 92 | 566.00 | Cash & Bank | Cash & Bank |
|---|
| 93 | 1,009.97 | Cash & Bank | Cash & Bank |
|---|
| 94 | 1,827.00 | Cash & Bank | Cash & Bank |
|---|
| 95 | (225.23) | Borrowings | Borrowings |
|---|
| 96 | (279.98) | Borrowings | Borrowings |
|---|
| 97 | (247.00) | Borrowings | Borrowings |
|---|
| 98 | (1,310.00) | Borrowings | Borrowings |
|---|
| 99 | 1,387.62 | Cash & Bank | Cash & Bank |
|---|
| 100 | 128.90 | Cash & Bank | Cash & Bank |
|---|
| 101 | 1,482.52 | Cash & Bank | Cash & Bank |
|---|
|
|---|
