General

Find & Extract
hi, I have data in Col A and i would like to get the data in Col B only if the value in Col A is greater than 3 and less than 5 . A B 1 2 2 3 3 4 4 5 6 I am looking for a formula. Any ideas on this please. best regards, Meeru ... 21 Mar 2010 17:22

Randomizing
Hello All! I have been using a sort on a helper column of random numbers [generated by RAND() ] to randomize a data set but I notice that the column of random numbers changes when I do the sort. Can any expert tell me if the sort or the recalculation occurs first? -- James Silverton Potomac, Maryland... 20 Mar 2010 12:06

FileSearch Excel 2007
Hello, is there a File Search command in Excel 2007 please? ... 20 Mar 2010 22:11

Calculate age
I have an Excel Spreadsheet that contains a column of dates of birth in the format of dd/mm/yy. Across row 1 I have the current year in column "C" followed by 2011 in column "D" etc. What I am trying to do is calculate the ages of all the people using the year of their birth and the years that appear in row 1. ... 19 Mar 2010 19:02

help with drop-down box
I have a large spreadsheet of case manager activity. Each case manager has a certain number of rows and columns for his/her information (case manager A uses the area A3:G43, case manager B uses H3:N43, etc.). There are 13 case manager areas in group 1 (rows 1-43), 13 in group 2 (rows 44-86), 13 in group 3 (ro... 19 Mar 2010 16:41

Slow Cut, Copy and Paste in Excel 2007
Hi, I recently purchased a new HP Pav laptop running Win 7 64 bit and Office 2007. When I open a new, blank excel sheet and attempt to cut or copy even a single blank cell, the machine hangs for 10-20 seconds like it is processing the request. If I click on the sheet during this time, excel goes grey and bec... 19 Mar 2010 16:41

Creating "Billboard" Like Charts
Every month I create a spreadsheet that ranks customers by past due amounts owed that I share with our sales team. What's important is the relational change in an account's position on that list, along with how much they owe. Obviously if you show up on the list at position 50, spend 9 months on the list and a... 19 Mar 2010 16:41

Sumif does not calculate beyond 1000 rows
Does anyone know if there is a setting in Excel 2003 where we set number of rows a formula should pick up? I have a sumif formula to calculate range from row 2 to 20,000. However, it only calculates the first 1000. Then, I have to change the range to 1001 to 2000 for the next set. This only happens on a par... 23 Mar 2010 04:33

Two formulas in on cell based on two numbers in another cell?
Hi, Not sure this is possible but...I have a cell that has a number range in it and based on an amount in another cell want to calculate a new range. For example: Initial Range: A1 = 10 - 12 Calc Amount: A2 = 5 Final Range: A3 = 50 - 60 I think I can get the results by concatenating two formulas I'm jus... 19 Mar 2010 16:41

what is the maximum number of rows excel for mac 2008 has?
... 19 Mar 2010 15:32