column as variable

  1. S

    Count IFs Formula With Dates

    Hello, Currently i'm using the following formula below to identify how many shifts are scheduled by criteria by day. Currently i have to change the row letter for the column each time. is there a simpler way of doing this? =COUNTIF(B2:B4,A7) Example: <tbody> a b c d e f g h i j k l 1...
    • Sparda142
    • Thread
    • column as variable countif and excel formula dates between help excel formula pm-200
    • Replies: 3
    • Forum: Excel Questions
  2. A

    Copy formulas in changing column (numberered by week)

    Hi, I have a tracker where I track weekly costs. I have formulas in column BR which bring back all the data that I need. I need to copy the data in column BR and paste it as values into the column with this weeks week number in it. Please see below: <tbody> Insert Week...
  3. J

    VBA finding SUM of all cells to left of cell

    I need a VBA formula to enter in a cell in a certain row (row # = WeeklyTotalsAddRow variable) in the column with the header "Total" in row 1 that will give me the sum of all the cells to the left of this cell except columns A-C. The column with the "Total" header could be anywhere from column...
  4. M

    n00b to VBA needing assistance

    Hi All, I am new to the world of VBA, and have starting to feel a little frustrated with something I thought would be simple enough to do, but isn't working the way I would have hoped. I have a large table of data with three columns. The first column consists of an ID value incrementing from 1...
    • Mr_Mooo
    • Thread
    • column as variable data analysis data between sheets transpose macro
    • Replies: 2
    • Forum: Excel Questions
  5. L

    Referencing data in a column which changes length daily

    Hi all, Situation: I have a column of data 'reference column' which changes length on a daily basis. In other columns 'formula columns' I have formulas which are dependent on the 'reference column' data. Current Solution: My data length will not be longer than 1000 rows. For all my 'formula...
    • lewis1
    • Thread
    • column as variable formula & macro formula auditing
    • Replies: 2
    • Forum: Excel Questions
  6. C

    Need Help for Rearranging Data with Macro or Formula

    Hello All, This might be very easy for some of you. I have a data sheet like below: ID P1 P2 ... Pn 1 A 2 A B 3 B A .... C . . So in each row there are different number of columns with values. Id like to arrange it into; ID P Rank 1 A First 2 A First 2 B Last 3 B First 3...
    • culyus
    • Thread
    • array data column as variable rearrange rearrange data vba
    • Replies: 5
    • Forum: Excel Questions
  7. K

    Auto Filter column(variable i)

    Hi, I am using the following code to populate a column (the position of this column changes so it is variable i), and then I need to autofilter this column. I keep getting the error "Run-time error '1004': AutoFilter method of Range class failed" on the red line of code below. Any ideas on how...

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