I created a named range using the name: Overall Segment Size - Street $(M)
Excel automatically converts the name to get rid of special characters and
spaces to: Overall_Segment_Size___Street___M
The question is:  Is there a function which allows me to convert the names

How can I get a formula result to be an actual empty cell (usually when using
the IF function). I know that "" of NA() is an option to get a Blank cell,
but this results in errors when the result of this formula is used in another
function.

I would like to create a list of numbers (ie: from A2:A25). Then have a field
that a user can put in a number to indicate the number of rows to sum into a
third field. Ie: input the number 3 to cell C1. The sum of cells A2:A4 would
be returned into the result field, say, cell C3. ...

I need to use VLookup with a word in the middle linked from anothe
cell.
IE:
VLOOKUP(A5,(A word from Cell E17),2,FALSE)

I have the following IF function that works great on the first seve
rows. Starting with row 8, every row until the end of the colum
evalautes to false and outputs the false statement incorrectly on th
sheet. Please help by telling me what I am doing wrong or may no

I have created a drop down menu in a cell and when I click on the info I want
in the drop down menu and I exit out and excel prompts me to save info I
click yes, however when I bring excel back up to look at the form again the
info in the drop down shows up breifly (2 sec.) than ...

I'm looking for a way to combine two words.
A1 is a drop down menu with different words in it that serve as
prefix.
I'm looking for a way to make it so it shows =A1(suffix)

Basically, I want to VLOOKUP a dropdown list.
In simpler terms. I want to do a dropdown list for option A.
The dropdown has A, B, C, D. If you pick A I want VLOOKUP to brin
forth another dropdown list to show options A1, A2, A3 and A4.

I have what I hope will be a nice easy question for you guys... :)
I'm putting together a worksheet for our local sports league. I want to
append the scores from two cells together with a - in between them (e.g.
2-1), which works fine unless the 2nd score is a zero, in which case ...

I have a long list data which is alist of employee with their error
made on their work. I have summarized the errors by step and error
type to 2 tables. What I need is to be ablt to choose any one staff b
their employee ID and the two tables will automatically change t

I am after a way of using formulas replace manual "=()" commands in th
following situation...
I have 2 adjacent columns of data on one sheet that include a weighin
pan number and its corresponding mass. When entering the data o

Hi, when you have multiple sheets in an Excel document, is it possibl
to have a cell in one sheet correspond to a cell in other?
for example if i had a sheet labled "Sales", and a cell in it tha
described the average weekly sales based on information within tha

Sometimes when I type a number of letters in a cell, the letters get cut off
at the end of the cell width however sometimes the letters extend into the
next cell and do not get hidden. I do not want to format the cell to wrap
text and I do not want to extend the width of the cell ...

I have a date in excel "Period_End_Date", this date is for employee hours
worked.  I create a pivot table to extract data by date & individula, then
summarize this and I need to, using the GETPIVOTTABLEDATA to get this
information into another worksheet.  How do I summarize the ...

I am looking for a way to set a few columns and rows so that they stay on the
screen as I scroll up and down.