Functions

Count Cells Within 10 of a Cell Value
I need a formula that calculates how many out of a range of cells are within 10 of another cell. For instance, I have cells F3 through U3. I want to know how many of them are either 10 above or 10 below the value in cell V3. If cell V3 equals 20, than I want to know how many are between 10 and 20 and how many a... 10 Mar 2010 15:21

How to remove headers when importing from an external source?
I am combining several worksheets into a summary document. When I import external data, the headers for each worksheet remain. These are the headers that CANNOT be removed (the ones with the boxes with arrows). ... 10 Mar 2010 15:21

How do I subtract todays date from range of dates
I need to make todays date as a constant so when I drag the formula down the cells used in calculating the cell with todays date does not change. ... 10 Mar 2010 17:35

Wrap text in cell
It seems that wrap text and autofit row width and row height have a limit. Any idea where to change this limit? I have quite a large text in a cell and when I do wrap text and autofit, then parts of the text get cut of. The text is still there, but it is not shown in the cell and it is cut off when printing. ... 12 Mar 2010 15:05

vLookup and Line Breaking
Greetings all, I have a worksheet where cell B8 and B10 perform a vLookup based on a data validation in B6: =IF(B6="","",(VLOOKUP(B6,Position,2,0))) IF(B6="","",VLOOKUP(B6,AD_Groups,2,0)) I have the following code in place to perform a line break after each comma in the returned value. It works great the ... 10 Mar 2010 14:14

Month (MMM) from date (dd/mmm/yy)
In my spreadsheet I have a date column (col A) which I have in format (dd/mmm/yy). I need to show the corresponding month in Col B, in MMM format - April, May, etc. I'd like the month to appear automatically in the corresponding cell in col B when I type the date into col A, so that it looks like this: A ... 10 Mar 2010 13:06

Macrs with Validation Rules
I have a spread sheet with a tab called Estimnates once the Validation Item for the estimated item is changed to "Contracted" I want it to Copy the Entire row to another Sheet called Contracted Projects. Is this possible? Would the best Option be to have it Copy all Items listed "Contracted" when the Workboo... 10 Mar 2010 14:14

how to sheet1 data goes to sheet2 automaticaly ?
Hai all I would like to know one excel sheet1 data to sheet2 automaticaly,which command use for it ,please.... ... 10 Mar 2010 11:58

Prevent dragging cell contents
I am trying to prevent dragging cell contents in a form. I cleared "Allow cell drag and drop check box" under Tools. But it works in only one computer. If I use the same form in a different computer, it is not working. Need help. Thanks. ... 10 Mar 2010 10:50

Text Function
Is there a text function counterpart to the SUMIF. A concatenate if? I have a table of data and based upon a numeric value in the data I would like to concatenate all of the text strings that might be assocaited with all of the instances of a given numeric value... ... 10 Mar 2010 11:58