Tag Info

Hot answers tagged

2

=SUM(COUNTIF(K:K,{"Busy","Hang up","Stopped","Voicemail","Wrong Number","No Answer","IP Phone Offline","Call accepted"})) If this list is subject to change/expansion then it would make more sense to store the criteria in cells within the worksheet, rather than within the formula itself. For example, if the criteria were in A1:A8, the required formula would ...


1

it is actually possible to access router from outside via ssh and then connect database as if I'm doing it from workplace network, if router is told to have ssh feature? You can ssh to your router, provided the configuration is correct. I doubt that your router has a query tool for your database though. You should use the router as a proxy, a mere hop, ...


1

If the email address you are going to autofill wouldn't have any significance, and you just want them to be unique, you can use the row number to make up an email address. One possible formula you can use is as follows, =ROW()&"example@example.com" If the above formula is used in 10th row, it would produce 10example@example.com.


1

locate32 is my favorite. I believe it creates a database file in the same format as locate on linux. There is source code available for it as well. A batch file solution would be bound to be clunky and slow with the number of files you can store on hard drives nowadays, assuming you just made a text list of all files on a system.


1

You can use the following to make it look good. 1) Go to Formulas tab - under Defined names group - select Name manager (Or for old versions of excel using menus - Insert>Name>Define) and in the "Names" box type: calldetails. 2) Scope - can be workbook. 3) Now click in the "Refers to" box and type (or paste): =COUNTIF(K:K,"Busy")+COUNTIF(K:K,"Hang ...



Only top voted, non community-wiki answers of a minimum length are eligible