aus

  1. M

    Transform multi-level table format, maybe with pivot table?

    I have an Excel 2016 file with a large set of panel data in the following actual form: <tbody> VAR ISO VALUE 1990 1991 1992 IMPORTS ARG 1,287 NA NA IMPORTS AUS 9,178 447 10,792 IMPORTS AUT NA NA 1,325 GDP ARG 153 206...
  2. K

    Formula to compare latest result vs the previous results. If difference state changed

    Hi Guys, I am using windows 10 and Excel 2010. <tbody> CUSTOMER COUNTRY ITEM CODE START EXPIRE PRICE Result P01 AUS APPLE/A01 26-Jan-17 10-Jan-18 75.00 P01 AUS APPLE/A01 11-Jan-18 11-Jan-19 75.00 PALOMA Vietnam APPLE/A01 05-Sep-17 30-Sep-17 36.00 PALOMA...
  3. S

    Index match column and row

    Hi, I am trying to index match with three different table ranges. I am apply the following formula in B16=IF(MATCH(A$15,$A$2:$B$2,0),VLOOKUP($A16,$A$3:$B$12,2,0)) the formula working fine but the problem is every time I have change table ranges. I need one formula for whole table range...

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