Sunil Pinto
New Member
- Joined
- Jul 31, 2024
- Messages
- 24
- Office Version
- 2016
Dear All,
I have the amounts listed in Column A and the sub-groups in Column B. I need to determine the main group for each entry in Column C, based on the grouping method outlined on the left-hand side.(Find the details attached)
Could anyone assist me in developing a formula for Column C to automatically generate the main group details?
I hope my requirement is clear. Thank you in advance for your support!
Best regards,
Sunil PInto
I have the amounts listed in Column A and the sub-groups in Column B. I need to determine the main group for each entry in Column C, based on the grouping method outlined on the left-hand side.(Find the details attached)
Could anyone assist me in developing a formula for Column C to automatically generate the main group details?
I hope my requirement is clear. Thank you in advance for your support!
Best regards,
Sunil PInto