Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gpeterman
  • Content: Threads
  • Order by date
  1. gpeterman

    insert a variable into a formula

    =COUNTIF('C:\Users\Public\Documents\ASAB-LSA\CDR Reports\ASAB 0 Call Report\[ASAB 0 Calls 04-21-14.xlsm]0 Calls'!$E:$E,A2) Note the Countif formula above. It references another worksheet located elsewhere on my C Drive. In the woksheet name is a date "04-21-14". My question is this, I want to...
  2. gpeterman

    is there such a thing as a nested vlookup?

    I'll try this without attaching a work sheet. I have a working sheet 1 and a sheet 2 where my data is imported to. I want to write a formula in a cell on sheet 1 similar to a VLookup, except it is looking for information defined by 3 separate cells on sheet 1. We are looking for an exact match...
  3. gpeterman

    False busys on NT8D09CA.

    I am experiencing multiple card failures on NT8D09CA in CS1000 OP81C. I show TNs as UNEQ and when I program a DN on it I get NDT, the port still shows idle. After reseating the card it the shows BUSY and goes into lockout. This is occurring on multiple cards and multiple ports. I can move the...
  4. gpeterman

    no summarize button when seting up a report.

    I have Office Access 2007: Using report wizard, I get to the sort order box, there should be a "Summarize" button offered but it is not. Have I got a stripped down version or is there a fix for this??
  5. gpeterman

    In MS Access "Summarize"Button is not offered.

    I have Office Access 2007: Using report wizard, I get to the sort order box, there should be a "Summarize" button offered but it is not. Have I got a stripped down version or is there a fix for this??
  6. gpeterman

    using vlookup

    I am attempting to use Vlookup, but I don't think it will accomplish what I need. I need to write a formula in a cell on sheet 1 to search down column A of sheet 1 and find numerical values which all start with the same 3 digits. Then find those values in column 1 on sheet 2 and return the...
  7. gpeterman

    identify and hilite duplicates

    I want to write a formula or script that would search the same collumn on all the sheets in a workbook and mark the text items that are repeated. I am willing to attempt it but I don't even have a list of the possible excel commands. I own excel for Dummies but it about 7000 miles away.
  8. gpeterman

    an offsite call grp member

    I am setting up a call group. one of the members is at another site at which I have TIE trunks. I set up a phantom DN - DCFW to the offsite station and verified that by calling the phantom #, the target station rings and answers. However when I put the the phantom in a call grp and call the grp...
  9. gpeterman

    NCOS & FRL ???

    I don't understand and have not been able to work it out from the DOCs. Why do I need 100 NCOS when there are only 8 FRL that can be assigned. I am attemting set up some additional NCOSs so the customer can Micro manage his traffic. IE: I want sta 1200 to make most intnatl calls, i want 1201 to...
  10. gpeterman

    A question about error code SRPT091 on a CS1000.

    First a screen shot: SRPT091 HB: Remote side AML health change:0. SRPT091 HB: Remote side AML health change:2. SRPT092 AML: remote side AML connection 16 to 192.168.1.5 health change: 2. The IP address refers to Call Pilot. The System Msg Doc lists this as informational and no big deal...

Part and Inventory Search

Back
Top