inv-000021

  1. J

    Can some please explain this formula? I know what it does, just don't know why!

    =SUM(IF(IF(MATCH(Table1[Ivoice],Table1[Ivoice],0)=ROW(Table1[Ivoice])-ROW(Table1[[#Headers],[Ivoice]]),(ROW(Table1[Ivoice])-ROW(Table1[[#Headers],[Ivoice]])),0)<>0,Table1[Totals],"")) Can someone break it down and explain the meaning behind the inputs please? What does the ROW function do in...
    • Jarodjp42
    • Thread
    • inv-000014 inv-000021 inv-000105 inv-000110 inv-000117
    • Replies: 3
    • Forum: Excel Questions
  2. J

    Is there a way to remove duplicate in an formula?? Can you please assist on this formula

    I only know of the way to remove duplicates by going to data tab and under data tools click remove duplicates. Is there a way to sum the total amounts of invoices and remove the duplicates? Question: Calculate the total sum of the invoices. If there are duplicates invoices, only use the total 1...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top