Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DennisFromBoulder

    EXCEL -Using Wildcards in If Then statements

    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...
  2. DennisFromBoulder

    Convert Formulas to Values Fast. A

    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...
  3. DennisFromBoulder

    Hi I have this excel spreadshee

    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.
  4. DennisFromBoulder

    Using RANDBETWEEN function in Excel 2003

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

    Hi I have this excel spreadshee

    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
  6. DennisFromBoulder

    Using RANDBETWEEN function in Excel 2003

    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...

Part and Inventory Search

Back
Top