r1c1 formula

  1. E

    SUMIFS with a dynamic range and criteria fields in VBA

    Hi everyone! Trying to do a SUMIFS in VBA with the following setup, but lacking the knowledge to execute it correctly: =SUMIFS(sum_range, criteria_range1, criteria1) 1. sum_range = dynamic range six columns to the left of the active cell's position 2. criteria_range1 = dynamic range nine...
  2. G

    VBA Formula puts @ into cell and formula doesn't work properly

    Hi guys, I am using an R1C1 formula to put a formula into a cell. When I simply type the formula into the cell it works. When I use the vba below the result puts an @ in and then it doesn't work correctly as it only returns one sequence value and should return more. .Range("BQ2").FormulaR1C1...
  3. W

    Converting basic formula to R1C1 notation

    Hi there, Please can someone help convert =IF(F2=F1,"Y", "N") into R1C1 notation? Context I am inputting a formula in column AU which identifies duplicate values based on values in column F. In excel my formula in cell AU2 would be =IF(F2=F1,"Y", "N"). Cell AU3 would be then be...
  4. I

    FormulaR1C1 + Error 1004

    Hi, I have written some code that looks for column headings to locate the columns of data required in my formula, thus returning a column number. So logically the best method of creating my formula in the cell is to use the FormulaR1C1 function in vba, however I have been unsuccessful in getting...
  5. D

    R1C1 Formula and FIND function

    Hello everyone. Given: Columns P and Q Column P contains random values (Number Format) interspaced with unknown number of empty cells The aim is to write code which returns value into “Q” Cell and fulfils criteria as it follows below: If P Cell value = Nothing then Q Cell value = Nothing...

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