Aug 14 2022 08:12 PM - edited Aug 23 2022 01:24 AM
Template
No | Div | Initiative | Prioritization | Budget Type | Budget Approve Amount |
Table data
Division | Initiative | Prioritization | Capex | Opex |
a | Project A | P2 | 315,000.00 | |
b | Project B | P1 | 2,400,000.00 | 860,000.00 |
a | Project C | P3 | 860,000.00 | |
d | Project D | P4 | 5,000,000.00 | |
c | Project E | P2 | 5,000,000.00 | |
a | Project F | P3 | 9,140,000.00 | |
d | Project G | P4 | 5,000,001.00 |
Aug 15 2022 01:22 AM
All participants here are users like you who voluntarily spend some of their free time to help others. So you cannot expect an immediate reply.
Where do you want to select division A? And could you provide an example of what the output should look like?
Aug 23 2022 01:20 AM
Aug 23 2022 02:11 AM
@AMZI2001 What about filter function like
=FILTER(A2:E8,A2:A8=G2)
where G2 is your dropdown cell and select a.