Closed Thread
Results 1 to 5 of 5

Data Mining?

  1. #1
    Forum Contributor
    Join Date
    03-31-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    211

    Data Mining?

    I would like to be able to filter the attached numbers differently than what the numbers filter offers. I would like to be able to sort a group of numbers like in 3's or 4's. Is this possible? Not to complicate things it would be nice to be able to find an exact match. I have added a column F and notes under I and J. I have tried and tried several things but can not seem to find something that works. I appreciate any incite you may have I also have posted this question on another forum (Can I filter this differently? ) Not to complicate things it would be nice to be able to find an exact match. I have added a column F and notes under I and J

    Here is the link to the file:

    http://https://www.dropbox.com/s/o6t...l%20fourm.xlsx

    Thank you all!!!!

    This is exactly how it looks on my sheets:

    2

    6
    10
    8
    2

    2
    4

    12
    2
    8
    10
    4
    2

    2
    2
    2
    16

    2

    2

    6

    2


    I do have two other columns that have a location and number in series like 1,2,3,4,5,6,7,etc.... I want to be able to sort say all of the

    8

    10
    4 2

    throughout all my rows. I have 62,000 rows now but will have well over 300,000 rows of information by the time I am through. I am trying to save time and right now it is taking forever to locate the information. I hope this helps

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: Data Mining?

    Link to the file does not work. Suggest you upload to the forum site. Here is how.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    03-31-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: Data Mining?

    Quote Originally Posted by alansidman View Post
    Link to the file does not work. Suggest you upload to the forum site. Here is how.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Thanks!!!!
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    03-31-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: Data Mining?

    bump! Am I on the wrong thread for help?

  5. #5
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Data Mining?

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel 2007 : Help needed for a data mining formula
    By spiros63 in forum Excel General
    Replies: 18
    Last Post: 06-13-2012, 02:10 PM
  2. Data Mining Add-in
    By OnlySteveH in forum Excel General
    Replies: 0
    Last Post: 11-11-2011, 12:11 PM
  3. Data Mining Question
    By mmorookian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2011, 09:52 PM
  4. Data Mining
    By IrishBull74 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-17-2008, 09:38 PM
  5. Data mining
    By blubyeu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2006, 08:27 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