Get Data from two columns without Duplication By Multiple Conditions

[Hany ali]

Hello My Dear ,I want your Help To get Data from Column B,C,N,O To Columns Q :T Sart From Third Row without Duplication By Multiple Conditions

The amounts in the column N should be taken according to the type of currency in the column O and placed in the two columns S & T according to the type of currency in the two cells S2 & T2​

When get data, you must take into account 4 items in the column C , which must be retrieved under the same name as the previous Excursion Name​

1-National Park Fees
2-Extra Cost
3-Island Fees
4-Tips
Thanks in advance for your great efforts

 

[Peter Bartholomew]

Using 365

= LET(
    distinct,       UNIQUE(supplier_excursion),
    supplier,       TAKE(distinct,,1),
    excursion,      TAKE(distinct,,-1),
    category_total, SUMIFS(total,
        supplierName, supplier,
        excursionName, excursion,
        currencyType, {"L.E","$"}
    ),
    HSTACK(distinct, category_total)
  )

 

[Peter Bartholomew]

Please find copy of file attached (without macro).
The formula is a standard Excel 365 worksheet formula that uses Dynamic Arrays and newly released functions.
True, it bears little resemblance to traditional spreadsheet methods.

 

[Hany ali]

thanks alot , But I wish there were normal equations because I am very weak in Power Query
thanks alot.But this is not what is required, as I do not want these items
1-National Park Fees
2-Extra Cost
3-Island Fees
4-Tips
to be in a Excursion Name column ..As explained #1 Post

 

[vletm]

Hany ali​

Instead of any Formula solution as above
Could You use Pivot-table?

Did Your The Result Must Be Like That showed only part of Your expected results?
... Is there any Island Fees somewhere?
Those needed Excursion Names can select from Pivot-table (cell W3).

Check this one sample...

 

[Hany ali]

Thanks Alot

vletm These are exactly all the results to be fetched, located starting from the Q column tO T Column ... if Possible by Standard Formula Not Pivot-table​

 

[vletm]

Hany ali​

Maybe someone else would solve this by 'Standard Formula' too.

 

[Peter Bartholomew]

thanks a lot. But this is not what is required, as I do not want these items
1-National Park Fees
2-Extra Cost
3-Island Fees
4-Tips
to be in a Excursion Name column ..As explained #1 Post

I can exclude the sundries easily but assigning them to the excursion is a bit more messy. At the moment I do not know what methods you can accommodate; every formula I write is specific to 365.