=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...
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...
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...
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??
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??
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...
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.
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.