Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

CI & TGTCI cross matching

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • 17th February 2009 at 20:26 #55855
    zzaman
    Guest

    Dear PIX,

    Could you please help me for Cross matching CI with TGT CI Vice versa by EXCEL function or if you have any batter tools, as i have More than 1000 ADJC_CI in my DB.
    I need to delete/add some ADJC_CI.

    17th February 2009 at 21:53 #55856
    pix
    Guest

    try VLOOKUP function.

    17th February 2009 at 22:49 #55857
    fzzaman
    Guest

    Dear PIX,

    I have tried with VLOOKUP but it’s not working. As an example can you please provide me the formula by which i can find the missing ADJC_CI.

    CI TGTCI
    30101 30102
    30101 30103
    30101 30104
    30102 30101
    30203 30101
    30104 30101

    THANKS

    18th February 2009 at 10:45 #55858
    Pix
    Guest

    What do you want me to do with your two columns ?
    Please describe your problem more accurately.

    18th February 2009 at 10:54 #55859
    CI with TGT CI
    Guest

    Dear
    NO buddy understand your question or your requirement correctly! and also there is mismatching in your Example! please ask with clear question in order to give you correct answer, is better if be with an example,

    Regards

    18th February 2009 at 14:08 #55860
    Pix
    Guest

    Wooow. Angry?

    20th February 2009 at 12:12 #55861
    CI with TGT CI
    Guest

    Hi,

    Actually I was looking for the easiest way to find the missing ADJC_CI from DB. Thanks PIX, VLOOKUP is serving my purpose.

    Thanks

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)
  • The forum ‘Telecom Design’ is closed to new topics and replies.