I have a column which lists various dollar amounts (thousands of cells). I
want to search that column and locate cells which total a specific dollar
amount. For example, a customer has fifty accounts with us and I know he paid
$100.00 that were divided randomly over five of his ...

I have two large lists (list1 and list2) in Excel. They both have the same
columns... and the same number of rows.  In list2, differences have been made
to some of the rows. But not all.
I want to pinpoint the rows that have been changed. So, find the rows in

I designed a sheet and colored filled every other row for aesthetic purposes.
However after several days of data entry, I sorted the worksheet but the
formating went with the text.  Now I have a mess.  I want to separate cell
formating from cell text.  How do I do this because I ...

I need to create a formula that will convert "#N/A" to a specific value.  
Specifically, cell A1 contains a VLOOKUP formula in which the value "#N/A" is
displayed when the formula is FALSE (the lookup value is not found), which is
correct.

I have seen the answers to similar questions which suggest the use of
SUMPRODUCT.  I have also seen mention that this works for exact and equal
ranges, but i need to do this for columns, because i will be continuously
adding to the ranges.  

How do I sort data by criteria that is not ascending or decending -- such as
greater than number in a particular cell.

I have a workbook with 2 worksheets.  First worksheet contains columns
headed:  Case, Case ID, Plaintiff ID and Plaintiff Last Name.  Second
worksheet contains the same columns.  In the first worksheet the Case ID and
Plaintiff ID are not populated.  I would like a formula that ...

Excel 2003
OS XP
Trying to create a mail merge in word from an excel file.  
Zip codes that begin with 0 and zips that have a -XXXX at the end

I am editing numbers in cells but when I do, the spreadsheet does not
recalculate the new total at the bottom of the column even though formula was
working correctly yesterday.  Also, I put number in column
(ex:        Column G      Column H

I have made a cell absolute  G3/$H$2 , I cannot drag the formula down the
column it it just coping to the next line. please help

All,
Thanks in advance for your help.  Is it possible to use a graph apart from
the data source.  In other words, once I have made the graph can I use the
graph without it being connected to the data source.  If yes how?

I have 2 columns (Column A = "Per Game Fee" , Column B = "Number of Games").  
I am attempting to total Column A after it has been multiplied by Column B.  
column B may have the occassional '0'(Zero), and therefore shouldn't be added
to the cummulative total of 'A'.  

Hello All, If this is possible, please tell me how.
To activate multiple cells that contain different data lists, via Data
Validation, so that all of the entries, of each data list, can be displayed
at one time.

I am currently working on a order form that requires an "X" to be placed
in order to make a selection.  The problem being is that some options
have a drop down list composed of a named datarange or a straight text
string.  Which in turn completes the option price based on what is

Thanks for taking the time to read my question.
I have a column of formulas like this:
=if(B1="","",B1)
This works fine, but I want to use this column as the row source for a value