+ Reply to Thread
Results 1 to 2 of 2

Filtering big database

  1. #1
    Registered User
    Join Date
    11-06-2018
    Location
    Poland
    MS-Off Ver
    2016
    Posts
    95

    Filtering big database

    Hi guys,

    I need to filter huge database in format like this~:


    Word1<a lot of spaces>Word2<a lot of spaces>Word3<a lot of spaces>Word4


    I would use 'text to column' feature, BUT those "Words" can be double-barrelled which makes it hard to filter

    I need to sort it into columns named but it would take ages for me to do it in manual~ way

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Filtering big database

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.


    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Database Filtering Help
    By mifzal.mufthi in forum Excel General
    Replies: 4
    Last Post: 03-08-2015, 01:31 AM
  2. Not filtering entire Database
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 12:05 PM
  3. [SOLVED] Not filtering entire Database
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 AM
  4. [SOLVED] Not filtering entire Database
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  5. Not filtering entire Database
    By Katie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. [SOLVED] Not filtering entire Database
    By Katie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. Not filtering entire Database
    By Katie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

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