I am trying to build a macro for an answer sheet in such a way that, it performs the below functions when I click on the “SUBMIT� . The sheet contains...

I have 20 columns which I am using top 10 conditional formatting. When I copy this (B3:T3) down to the bottom of my spreadsheet, the range changes to...

Hoping someone far smarter than myself can help. The below formula will give a result where column A=Monday, col B=John and sum the corresponding values in...

Good day and thanks for reading. I am working on a file where a cell contains data separated by a comma. ex: Col A ...

Why is it that some spreadsheets will not allow you to edit cells automatically when tabbing between windows? i.e. some spreadsheets will require you to...

WHEN DUPLICATING DATA USING =WORKSHEET1!A1, ON ANOTHER WORKSHEET WHY IS IT THAT IT CAN ONLY DO NUMBERS NOT TEXT I'M SURE THERE'S A WAY CAN ANYONE HELP THANKS...

A few months ago I had asked a question and got this answer: Question: I have a a set of values in A1 through A100. I need to look up each value and find a...

Hi, I am trying to make a calculation that will take Pass/Fail values of P or F and give me an overall value of P or F. There is also an issue if a value is...

Hi. Sample data: R1: No, Yes, No R2: Yes, Yes, Yes R3: No, No, No How do get a count of the rows that contain No? So for the sample above, the...

I am in need of an Excel speadsheet that will calculate my company financal RONA or "Return on Net Asset"

I have a small work book, tracks deliveries made and trucks used. I have seven sheets Saturday thru Friday and one sheet that totals everything up! The...

Hi to everyone, is it possible to view a matrix in table mode? I have a matrix like this b c d e f ... b 1 0 3 4 5 c 2 5 8 6 ...

I am using Excel 2003 I have a price table for each of our products. Ex: Product #xxx - 1 item cost $100. Price B for 2-5 items cost (=100*.95%), Price C...

Source sheet Column J contains the vlaues for condition 1 Column B contains the values for condition 2 Column D contains the numbers I wish to average In my...

I have a range of dates in a column and I would like it if I could highlight any date that is more that 3 years old. So if the date reads 02/10/2004 this...

I used the Autosum button (on the top toolbar) all of the time and would like to set up a shortcut key. Since this button is not in a Menu, I cannot add it in...

First time in the Excel Section... Be gentle please! I have a spreadsheet which lists all visits by all clients. With this information, I wish to create a...

Google Adsense Account Approval Tricks New Unique Genuine Google Adsense Account Approval Trick Only For Rs. 1000/-. Take This Trick & Create Unlimited...

Hi I have the following workbook: Sheet 1 contains Tax Rates A1 B1 C1 20% 40% 60% Sheet 1 further down the sheet contains the following...

Hi, I am trying to add several VLOOKUP results obtained from data in several worksheets. My formula is : - =VLOOKUP(A5,'Common Costs -...