multiple column

  1. G

    Excel 2007: List Box (ActiveX Control) with multiple columns?

    I am working on an electronic version of an existing paper form. The user must be able to make multiple selections from 18 choices. Each choice has a corresponding check box. I have a List Box (ActiveX Control) with the following properties set: ListStyle: 1 - fmListStyleOption MultiSelect: 1...
  2. T

    Conditional formatting accross more than one collumn. dependant on specific word

    Hi, I have been building a database for my small business for the book keeping I am currently using: Windows 7 64bit Microsoft Excel 2010 Basically I have a price column and a Income/Expense column. I want the currency value in the price column to be red text if the word in the Income/Expense...
  3. S

    Sumifs with several criteria

    I am trying to write a formula that does the following: I have data with say 200 company names, their interest income each year, the year the income was generated, and who they received interest income from (one of 200 other companies). I want to sum the interest income (which is in 3 different...
  4. F

    Find the cell location of a result from a formula

    I have a simple max formula in Sheet1 that finds the max value from ranges of values in multiple other sheets. i.e. =MAX('Sheet 2'!A1:P44,'Sheet 3'!A1:P44,'Sheet 4'!A1:P44) I would like to show the location of that max value in the cell next to the value on Sheet 1, including both worksheet...
  5. cyrilbrd

    Multiple recurring events in Rows & Columns

    I would like to get your help on the following: I would like to create a calendar within excel that would be linked to a series of recurring events. Those events are happening every 15 days, and expected to occur for a period of up to 15 months (so 30 times in a row). We have about 1000 events...
  6. S

    Searching two columns based on a concatenated value of those columns and returning a corresponding value from a third column.

    Hello, I have three columns of data. I would like to concatenate the first two columns of each row and search that result based on a variable and then return the corresponding data from the third column for the row that matches the variable. E.g. Values in the rows going down in column 1 are A...
  7. C

    Multiple Columns

    Hi all I have 2 sheets: Sheet 1: Employee Name / DOB Smith, John / 19/08/1875 Richards, Tom / 14/06/1965 Jones, Wayne / 17/05/1978 Brown, Emily / 17/04/1985 Sheet 2: Employee Name / DOB / Attended? Smith, John / 19/08/1875 / No Jones, Wayne / 17/05/1978 / No Sheet 1 is a list of all...
  8. B

    Multiple sheet, multiple column consolidation

    Hi all, Below is the snapshot of a portion of my excel worksheet. There are multiple sheets of the same format (different row counts, column counts remain) in the workboork. 070SSM07001(3) <TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 12pt; FONT-FAMILY: Arial,Arial...

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