column reference change

  1. M

    Formula works, then doesn't

    Hello, I am at a loss as to what is happening here. I have some survey data on one sheet, and I am putting together a summary on another sheet. I want mean, standard deviation of the sample, and median for some of the data. I am compiling the summary statistics both for all surveys and for...
    • mhessnm
    • Thread
    • column reference column reference change formula if formula logical test
    • Replies: 6
    • Forum: Excel Questions
  2. D

    How to drag columns to the right and change row reference by one for every 6 columns dragged

    Hi Mr. Excel, How can I drag columns to the right and change row reference by 1 every six columns, for example: Sheet2 A column will reference Sheet1 $A$2 Sheet2 G column will reference Sheet1 $A$3 Sheet2 M column will reference Sheet1 $A$4 Ideally I would like to drag a range from Sheet2...
    • ddgale
    • Thread
    • column reference change row reference change
    • Replies: 12
    • Forum: Excel Questions

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