Rounding down with a calculation31102 (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
This is the data
c5 d5 ...
Countif OR Sumproduct OR Istext????2726 (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 row21024 (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?1694 (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 excel1601 (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?61141 (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...
IF function 11-15-0921004 (11/15/2009 8:31:01 PM) UtfIf I create a function which checks for text in a cell, it gives a #NAME?
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 row5864 (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-092672 (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
multiplying5691 (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 count rows with changing data1748 (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 text61754 (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!!3607 (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
TIME X MONEY1847 (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 ...