SanjayGMusafir
Well-known Member
- Joined
- Sep 7, 2018
- Messages
- 1,503
- Office Version
- 2021
- Platform
- MacOS
Hi Experts
Got stuck up in a strange situation. Tried copying XL2BB from original file - It failed. So copied the actual data to a blank worksheet to explain a situation.
What I need to do -
Please help
Thanks in advance.
Got stuck up in a strange situation. Tried copying XL2BB from original file - It failed. So copied the actual data to a blank worksheet to explain a situation.
What I need to do -
- Filter dates based on Financial year (April 1 to March 31 - in India) - May see the blue highlighted rows
- Add the values in column B out of that filtered data BUT
- Take the Value corresponding to date which is Higher B12 (Highlighted Red) for same values in Column C
- Include B12 Value and exclude B10 value as A10 is smaller than A12
Please help
Thanks in advance.
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 12/31/21 | 34,400 | 405 FF | |||
2 | 12/31/21 | 14,000 | 979/GH5&7 | |||
3 | 4/30/22 | 11,000 | 527/GH5&7 | |||
4 | 6/30/22 | 13,500 | 647/GH5&7 | |||
5 | 11/30/22 | 13,000 | 1197/GH5&7 | |||
6 | 11/30/22 | 10,000 | 256/GH5&7 | |||
7 | 11/30/22 | 38,200 | 405 FF | |||
8 | 11/30/22 | 15,000 | 979/GH5&7 | |||
9 | 3/31/23 | 12,000 | 527/GH5&7 | |||
10 | 5/31/23 | 14,580 | 647/GH5&7 | |||
11 | 7/31/23 | 10,000 | 720/GH5&7 | |||
12 | 8/30/23 | 15,700 | 647/GH5&7 | |||
13 | 9/29/23 | 12,800 | 527/GH5&7 | |||
14 | 10/31/23 | 14,000 | 1197/GH5&7 | |||
15 | 10/31/23 | 10,000 | 256/GH5&7 | |||
16 | 10/31/23 | 41,300 | 405 FF | |||
17 | 10/31/23 | 16,500 | 979/GH5&7 | |||
18 | 8/31/24 | 11,000 | 720/GH5&7 | |||
19 | 9/30/24 | 15,400 | 1197/GH5&7 | |||
20 | 9/30/24 | 10,500 | 256/GH5&7 | |||
21 | 9/30/24 | 44,600 | 405 FF | |||
22 | 9/30/24 | 16,500 | 979/GH5&7 | |||
23 | 2/28/25 | 12,500 | 647/GH5&7 | |||
24 | 3/31/25 | 12,000 | 527/GH5&7 | |||
Sheet1 |