I have given the cell A1 a name (ie smith). In another cell I am trying to
use the address function to tell me what that cell has been named. If I type
in =address(1,1) it returns $a$1. I want it to return smith. Does anyone know
how to do this?

I have a data field (for a land parcel spreadsheet) that is named Tract
Number. The field is formatted for text, and a sample value would be this:
7-5-047-088.  But there are some cells that contain a combination of numbers
AND text such as 7-5-047-E14, with the letter E in the ...

Please help.

I am trying to copy a text from a webpage into excel. The problem is that
some of the things I am trying to copy are numbers like 16-1 excel then
wantsto format it to a date so in excel 16-1 turns up like 16 jan. I know
that i can format the cell to text instead of dates... but I ...

Thank you in advance for any help anyone may be able to offer.
I have a list of numeric values in column A.
in B1 I use the function =median(A1:A150) to get the median value for
column A

If you enter days360(A1,A2) where A1 is April, 18, 2006 and A2 is
March, 31, 2007 you get correctly 343 days.
BUT if you enter it the opposite way, i.e. days360(A2,A1), you get -342
days.

I am using a pivot table to display data ina user friendly way rather than to
really analyze anything.  I want to get the "value" of a text field as a data
element in a pivot table. There is only a single value for each of 5 years
for 150 different programs.  I thought by asking ...

I want to create a spreadsheet with columns using a rolling forecast. Is
there a function or a method to have the columns move against a calendar? For
example, I want Period 1, Period 12, Period 11 this month, then next month I
want the columns to be Period 2, Period 1, Period 12 ...

im trying to use negative numbers with excel's natural log function, and have
found it doesnt work the way im trying it anyway, has anyone out there used
negative numbers with Excel's natural log function and any sucess?

I want to be able to format a cell to turn a cetain color using 10 different
conditions.
For ex.
if cell B1=1 then turn the cell red

I am attempting to use the sumproduct function to determine the number of
ovetime hours worked by week.  The following formula is returning a zero
value, which is incorrect:
=SUMPRODUCT((D$2:D$15000="20051009")*(E$2:E$15000="L102")*(I2,I15000))

I'm seeing LOTS of posts that are close to this issue, but nothing quite the
same.
I'm using VLOOKUP to look at a part number column that's being imported. It
all comes across in text format b/c some part numbers are alphanumeric (ex:

My question is how can I calculate a p-value for a negative t-value?
In several tests the t-test value is negative and I cannot use the standard
TDIST(x,df,1) function. Is it correct to calculate the p-value of negative
t-values as:

I need help with vLookup. Excel changes my array range.
I have my price list with 100 product numbers and matching prices. I have
another list of products, that I'm trying fill in the prices for.
Col A - product numbers

Here in Texas our Drivers license has a mag stripe on the back with all the
D.L. information. I need to be able to swipe the D.L. an have the information
go into ExCell  cells. Here is what I get when I swipe a D.L.:  
%TXDALLAS^BLOW$JOE$DAN^123 SOMESTREET^? ...