I'm not sure if I need a formula or a script for this, I've looked at almost every formula in excel and I can't figure it out! Here's what I'm trying to...

Hello. I'm trying to do as the title says. The numbers must be arranged "0000 000 0000" and I'm trying to get that format applied to all the numbers in a...

I am working with a two page workbook. On page one I have upper and lower values of a range (example 0.0 to 5.0, or 0 to 100) and an increment value (example...

I'm trying to set up dynamic ranges (with mixed text/numeric data) using the following base formula: =OFFSET($A$1,0,0,COUNTA($A:$A),1) I have a header in...

I accidentally saved over a worksheet with another file. Can I recover the original. I have searched and the most recent backup is from Feb. I do not have...

Sorry, this is obviously a really simply one, but the help comments are not making sense to me! I wish to format A1 (background colour) when its value is...

I have a problem that if able to use software that I am more accustom to, like MatLab, I would be able to fix fairly easily. Unfortunately I am only able to...

Hello, I have to compare two list and no vlookup does not work on this: On list 1, I have the names of people and cities that they visited. Eg. James New...

One- I have variety of size sheds that when keyed in a cell I need to return the sq.ft. or I expect to have to calculate sq.ft and enter each number and place...

Edit: Believe it or not I worked it out. Thanks anyway.

Excel 2010 Suppose I have the formula =Degree(A1) in cell B1. In cell C1 I write a formula using the formula in B1 as one of the parameters. I think I...

I'm doing some report making for my job, and pieced together this formula: =IF(D9=0,NA(),D9) with base formula of =IF(hostcell=0,NA(),hostcell) The formula...

Goal Show in one cell the surnames of band members (all in different cells on a roster page) as members of a particular band (which maintains the same name but...

I want to pull a number from a particular cell and then use that to create a cell reference for the cell in row Q and the column of that number, and look up...

hello I have a huge list of names; some of which are duplicates. However, its difficult to use the duplicate conditional formatting because there are spelling...

I am using an Index function, together with MATCH. The index refers to a separate workbook. The problem occurs when the INDEX imports data from an empty...

Hi, I want to open a exsiting CSV file and set the Data Format of column A (Date and time) to Date (m/d/yyyy) and column width to certain number. I can open...

I need a formula that will subtract positive numbers from negative numbers "and" negative numbers from positive, with the answer in the correct form, ie;...

I'm using excel 2007. I have 2 columns of data. A1:A8 contain various numbers only. B1:B8 contain numbers, text, & empty cells. I use the formula...

Greetings Excel Gurus, I would first like to thank everyone who will attempt to assit me in this matter as it has been a complete pain in my ass since I first...