jun-19

  1. D

    Function to ignore hidding or previous columns

    Hello - I have data in range J3:v8. And another range from Y3:AV8. I want to subtract J3 from Y3, in columnd Z3, and K3 from AA3 in column AB3; essentially skipping the column before the range y3:av8. I've tried index columns, and offset(columns) function, and I just can't figure it out...
  2. K

    Clubbing data values

    hi, i have data in sheet 1 as per below data, and need a formula to get the data clubbed with similar data and get the output as per sheet 2 in columns A,B & C as per data below Sheet 1 <tbody> A B C 41001 MAY-19 350 41001...
  3. K

    Need a formula to calculate Monthly amount if every couple of months Amt is increased

    Hopefully this is as easy as the title makes it seem: I have the below data: <tbody> Month Month Number Total Cost Mar-19 3.00 71,250.00 Mar-19 3.00 71,250.00 Mar-19 3.00 41,250.00 Mar-19 3.00 41,250.00 Jun-19 6.00 16,988.00 Mar-19 3.00 13,904.21...

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