Results 1 to 11 of 11

Moving Duplicate data to a new sheet

Threaded View

  1. #1
    Registered User
    Join Date
    02-26-2010
    Location
    Nelson, Lancashire
    MS-Off Ver
    Excel 2003
    Posts
    6

    Moving Duplicate data to a new sheet

    Hi, I;ve joined to get some major help, as google for once has failed me, or I have missed something,

    Basically I got a column of random numbers in Sheet A, in Sheet B, I need a formulae which would look at Column A in the Sheet A and copy or move across all the numbers which appear three or more times in Column A in Sheet A?

    I have linked a test spreadsheet. Any help would be excellent, I just cant seem to work it out at all.
    Attached Files Attached Files
    Last edited by Saj127; 02-26-2010 at 06:31 PM.

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