offset command

  1. S

    Finding the start of second list after xlDown

    Hi all, First time commenter, but I've learned a lot from reading other posts. I have a question that could cut my processing time in half, but I'm not sure if it's possible. I have data in columns P and R starting in row 3 and going a random length. I want to perform SUMPRODUCT on the two...
  2. B

    IF Statement question with offset function. HELP Please! :)

    I am trying to write a function with some built in logic to process a list of data. The list of data will be sorted from smallest to largest by FREQ/Vis column. This is done with a macro. What I think I need is an "If" function with an offset embedded into it. Below is the list of data that I am...
  3. A

    Offset Command

    Can someone please tell me about the usages of the offset command in the context of filtering data and summarizing based on links or control buttons?

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