Find & filter Formula

[kme]

1.Here in "Table-1" the invoice number of 5 branches is given from which only branch name should be filtered through excel formula.
2.As shown in Table-3, the answer should come through Excel formula in Table-2.
3.If Subtotal appears in Table-1, then the branch name should appear in the line above which the invoice number of the branch. is as shown in Table-3.

Sample Answer Given In Table-3 typed manually .Same Answer Should Came In Table-2 through Excel Formula

 

[vletm]

Your 3rd version from

Excel formula ... find

1.Here in "Table-1" the invoice number of 5 branches is given from which only branch name should be filtered through excel formula. 2.As shown in Table-3, the answer should come through Excel formula in Table-2.

chandoo.org

Your original version has closed now.

 

[vletm]

kme​

How to choose, which branch name should be light blue?
eg CUSTOMER-1 has ... two kind of branch names?

 

[kme]

If Subtotal appears in Table-1, then the branch name should appear in the line above in which the invoice number of the branch In Table-1. is as shown in Table-3.

Example : - "SrVe:2024BRB-2417" This Invoice Number Above the "Subtotal" Colum . So In Table-3 subtotal Same Line Branch Name Should "BRB"




if Customer-1 Came Then The Table-3 Came Blank

 

[vletm]

kme​

Where comes data for TAABLE-1?

 

[kme]

Its System Voucher Number. Can Find Branches Through Voucher Number .

If Voucher Number "SrVe:2024RWA-1827" Then the Branch Name " RWA"
If Voucher Number "SiVe:2024BRB-24434" Then the Branch Name " BRB"
If Voucher Number "SiVe:2024BBO-2414" Then the Branch Name " BBO"
If Voucher Number "SiVe:2024BREC-14900"Then the Branch Name " BREC"

 

[vletm]

kme​

Asked about TAABLE-1 ... You wrote something about TABLE-2.
>> cell E7 has one possible solution - it needs I-column table too.

 

[kme]

Thanks