Results 1 to 2 of 2

Filter digits

Threaded View

  1. #1
    Registered User
    Join Date
    12-09-2009
    Location
    ksa
    MS-Off Ver
    Excel 2007
    Posts
    25

    Filter digits

    dear master's
    in my exel sheet
    c10:c15 are cut digit
    f2:f15 are pair
    i2 = filter result
    j3 = filter result after cut
    now my quistion is
    how to make the 3 digit result from the pair from (f2:f15) ( i2 = make 3 digits (000-999)with the pair f2:f15

    how to filter the result with c10:c15 ( j3 = remove all c10:c15 from i2)
    Attached Images Attached Images
    Last edited by sun_ilkumar; 12-11-2009 at 08:57 AM.

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