Rounding down with a calculation 3 324 (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 calculation? This is the data c5 d5 ...
Utf

how do I copy specific rows without copying each row individually 3 241 (11/15/2009 9:45:01 PM)
I am using Excel 2007. I am trying to copy every 5th row of information and there is no specific criteria met in each row. Can anyone help? ...
Utf

Countif OR Sumproduct OR Istext???? 2 225 (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 row 2 314 (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? 1 178 (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? ...
Utf

help with Linking excel 1 158 (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? 6 379 (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

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

IF function 2 173 (11/15/2009 8:31:01 PM)
If 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...
Utf

how do I copy every 2nd row 5 356 (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? ...
Utf