Search results for query: *

Try the IF function that follows to determine whether a cell has the consecutive letters "yes" in it, but you can't assign a range name to it without doing so manually or incorporating that action into a macro. =IF(ISERR(FIND("yes",E2)),"","yes") This...

Convert Formulas to Values Fast. Avoid the lengthy Copy/Paste Special sequence when you need to turn a range of formulas into their results: This is probably the fastest way: 1. Select a cell range containing formulas 2. Right-drag a border a short distance until the tip indicator displays a...

Almost the same... Instead of locating and clicking “on the first cell above the active cell where the = appears”, which could be cumbersome when dealing with a large range, this method simply requires an Up Arrow.

I'm not sure what changed, but now RANDBETWEEN is operational.

I think this way is better: 1. Select cells in the name column that do or should contain names 2. Press the F5 key, then Special, then Blanks, then Enter 3. Press the equal sign, then up arrow, then Ctrl+Enter 4. Select and Copy all the cells in the column 5. Edit menu, Paste Special, Values, OK

The RANDBETWEEN function, which generates integer random numbers within a range, does not work in Excel 2003. As in previous versions, it's part of the Analysis ToolPak add-in, but in 2003, installing the Analysis ToolPak does NOT activate RANDBETWEEN. I assume this is one of those oversights...