autofill columns to rows

  1. A

    AutoFill formula in a column based on data in a row

    Say I have an attendance list for a class: Student Class 1 Class 2 Class 3 Total Alpha X X X COUNTIF(B2:C2,"X") = 3 Bravo X 1 Charlie X X X 3 Delta X X 2 Echo X X X 3 Foxtrot X X X 3 Golf X X X 3 The Class1:Class3 fields are data-validated to have Xs or Blanks...
  2. I

    Autofill rows, increment column reference

    I need a count if formula that can autofill downwards but increment the column references. For Example, A row 1=countif('Sheet1'!H:H,1) row 2=countif('Sheet1'!I:I,1) row3=countif('Sheet1'!J:J,1) and if possible have the column reference increment by 3, if not then the above is fine. so the...
  3. P

    Can I use autofill horizontally and than vertically?

    Basically I have data in columns I and J. When i drag the following formula (in column K) down, it checks if any two consecutive values in column J are equal to the top two (J3 and J4), and if so, it returns an answer. IF(AND($J$3=$J5,$J$4=$J6,),($I$3-$I5)+($I$4-$I6),0) My problem is that I...
  4. D

    auto fill so A1:A30 becomes A1:AD!

    I am trying to enter a cell reference in Sheet1, cell A1 that says =sheet2!A1. When I drag across and autofill I want sheet1!B2 to equal sheet2!A2. I tried transpose but it copies values. I need the cell reference too. Not just the value. Thanks!

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