multiple column

<tbody> Labour Cost Cleaning 200.58 Travel Time 489.56 Wet Time 55.00 Set- UP 855.00 Operating Equipment 780.00 Spotter 200.00 Supervision 1200.00 </tbody> I need a formula that gives me the top 5 values in Col B and then Displays them with the appropriate Value in Col A As such...

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

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

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

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

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

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

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

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