Forum Discussion

jimmytan9353's avatar
jimmytan9353
Copper Contributor
Mar 14, 2024
Solved

VLOOKUP returning sum of values with common value in one row

Hi all, my ERP spits out this report format, which I need to summarize into filterable report. We are a trading company, so we track our purchase and sales back-to-back in any single transaction. Eac...
excel
Formulas and Functions
jimmytan9353's avatar
jimmytan9353
Copper Contributor
Mar 18, 2024

Detlef_Lewin 

 

Hey, thanks! Is PQ an add-on? I think it's quite a steep learning curve, but I'll give it a try.

thank you once more :cool:

 

 

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Mar 18, 2024

    jimmytan9353 

    Since Excel 2016 PQ is a part of Excel.

    Most things can be done via the UI.

Resources