Rounding down with a calculation3324 (11/16/2009 2:03:01 PM) Hi, 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 ... Utf
Countif OR Sumproduct OR Istext????2225 (11/16/2009 3:49:02 AM) I'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... Utf
Find the last 4 cell entries in a row2314 (11/16/2009 2:27:01 AM) I 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 ... Utf
how do i average the 3 max numbers in a column?1178 (11/16/2009 3:50:01 AM) Hi, 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 excel1158 (11/15/2009 10:24:05 PM) hi,
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... Utf
Why Excel Does not increment by 2 or 3, odd/even numbers?6379 (11/15/2009 5:06:04 PM) Hi,
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... alsaleh
IF function2173 (11/15/2009 8:31:01 PM) If 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... Utf
how do I copy every 2nd row5356 (11/15/2009 7:32:01 PM) I 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?