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...
=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...
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...
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!
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 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.