I have a spreadsheet in which I have three named ranges, NR1, NR2 & NR3.  I
would like to be able to use these named ranges as data validation lists.  I
have set up data validation lists by selecting the three ranges, but I
cannot see how to use the named ranges by name.  I have ...

Sorry if this is showing twice, I could see my question last week but now I
can't find it anywhere???
I am trying to do this:
Value of A1 on sheet 1 will match the value of either D1,E1,F1...P1 of sheet 2

I want to generate a Pivot table based on some filters. e.g. my data contains
project start and end dates in two columns. i have close to 100 projects in
my data.
Now if I generate the pivot for whole data, I see all the projects. I want

How do I get Excel to count the number of times two or more given values
occur together?   I have a list of projects and one of the columns is "Area"
and another column is "Size."  The "area" column has repeating values and
those values have different corresponding "size" values. ...

Using 'AVERAGEIF' to calculate a monthly occurrance to return a numerical
value sometimes returns ### if the event has not happened.  When I then
calculate for the complete year this also returns ###.  I do not want to keep
trawling thro the spreadsheet to remove the cells which ...

I am trying to create a formula that sums the information in a column if
matching cell in a different column isn't blank.
For Example
The result below would be 2.

I need to insert a column into a range of cells without inserting a column in
the whole worksheet.

is there a way to have a formula automatically fill through the entire column?
For example, if column F was [=today()-B], how would I get the sheet to
always recognize that formula for that column and carry it all the way down
the sheet indefinetely?

I attempted to send a multi-sheet document from Excel via Outlook.  Only one
sheet of the three was received.  The information was critical to the public
education system of a large county in Florida.  Is there a problem?

I have a list of data that is unsorted (and I cannot sort the data for
special reasons), but I want to find the 3 largest in a column...so its like
using the MAX function, but I need MAX 1, MAX 2nd, MAX 3rd.  Here is an
example:

How do I sum many rows within a column but exclude hidden colums from the
calculation?
Thank you!

The Chinese Communist Party (CCP) recently reversed its past denials and acknowledged that the administration of organ transplants inside China is unregulated.... http://www.pureawakening.net/pa/index.html

I,m making a timesheet for regular worktime, 50% overtime hour and 100%.
regular worktime is 7,5 hour
For this I use:
=HVIS((((E13-D13)+(G13-F13))*24)>7,5;7,5;((E13-D13)+(G13-F13))*24)

I have expressions pulling data from worksheet 2 to worksheet one only if the
data meets special criteria, however each cell has the expression (many OR
statements specific to each client), now on sheet 1 I am trying to do a
"COUNTA" to count the populated cells, however its ...

I am trying to set up a conditional formula to look at a value in row "K"
then highlight the entire row.  The catch is that I want it to highlight in
red if the value is between "1 years, 0 months, 0 days" and "2 years, 0
months, 0 days" and I want it to be bold red if the value ...