nth column

  1. G

    Return the column number of the nth occurrence in a row

    Hi, I couldn't find this answered exactly on the forum. Sorry if it has. I am looking to return the column number of the nth occurrence in a row. So in the example in the table below, I am looking to return the column number in row 1 of the 2nd (B4) occurrence of the word 'dog' (B3). In this...
  2. K

    Array Formula for Nth Column Average .. can any one see my error?

    =SUM(IF(MOD(COLUMN(B2:I2),2)=2)B2:I2)=SUM(IF(MOD(COLUMN(B2:I2),2)=2)B2:I2) =AVERAGE (IF(MOD(COLUMN('RAW DATA ENTRY'!C4:'RAW DATA ENTRY'!Z4),7)=0 )'RAW DATA ENTRY'!C4:'RAW DATA ENTRY'!Z4) Can Anyone help me? I am trying to work out average and sum of every 2 or 7 columns. I'm pretty new to...
  3. E

    Adding alternate columns only if they visible

    Hi, I have data in a sheet which runs from column 'F' to column 'GU' over hundreds of rows. Every column (with headers on row 7) is alternatively named "Hours" and "Fees". Is there a way to have a total figure in columns 'GW' (for Hours) and 'GX' (for Fees) which adds up the respective Hours...
  4. N

    Macro to set a vlookup

    Hello, I am looking for a macro to insert a vlookup in row 2 for every 5th column? Current vlookup forumla: vlookup(E1,vlookup!$A:$B,2,0) Any help would be appreciated!
  5. C

    Copying every Nth column to a new sheet (Excel 2007)

    Hi everyone, I'm new to anything that's not basic unfortunately, so apologies right off! I'm currently trying to analyse a huge amount of data (each file contains a minimum of columns A --> BRL) and I'm trying to extract certain columns to the next sheet to simplify the analysis. For one...

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