excel.worksheet.functions 4936 articles. 2 followers.
(0.03 seconds) Articles (4936) |<First << Prev /247
 Rounding down with a calculation 3 1221 (11/16/2009 2:03:01 PM) Utf 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 ...

 how do I copy specific rows without copying each row individually 3 1020 (11/15/2009 9:45:01 PM) Utf 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? ...

 Countif OR Sumproduct OR Istext???? 2 798 (11/16/2009 3:49:02 AM) Utf 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...

 Find the last 4 cell entries in a row 2 1153 (11/16/2009 2:27:01 AM) Utf 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 ...

 how do i average the 3 max numbers in a column? 1 801 (11/16/2009 3:50:01 AM) Utf 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 excel 1 691 (11/15/2009 10:24:05 PM) Utf 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...

 Why Excel Does not increment by 2 or 3, odd/even numbers? 6 1261 (11/15/2009 5:06:04 PM) alsaleh 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...

 How do I get random numbers from a certain range? 5 679 (11/15/2009 6:03:01 PM) Utf 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? ...

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

 how do I copy every 2nd row 5 949 (11/15/2009 7:32:01 PM) Utf 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? ...

 need a formula 11-15-09 2 762 (11/15/2009 7:04:01 PM) Utf need 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 funct 2 820 (11/15/2009 7:28:01 PM) Utf I 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 ...

 formula when clicked on gets information form a percifice cell. 3 805 (11/15/2009 10:30:01 AM) Utf -- Robert ...

 Hpw do I delete multiple empty rows found between filled rows? 2 1117 (11/15/2009 12:31:01 AM) Utf My 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 ...

 multiplying 5 827 (11/15/2009 2:05:01 AM) Utf if 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 days 1 3258 (11/15/2009 12:35:01 PM) Utf How 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 data 1 842 (11/15/2009 3:16:01 AM) Utf I 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 text 6 1891 (11/14/2009 11:46:05 PM) Utf I 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!! 3 727 (11/15/2009 8:58:51 AM) lee Please 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 MONEY 1 954 (11/15/2009 6:43:02 AM) Utf I'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 ...