Rounding down with a calculation31122 (11/16/2009 2:03:01 PM) UtfHi, I could use some help. I saw lots of answers on how to round down when a
cell has a function in it (like IF, SUM), but how do you do it with a mere
calculation?
This is the data
c5 d5 ...

Countif OR Sumproduct OR Istext????2737 (11/16/2009 3:49:02 AM) UtfI'm really struggling with the appropriate formula to use in Sheet 2 to sum
the number of applicants for a specifc role (column C) that also have an
interview date in column D in Sheet 1.
A sample of the...

Find the last 4 cell entries in a row21052 (11/16/2009 2:27:01 AM) UtfI have a worksheet where I input sporting scores for a year. If a player
plays 12 games, he/she will have 12 scores entered on a row. They may miss a
game and have no score entered as below.
G1 G2 G3 ...

how do i average the 3 max numbers in a column?1713 (11/16/2009 3:50:01 AM) UtfHi, i have a list of numbers in a column (not in any particular order) and i
would like to average the 3 max numbers and 3 min numbers. is there a
function that can do this?
...

help with Linking excel1622 (11/15/2009 10:24:05 PM) Utfhi,
i have spreadsheets for work which could have anywhere between 5 and 100
worksheets within. i am creating a worksheet at the end of the workbook which
takes information from all worksheet and puts it...

Why Excel Does not increment by 2 or 3, odd/even numbers?61165 (11/15/2009 5:06:04 PM) alsalehHi,
I inserted numbers 1,2 and 3, respectively in three rows. I then
dragged till row 10 and MS-Excel just filled out the rest of the
numbers till 10.
Now, When I inserted odd numbers (1,3 and 5 )and tried...

How do I get random numbers from a certain range?5581 (11/15/2009 6:03:01 PM) UtfI have 468 unique numbers and need to select, at random, 64 numbers that do
not repeat. How do I get Excel to do this?
...

IF function 11-15-0921027 (11/15/2009 8:31:01 PM) UtfIf I create a function which checks for text in a cell, it gives a #NAME?
error.
I have a sheet with a cell containing the text 'Single'. In another cell I
want to check for that word so I type =if(a1=''Si...

how do I copy every 2nd row5881 (11/15/2009 7:32:01 PM) UtfI have rows of information (mailing list). I would like to copy every 5th
row only to a new workbook using transpose without having to highlight every
5th entry. Is this possible?
...

need a formula 11-15-092690 (11/15/2009 7:04:01 PM) Utfneed to find the formula for b3 is 8 hrs c3 = -.50min / b3 is less than 8hrs
c3 -.25 example b3 8. hrs c3 7.5 hrs / b3 6. hrs c3 5.75
...

column A matches f places the value from g in column b what funct2721 (11/15/2009 7:28:01 PM) UtfI am trying to have excel enter information in cell b by finding a number in
a, matching it to a cell in f and returning information from g that that
coresponds with the number in a, example
if column A ...

Hpw do I delete multiple empty rows found between filled rows?21051 (11/15/2009 12:31:01 AM) UtfMy data spreadsheet contains multiple empty rows found among thousands of
filled rows. Is there a way to delete the empty rows collectively without
having to do each one separately?
Thank you
...

multiplying5710 (11/15/2009 2:05:01 AM) Utfif I have two columns A and B. A is filled with numbers that I want to
multiply by the same number and have that total fill B. But I want also to be
able to change the number and have all the totals update....

How to lock cells after a certain days13151 (11/15/2009 12:35:01 PM) UtfHow can I lock cells B1 to B10 if the date shown in cell A1 maller than today
2 days
please help.
...

How to count rows with changing data1770 (11/15/2009 3:16:01 AM) UtfI have an imported list on sheet2 and it is maybe 100 rows. Each day the
data is imported the dates change along with the type of record associated
with each date.
Say this week there are 25 rows with 1...

Count first occurance of text61780 (11/14/2009 11:46:05 PM) UtfI have a row of 24 cells, some are blank and others have text. I am trying
to create a formula that returns the first instance of text being used. I
have tried using a match, but it gives me an error beca...

excel help please. Urgent!!3628 (11/15/2009 8:58:51 AM) leePlease help, im trying to get excel to return a number if the amount entered falls between 2 set amounts. Example below.
?1-?1000 3 Days
?1001-?2500 5 Days
?2501-?5000 10 Days
?5001-?9999 20...

TIME X MONEY1865 (11/15/2009 6:43:02 AM) UtfI'm trying to work my payroll sheets via excel and am running into an error
when trying to multiply the hourly rate by the hours worked. I am using
excel 2007, the time is formatted to HH:MM:SS and when I ...