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 Wanet Telecoms Ltd 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. CarolynKo

    Find Exact Value in Formula

    I'm still playing around with this. Wanted to thank everyone for taking the time to respond. Learned some too about different options/features for use now and/or in the future.
  2. CarolynKo

    Find Exact Value in Formula

    Fred, thanks for the suggestion. Unfortunately it also finds 1,000,000 and makes it 10,000,000. In essence I need something that works like: find formula where equals (or contains) 100,000 AND not equal to (or does not contain) 1,000,000 Example of formula: =(C11/(sheetoffset(-1...
  3. CarolynKo

    Find Exact Value in Formula

    PH: Using xlWhole produces the same result. I'll restate the situation for anyone else who might have a solution: In my formulas, I want to Find (and possibly Replace) 100000 (5 0s) with 1000000 (6 0s). When I invoke Find I do not want to be taken to 1000000 (6 0s).
  4. CarolynKo

    Find Exact Value in Formula

    I need to search my Excel formulas to find 100000 (5 0s) but do not want to find 1000000 (6 0s). Using VBA or built-in Excel Find function takes me to every occurrence of 1000000 (6 0s). Entering 100000 (5 0s) - it's treated as if there is a wildcard, which normally works well, but not in this...

Part and Inventory Search

Back
Top