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!

Register Log in
  • Congratulations Mike Lewis 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: *

  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

    A VLOOKUP formula appears to be written correctly but will only return Error messages.

    Check the information in the cells of the columns\Ranges you are searching. Excell recognizes leading spaces as valid text. Highlight the column you are searching and set it to "left indent" then check to see if there is a space to the left of the information in the cells. It would probably be a...
  7. gpeterman

    using vlookup

    Thanks for your help. Finaly discovered my Formula was OK.When I imported the info from Access an extra leading "space" was entered in each cell down column A of sheet 1. Excel considers a leading space as valid text so it could not get resolve descrepancy, and returned an error message #N\A.
  8. gpeterman

    using vlookup

    OK here it is. The values I am interested in all start with 552 in sheet 1 column 1.I want to find those values on sheet 2 column 1 and display the names in their respective rows on sheet 1. The entries which start with anything other than 552 can be ignored or is ok to return an error...
  9. 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...
  10. gpeterman

    identify and hilite duplicates

    Thanks xlhelp for the heads up. I found "ASAP utility" on line, it is a free download and it's just the ticket.
  11. gpeterman

    identify and hilite duplicates

    Thanks - I will give it a shot and see how good I am.
  12. 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.
  13. 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...
  14. gpeterman

    Nortel Option 11 Inquiry - ports been disabled?

    Please clarify - are the Ports actually being disabled. You can confirm this by using the STAT command in LD 32. Do you know how to use the Stat and Enable commands?
  15. 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...
  16. 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