Results 1 to 8 of 8

"." Period filter for wire number labels

Threaded View

  1. #1
    Registered User
    Join Date
    12-27-2014
    Location
    Rio Rancho, NM
    MS-Off Ver
    Office 2010
    Posts
    43

    "." Period filter for wire number labels

    Hello, once again I have a difficult (for me) issue to figure out.

    Is there a way to have a column with random width data with some fields having decimal point values, and have ability sort/filter so that data with decimal point doesn't show up?

    Background:
    I have a list of wire numbers in this format: xxx-xx-xx.x , where Room-Bundle-Wire.Leg
    Most of labels are 8 or 9 positions long where we have IDs such as:
    002-01-2
    002-02-01

    But I also have trunk or distribution #s that look like this:
    Patch # Patch Name
    006-01 Coax 8 Position block in SMC1
    006-02 48 Port Network Patch Panel in SMC1
    008-01 Home Theater 24 Port Cat5e Patch Panel

    The only constant is that the decimal point separates the unique wire from a leg number.
    When determining # of patch panels, or drops, I don't need to see the leg.

    So I may have a wire that goes from 3nd bedroom room (203), 2nd drop (02), and is 5 wire in the bundle (05).
    That would be 203-02-5 or 203-02-05

    Anything that plugs into this wire (or jack) would get a .x extension.
    So if this was a network wires, PC to wall jack might be 203-02-05.1
    In equipment room, patch panel to network switch might be 203-02-05.2


    When printing wire lists or drop lists, I would like to hide the leg numbers (not show any rows with *.x)

    Any ideas?

    Thanks,
    Mario
    Last edited by mariomp; 01-09-2016 at 03:29 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 9
    Last Post: 02-11-2015, 11:46 PM
  2. [SOLVED] copy number with 3 or more decimal places and paste the actual value as 2 decimal number
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-29-2013, 12:57 AM
  3. Down to the wire...
    By lvanroos in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 04-05-2013, 02:36 PM
  4. Duplicate Report Filter and Row Labels Filter Across Multiple Pivot Tables
    By tash in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2013, 05:32 PM
  5. Replies: 2
    Last Post: 06-29-2012, 07:52 PM
  6. Paste two decimal number in excel without extra decimal places appearing
    By jeffery_frick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2009, 07:49 PM
  7. Replies: 3
    Last Post: 03-18-2006, 02:25 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