+ Reply to Thread
Page 3 of 3 FirstFirst 1 2 3
Results 31 to 35 of 35

fuzzy search in a list

  1. #31
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,974

    Re: fuzzy search in a list

    OK. Keep me posted.
    Let me know if you need any further explaination or assistance.
    If your problem is solved, please mark the thread as [SOLVED] (See Thread Tools in the menu above).
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  2. #32
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,974

    Re: fuzzy search in a list

    Been looking further to speed up the calculation by breaking up the formula in the Chemicals list.
    Calculation now takes abt. 10 secs for 10,000 rows, 20 secs for 15,000 rows and 40 secs for 20,000 rows.
    Guess that's better than half an hour, but still....
    How many rows will the real list be?
    Attached Files Attached Files

  3. #33
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 , Office 365
    Posts
    8,984

    Re: fuzzy search in a list

    Quote Originally Posted by Tsjallie View Post
    Hi Dave,
    I believe you're still on Excel 2007. Maybe referencing tables isn't supported in that version.
    Does the RefersTo-box in the Names Manager show #Ref! for Chemicals and/or Picklist?
    What if you try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    for the Chemicals name?

    Or maybe the CELL-function with "address" is not supported.
    You could enter
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    in any cell and then select an other cell.
    When pressing [F9] the address of the newly selected cell should be displayed.

    The named ranges Chemicals and Picklist are dynamic as they reference Table1[Chemical] and Table[Picklist] resp.
    The two list tied together in one table handle the growing (or shrinking) of the list.
    Sorry about the delayed response. Long weekend/out of town family .... :

    Actually I downloaded to my Office 365 machine. What's odd is that your upload now works () I didn't get #Ref! errors. The drop downs were just "dead" ... nothing dropped. I can't duplicate the behavior now.

    I haven't tried CELL yet. That's worked for me in other places. I'll have to check this out.

    Yes. I was thinking of an alternative if necessary (it isn't) to the Table for growing/shrinking.
    Last edited by FlameRetired; 08-21-2018 at 05:29 PM.
    Dave

  4. #34
    Registered User
    Join Date
    08-12-2018
    Location
    Amsterdam, the Netherlands
    MS-Off Ver
    2013
    Posts
    13

    Re: fuzzy search in a list

    Sorry for the long delay. Works, with calculation time about 30-50sec (there are less than a 1000 chemicals, but i run them throurh the what-if for 50 scenarios). Also, now it pretty much always need F9. I think i would go for two options (with the serach you suggested and without a saerch but categorisation) to show to the client and let them decide. Thank you so much for the help! I close the thread now, it was fun =)

  5. #35
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,974

    Re: fuzzy search in a list

    Glad I could help.
    It was indeed an entertaining excercise. Much more fun than Sudoku or Dutch television

+ Reply to Thread
Page 3 of 3 FirstFirst 1 2 3

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1