Tech Problem Aggregator

# C++ Bit Counting Problem

Q: C++ Bit Counting Problem

I've got to implement a function that will return the value of bit n of a binary number. I then have to implement a function that will change bit n to 1 or return a 0 if it is out of range.

I'm a bit stuck on this one, anyone know how I'd do it?

A: C++ Bit Counting Problem

C++ bitwise operators tutorial

To get what you want you should read up on bit masks and the bitwise and operator. The basic idea is to mask out the bits that you dont want by using a bitwise and operator. I can post example code if you like.

3 more replies

Hey:

I know this may seem a bit... unnecessary but maybe you don't mind helping me out anyway.

Say that ROW2 is the date 8/1/10, ROW3 is the date 8/2/10, etc., etc.

COLUMN A is the date, COLUMN B is salesperson #1, COLUMN D is salesperson #2, etc., etc.

Say that for B2, salesperson #1 sold all the units numbered 100356-100389. I want C2 to calculate the total number he sold, so basically all the numbers in that range, which is 34.

I could do the math for them all myself, but hopefully there's a function that'll do it in excel!

Thanks!
Nick

A:Solved: Excel Simple Counting Problem

I think you should try the countif function.
If you search in help or else just google for Excel COUNTIF and you'll get tips and hints

3 more replies

So let me explain this:

about 30 days ago my internet started cutting in and out. What I mean by that is sometimes the lights on my modem go out sometimes they don't but either way it interrupts my connection and sometimes it will stay offline anywhere from 30seconds-30minutes. The only solution I myself have found is to power cycle the modem when this happens but that only fixes the issue for a short amount of time before it occurs again. ALSO sometimes the internet won't even go offline but the download speed will be less than 1mbps (I'm suppose to get 15mbps)

So...
I called my ISP to figure out the issue and I have had 10 "technician's" out here in the last 30 days. They have replaced all the cords going to my home and inside my home, replaced the modem and router 3 times, and I'm still having the problem.

Today...
They came out here again and replaced the modem/router with a Motorola modem, and a netgear router. All worked fine for about 2 hours and then they called me and told me they were seeing some problems and said since they have done everything that it must be a device on the network. They told me to do this:

"Unplug the router from the network and just leave the modem connected to your hardwire PC for 8 hours, then unplug your hardwire connection and just use the wifi with the separate devices and we will see what happens. I honestly think this is an application you are running that is taking up so much bandwidth which is either causin... Read more

A:ISP or Networking Issue? 30 days old and counting problem..

The thing they need to check if they can access your modem while you don't have connection on your pc. If they can then its something to do with your PC.

Do you have any other PC that connect to it?

Have you tried visiting the manufactures website for NIC drivers?

Can you post an ipconfig /all output from the command prompt
Click start
In search box type cmd press enter
In command prompt type ipconfig /all

9 more replies

Hello all,

There's a ghost in the machine! I'm running Excel '97 on Windows XP. In using the COUNTIF funcition, It will count certain rows of data, but not others.

Check this out...
In example below, the "count" column has formulas where I drag them down so

C2 =COUNTIF(\$A\$1:\$A\$2000,B2)
C3 =COUNTIF(\$A\$1:\$A\$2000,B3)
C4 =COUNTIF(\$A\$1:\$A\$2000,B4)
etc.

In column "B" I manually typed "8:00", "8:01" and "8:02" and used auto-fill for the rest, as it goes on and on up to 16:00.

A B C
1 data cond count
2 8:00 8:00 1
3 8:02 8:01 0
4 8:03 8:02 1
5 8:04 8:03 0
6 8:07 8:04 1

Notice in cell C5, that nothing shows up! Even though there is a value in column A of "8:03". 8:02 shows up, and so does 8:04. So why not 8:03?

Here's the kicker - if I go into cell B5 and MANUALLY TYPE IN "8:03", then it gets counted in C5!!!

Problem is, the data column A is 1100 cells long and column B is 720 columns. I can't manually type in each time condition 720 times in column B.

I have checked the format of all cells, and they are all set to the same format of Time (13:30).

What am I missing?!? This is such a powerful function, but why is it not working for me? Any help or suggestions are severely appreciated!

Much respect,
Kiwi Berg

A:Solved: Excel Problem: COUNTIF not working - counting some data but not all!

15 more replies

DON"T MISS OUT ON THIS OPPORTUNITY!!

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

More replies

hello i was trying to figure out how to count the number of letters in an inputted line of text and display letter by letter how many of each there were..any ideas to help thanks

A:counting

9 more replies

DON"T MISS OUT ON THIS OPPORTUNITY!!

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

More replies

Hello from No. Carolina. I surely hope someone can help with this. I renewed my Uniblue SpeedUpMyPC license last night and now every time I enter my Yahoo! e-mail user name and password I get redirected to a blank page! Suggestions?

A:I'm Counting on Y'all

Have you checked with Uniblue's support page? http://www.liutilities.com/support/

1 more replies

Hi,

Not sure if this could be done...but is it possible to make a script that would tell you the most amount of people that were online at your forum by counting the profile urls in the source code, then displaying the amount and time and date, then it would change if the number increased?

Or could there be another way of doing it?

Thanks

Peter

More replies

my Xp is behaving like a couple of bunnies. it was 53 , then 56 now 64
processes operating that i am not sure of. reid (of the forum)looked
at the 56 hjt log and said everything was legiit however my pc runs too slow. it takes 2 minutes after you click on something for a response

dont know what to do

glenn

A:64 processes and counting- help!!!!

What are your system specs? PC Brand and model number, OS, cpu, amount of memory?
Also, do you have alot of icons in your task bar next to clock in the lower right hand corner of your monitor? If so, you can disable the ones you don't need running and that'll free up some resources.
Defragmenting your hard drive my also help speed things up.
To start off post your system specs and a list of items that running in the task bar.

17 more replies

To put it in a nutshell, I downloaded a game, tried to open it, however it never did. Now accessing my processes list... I have over 500 processes running, and counting. All under the name of the game. My laptop doesn't appear to be running noticeably slower, however these 500 processes are going to mess my computer up sooner or later..

I scanned the executable file with MalwareBytes, Kaspersky (my background AV) and Microsoft Defender. It was clean. Kaspersky however, noted that the program was potential dangerous, only because the digital signature was missing. I told Kaspersky to 'Limit' execution - only to stop dangerous actions.

I then continued to watch my process list grow up to 1000, running under my username. Then eventually, the physical memory overloaded and my computer crashed.

Several days later the same thing occurred. However this time, with a different game. I scanned it, and it was clean. I told Kapsersky to once again, limit execution with no digital signature. Within seconds of opening the game, I had over 200 processes, and the number was slowly rising. I had to hit 'End Process Tree' in order to stop my computer from crashing again.

One person suggested that it had to do with Kaspersky... As other games have worked in the past without limiting them.

I know it isn't a virus or anything malicious, perhaps a glitch? And how can I prevent it?

Windows 7
AV: Kaspersky Pure

A:500 Processes And Counting?

Try Googling the names of some of these processes. Perhaps that will help you figure out what's causing them or if they're malicious.

2 more replies

Windows 10 is coming SOON!!
If you are eligible for the free Upgrade offer you can reserve the DL for the GA. You will need W7 SP1 or W8.1
Make sure your machine or machines are clean & healthy.  Always backup, backup & backup.  Recommend making a Sys Image just prior to final release
GA-Day is July 29
Cheers,Drew
PS:  Did I mention backup?

A:T- Minus 33 & Counting

I see the first topic in the Win 10 section is dated 1st October 2014. We have had nine months of mumping and moaning about the various test releases. As well as a lot of hot air there have been a number of serious and valid points raised - the purpose of the test releases.

Another month and we can all start mumping and moaning about the final release version !

I'm chicken !  I intend waiting at least six months before I consider updating from 7 to 10, and that will be dependent on whether or not I decide to rebuild my computer.

Chris Cosgrove

3 more replies

Hi,

I have a class called colouruser that changes the link colour of certain member's names. These names only appear in 1 table but mixed with other members names that don't have that class. How can I count the amount of members that has the class="colouruser". The class is in the A tag...

<a href="member url" class="colouruser">name</a>

Thanks

A:counting class

This should do it.

http://www.faqts.com/knowledge_base/view.phtml/aid/2193/fid/128

1 more replies

Well, I've done everything I know, including your suggestions before making HijackThis log. Still getting advert popup from everything from insurance to dating. Here is my HJT log.
PS - if I post something wrong, please don't yell at me too much. It's my 1st time!

A:Counting on you guys!

Logfile of HijackThis v1.99.1
Scan saved at 12:10:23 PM, on 10/26/2006
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\spoolsv.exe
C:\WINDOWS\Explorer.EXE
C:\Program Files\CA\eTrust EZ Armor\eTrust EZ Antivirus\ISafe.exe
C:\Program Files\ewido anti-spyware 4.0\guard.exe
C:\WINDOWS\system32\nvsvc32.exe
C:\WINDOWS\System32\svchost.exe
C:\Program Files\The Cleaner\tcm.exe
C:\Program Files\The Cleaner\tca.exe
C:\Program Files\Java\jre1.5.0_06\bin\jusched.exe
C:\WINDOWS\SOUNDMAN.EXE
C:\Program Files\CA\eTrust EZ Armor\eTrust EZ Antivirus\CAVRID.exe
C:\Program Files\CA\eTrust EZ Armor\eTrust EZ Antivirus\CAVTray.exe
C:\Program Files\Weather Pulse\weatherpulse.exe
C:\Program Files\Internet Explorer\iexplore.exe
c:\progra~1\intern~1\iexplore.exe
C:\Program Files\FireTrust\MailWasher Pro\MailWasher.exe
C:\Program Files\SpywareGuard\sgmain.exe
C:\Program Files\SpywareGuard\sgbhp.exe
C:\WINDOWS\system32\wuauclt.exe
C:\Program Files\Internet Explorer\iexplore.exe
C:\HijackThis\HijackThis.exe

R1 - HKCU\Software\Microsoft\Internet Explorer\Main,Default_Page_URL = http://www.foxnews.com/

3 more replies

i posted a thread yesterday, but got no replies, i have heard this forum is great, so i hope you can help me.
im having a few problems..

1. i have constant pop ups (have had 9 since beginning this thread..10)

2. i cannot save any new files, pictures, or anything. and its important that i do, i am a marketing advertiser and i really need to be able to work with my pictures and graphics.

3. i randomly hear some sort of sports radio channel through my speakers, even with my internet browser closed. sometimes its a poker channel, sometimes its baseball, just 10 minutes ago it was a stupid "guess what candy bar your tasting" thing. the only way i can stop it is to restart my computer.

4. my task bar disappears randomly and comes back maybe 20 minutes later. (as im typing this i dont see it)

5. my computer is running extremely slow. ive never had this problem.

6. ive tried running my spybot search and destroy, adaware, and kaspersky, and all 3 of them stop in the middle of the scan saying there was an error, and my computer shuts down.
if i can get some kind of help, i would greatly appreciate it. i dont want to lose any of my programs that i have paid for. i dont want to lose anything, and i cant afford to go out and buy a new computer.

6 more replies

DON"T MISS OUT ON THIS OPPORTUNITY!!

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

More replies

I have been messing with viruses and infections for 2 days and it seems like I'm spinning in mud. I have another thread:

http://forums.techguy.org/t250735.html

I have scanned with Ad-Aware 3 times and keep finding New Objects. I have HJT and posted it below. Before I started any of these procedures, I couldn't even get to the internet with being redirected, AKA Hijacked. I have since been able to at least close some windows and be able to do enough surfing to get to this forum and download some software. The problem I face now is that when I do start surfing around I get Hijacked by www.81.9.3.87/go/"whatever advertisement goes here".htm

Here are system specs:

345 MHz AMD-K6 3D processor
192 MB Ram
30 GB HD
XP PRO NTFS File System

Foloowing is the newest HJT logfile:

Logfile of HijackThis v1.98.0
Scan saved at 3:45:56 PM, on 7/16/2004
Platform: Windows XP SP1 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP1 (6.00.2800.1106)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\spoolsv.exe
C:\WINDOWS\System32\atievxx.exe
C:\WINDOWS\Explorer.EXE
C:\WINDOWS\winlogon.exe
C:\mssys.exe
C:\mssys.exe
C:\WINDOWS\sachost.exe
C:\Program Files\Messenger\msmsgs.exe
C:\Program Files\MA311 PCI Adapter Configuration Utility\wlanutil.exe
C:\WINDOWS\System32\Zso5Vyh.exe

A:2 Days and Counting ... Need Help!

16 more replies

DON"T MISS OUT ON THIS OPPORTUNITY!!

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

More replies

hey everyone

i'm posting this for a friend whos computer was working fine then out of nowhere it's been getting a msg

smss.exe has encountered a problem

this system is shutting down please save all files and log off\

then a bunch of other stuff that he can't make out fast enough

then after 60 seconds the computer reboots
he's running windows XP pro sp1
512mb of ram (no specific brands)
800mhz untel cpu
40gb maxtor harddrive

sorry about being so vague he's trying to tell me by memory since hes not at the computer itself for the night and we can't just reformat because there is important university essasys/reports/lectures that he can not get again

~Allen

A:counting down then restarting out of nowhere

9 more replies

Hello All:

All I want to do is create an Audio CD from some .mp3 files I have.
(15 .mp3 files = 55.9MB)

I have tried ImgBurn, Ashampoo Burning Studio, and BurnAware.

I have tried changing the write speeds to the lowest settings.

It all seems to go well until the end of the burn when every program tells me the Write Failed. That's it- and I don't know why.

I have an IDE Plextor DVD/RW (PX-870A ATA) drive.

Any ideas about settings? Or anything else I should be checking?

TIA!

A:4 Frisbees and Counting...

Quote: Originally Posted by rap33042

Hello All:

All I want to do is create an Audio CD from some .mp3 files I have.
(15 .mp3 files = 55.9MB)

I have tried ImgBurn, Ashampoo Burning Studio, and BurnAware.

I have tried changing the write speeds to the lowest settings.

It all seems to go well until the end of the burn when every program tells me the Write Failed. That's it- and I don't know why.

I have an IDE Plextor DVD/RW (PX-870A ATA) drive.

Any ideas about settings? Or anything else I should be checking?

TIA!

How long are those mp3 files, not in bytes but in minutes?

Things ro consider... when buring a standard audio CD, the mp3 files must first be converted wav files, the burning programs do this automatically.. at least most of them do. If the mp3s are encoded at a high bit rate the wav files could be quite large... is it possible you're exceeding the size limit for the CD?

The other thing to remember.. although it shouldn't affect the burn, use "Disk At Once".

Ap

9 more replies

Hello. I bought a used computer a few months back (app. 7-8 mos. ago), but was not hooked up to the internet until 3 weeks ago or so. I got Aol dial-up & unsuccessfully tried to download their anti-virus program, but due to an earlier installation of Norton, some files were still on hard drive, & AOL would not proceed until they were found & deleted. So the bottom line was I was so thrilled to be back on the internet that I didn't push the anti-virus program issue. My fault totally, but when I finally did run a Pc-cillin scan, I was completely shocked at the NUMBER of viruses- I was only through 1/3 of my files & it was reading 7,000 +. However, as I looked at the files being scanned I realized that I did not recognize any of them & the virus which was pre-dominant, Worm GAO, was probably on the computer when I bought it, propagating away. Anyway, I realize the hard drive is toast, but are any of the files salvageable? Could I use Pc-cillin to scan individual files & save them to CD or do I still run risks of re-infecting a new hard drive?Also, I uploaded photos to Yahoo, so if people were to download them to their computers, will they contain viruses? How about saved e-mail? And yes, I definitely learned my lesson the hard way!!! Thanks to anyone, for advice. I have Windows XP Professional. System Manufacturer VIA Technologies, Model VT82C597. AMD-K6 (tm) 3D Processor, MMX, 3D now, 500 mhz . Thank you.

A:Over 7,000 Viruses & Still Counting!!!!

12 more replies

Hi,

the last time i posted i had 53 running processes. a little excessive dont ya think? anyway my post went unanswered. i saw the lack of HJT log and tried to amend the post.

prior to that i was working with someone ref my desktop and they musta gave up becuase never heard from them again ( 3 mos ago)

anyway here is my current HJT log
glenn

A:56 running process and counting- help

Logfile of HijackThis v1.99.1
Scan saved at 8:51:41 PM, on 3/11/2007
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v7.00 (7.00.6000.16414)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\Ati2evxx.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\System32\WLTRYSVC.EXE
C:\WINDOWS\System32\bcmwltry.exe
C:\WINDOWS\system32\spoolsv.exe
C:\Program Files\WIDCOMM\Bluetooth Software\bin\btwdins.exe
C:\Program Files\Common Files\Creative Labs Shared\Service\CreativeLicensing.exe
C:\WINDOWS\system32\CTsvcCDA.exe
C:\WINDOWS\eHome\ehRecvr.exe
C:\WINDOWS\eHome\ehSched.exe
C:\Program Files\Common Files\Microsoft Shared\VS7DEBUG\MDM.EXE
C:\WINDOWS\system32\Ati2evxx.exe
C:\WINDOWS\Explorer.EXE
C:\PROGRA~1\TRENDM~1\INTERN~1\PcCtlCom.exe
C:\WINDOWS\system32\HPZipm12.exe
C:\WINDOWS\system32\svchost.exe
C:\PROGRA~1\TRENDM~1\INTERN~1\Tmntsrv.exe
C:\PROGRA~1\TRENDM~1\INTERN~1\tmproxy.exe
C:\WINDOWS\wanmpsvc.exe
C:\Program Files\Pure Networks\Network Magic\nmsrvc.exe
C:\Program Files\Synaptics\SynTP\SynTPEnh.exe
C:\WINDOWS\stsystra.exe
C:\Program Files\Trend Micro\Internet Security 12\pccguide.exe
C:\WINDOWS\system32\Rundll32.exe
C:\WINDOWS\ehome\ehtray.exe
C:\WINDOWS\system32\dla\tfswctrl.exe
C:\Program Files\Creative\SBAudigy\Surround Mixer\CTSysVol.exe
C:\WINDOWS\system32\WLTRAY.exe

4 more replies

I have xp pro
And you know that sometimes you may suddenly get that blue screen that has a counting at the bottom which counts to 100 and at the end it restarts?

What causes that?

I can't explain it anymore sorry but some of you should know what i mean

A:You know that blue screen with the counting?

7 more replies

I run a (Count) formula in an Excel 2003 worksheet (SP2 Teachers and Students Edition) which I update every week. (It counts a series of dates i.e.

1/2/07
8/2/07

Count = 2

etc. )

My problem is that when I update each week, the count formula doesn't include the extra cells, but includes a green triangle on the top left of the cell where the formula lies. I have tried the F9 command to update calculation but this doesn't work. If I click on the cell where the count formula is I get the following screenshot.

Is there a way where each week that the formula is updated automatically?

A:Excel Counting formula

6 more replies

I have a need to count the number of employees that are assigned to an associate director. I have them identified in the Employee Info Table as Associate Director ID = 24 and 9. On a form called frmDirectors Report Date, I have a choice to pick which Director, then the printer function calls the report and subsequent query to limit the data. One calculation on the report need to know how many employees in total are assigned to the selected director in a calc that figures average employee hours. I cannot figure out how to add the count to the existing query or any other way of approaching this issue. HELP. I have included the MDB for reference.

A:Counting Records In Access

1 more replies

I have a few cells i need counting in excel but i need them to perform a certain job. I need to count 2 cells that have data in them to total 1. If there are blanks in the cells i need it not to count them. Below is an example.

Cell L2 Blank Cell M2 blank Cell O2 29 Cell P2 25.

I need this total to total 1 for the 2 full cells of O2 and P2.

Then after that any 2 cells together ie R2 and S2 adds 1 to the total providing that both cells are full.

to explain beter I'm doing a darts spredsheet keeping totals so i need 2 full cells to total a game win of 1. Then every 2 cells full after will be game win 2,3,4 etc.

I hope someone can help.

Many thanks

A:cell counting in excel

It's better if you post a sample spreadsheet, showing where the totals (1s) need to go.

1 more replies

I have a need to count the number of employees that are assigned to an associate director. I have them identified in the Employee Info Table as Associate Director ID = 24 and 9. On a form called frmDirectors Report Date, I have a choice to pick which Director, then the printer function calls the report and subsequent query to limit the data. One calculation on the report need to know how many employees in total are assigned to the selected director in a calc that figures average employee hours. I cannot figure out how to add the count to the existing query or any other way of approaching this issue. HELP. I have included the MDB for reference.

A:Solved: Counting Records

Closing duplicate. Please do not create more than one thread for the same issue.

1 more replies

The company that I work for is "going green" and individual employees would like to know how many pages they print on a daily, weekly, and monthly basis.

These employees all print to a networked printer, but instead of getting a cumulative count of how many pages a department prints, each employee wants to know how many pages he/she prints.
Has anyone ever had to configure something like this?

A:Counting Print Jobs

I have seen this. But it is not computer related. It was part of the printer. Each user has to enter their personal code in order to print pages, and then the printer keeps track of the numbers.

2 more replies

i have an access file that has two tables. one table lists all the foremen and the other has the inspections. i want to print a report that shows how many inspections each foreman has. some foremen will not have any inspections. the two tables are linked together already.

A:counting records in access

If the inspection table has the field references the foreman, then use the following select statement.
select foreman,count(foreman) from inspection table group by foreman
Regards/Agoo

1 more replies

Morning,

I am trying to do a count of the amount of approved and released items from each department.

I have an excel sheet like the attached which I have 3 different departments

Finance
Sales
Stationery

I have a collumn each for approved and released. The sheet itself will be updated manually each day when a department appoves an item which has previously been released.

What I am trying to do is keep a record of what we have outstanding and released relating to each department.

Any help would be greatly appreciated

A:Solved: Counting from 2 different Collumns

formula like
=SUMIF(\$A\$2:\$A\$12,A20,\$B\$2:\$B\$12) should work on the example you posted
see attached , i have completed for all

not sure of the fill colours - you could use conditional format to automate the colours

3 more replies

I have what I hope is a simple issue in Access. I have a simple set of results of targeted email campaigns. I have a Access report grouped by Salesperson and within that group, each email recipient is listed with an indication of whether or not that person opened our email. Such as:
Smith, George Opened
Smith, John Opened
Smith, Sarah Not Opened.

I am looking for the proper function/syntax to count the total number of "Opened" messages in each group. I've tried a DCount function, but haven't gotten it to work. I know I can work with a count in a query, but I'm interested to see if I can do this right in the report and learn something new regarding functions.
Thanks!

A:Conditional Counting in Access

6 more replies

I have Windows 98SE with a HP 842C Deskjet printer.
Does anyone know of any program that would allow me to see how many pages I have printed since the last ink refill?

A:Counting Printed Pages??

Bump

1 more replies

hi friends,
i am using excel 2010 and i need to know how it is possible to count how many times a text is repeating itself in a worksheet. this can be solved using simple commands but i have too many texts so i cant use the formula for every text. is there any way to count them...if you have thousands of texts in a sheet....

A:Solved: counting text

7 more replies

Hi,

Could you please explain how can I make counting numbers in powerpoint 2010?

As in this video: (0:46) http://www.youtube.com/watch?v=In1IJocVor8

Thanks a lot.

More replies

Hi all, I'm currently running HD Regenerator on my other computer and it's found lots (as you can see from the title) of bad sectors. It's slowly repairing them, but for every one it repairs, it finds another 5 or so.

Am I doing the right thing by just letting this run (It's been going all night and it's only checked about 20mb so far)

Is the amount of bad sectors rediculously high and should I just buy a new HD? I've been having problems with my hard-disk, when I get to a certain point (where all these bad secotrs are showing up), my computer starts restarting with a blue screen of death (kernal_inpage_error)

Will this Regen software repair it do you think? It says its repaired about 600 so far.

Sorry there's no real questions here, I was just wondering if anyone knows anything about if my drive could be repaired.

Thanks

10 more replies

Counting the number of particular process,

I couldn?t figure out if there is a way to count the number of particular process. For example, in the attached screenshot, the number of ?ArcSoc.exe? is three.

Is there a way to count them automatically?

Thank you

Best

Jamal

A:Counting the number of particular process,

You could click on the name column to sort processes by ascending/descending order. From the looks of things, your system is set up to sort based on disk activity right now.

7 more replies

I've downloaded one, but I wanted to know what's the best app out there. The store itself is not of much help.

More replies

I assume I need to use SQL. I know how to access a specific database and find the record count. Does anyone know how I access the MS Access DB and know how many tables are in that database? I need to export this count so another programming language (autoit) can pick it up.
Thanks

A:Counting tables in a MS Access DB

If you can get record count, you can get table count.

dim db as database
set db = currentdb
debug.print db.tabledefs.count

1 more replies

Hi,

When we right click on any folder or drive, and then see Properties, Windows shows count of files and folders. My question is that what technique Windows uses to count files and folders? Does it uses FindFirstFile() and FindNextFile() API or some other techniques? My doubt is because my program shows count slower than Windows. Anyone please clear my doubt.

Thanks and Regards,
Abhay

A:Counting Files and Folders

Originally Posted by Abhay Kumar

Hi,

When we right click on any folder or drive, and then see Properties, Windows shows count of files and folders. My question is that what technique Windows uses to count files and folders? Does it uses FindFirstFile() and FindNextFile() API or some other techniques? My doubt is because my program shows count slower than Windows. Anyone please clear my doubt.

Thanks and Regards,
Abhay

Sardinian Guy posted a prior topic on this and found out how to count files using powershell. Here is a link to that topic so you can check and see if his information answers your question. Good luck!

2 more replies

Hi again

Once again, I would like to thank all of you for your help in Excel programming. You guys are GREAT!!

I have another slight problem I need help with. I have a column, say column A, with text. Most of this text is repetitive in nature. I want to keep only the first 10 rows of the text that is repetitive and cut and paste the other repetitive text to sheet 2. Here is an example: Let us say that Column A has this text. I just used any text. The columns could have repetitive numbers as well. This is just an example.

qwe
qwe
qwe
qwe
qwe
qwe
qwe
qwe
qwe
qwe
qwe
qwe
rty
rty
rty
rty
uio
uio
uio
uio
uio
uio
uio
uio
uio
uio
uio
uio
uio
uio

Etc down the column. This list is extremely long. As you can see form my example, there are 12 qwe's, 4 rty's and 13 uio's. I would like to keep only ten or less of each groupings and cut and paste those groupings in excess of 10 into sheet 2. In other words, when the macro is run, I would like to have 10 qwe's, 4 rty's and 10 uio's in sheet 1. Sheet 2 would then have 2 qwe's and 3 uio's.

I have tried to create a macro by myself but this is beyond my prgramming expertise. Any help woud be appreciated.

Mario

A:Counting rows in Excel

16 more replies

does anyone know of a formula to count how many numbers there are in a single cell?? For instance, Cell A1 has "32, 567, 47, 3563" I need a formula to count that there are 4 numbers there. Is this possible???

A:Excel Formula::Counting

8 more replies

In wordperfect 10 how do I get document information, number of words in a document, etc.

More replies

Am using Athlon 600 with 128 Ram. Pc has for some reason stopped counting Ram at bootup which it usually did. Any ideas?

A:{SOLVED} Pc not counting RAM at bootup

Do you mean it doesn't work or just that the screen with it counting is being bypassed?

Many systems have that as an option - just go into CMOS and look around for something like QuickStart or Memory Test and turn it back on if it is disabled.

2 more replies

Hey there,

I keep getting BSOD's on my Machine. They vary from most being System service exceptions, to IRQL not less or equal, and a couple more that I cannot remember. My event log has recorded 18 thus far, but I've had more - before I installed Windows 7 x64 from XP-64bit.

They are all event ID 41...I'm assuming that's generic and all from the same issue?
I'm using:

Windows 7 x64 (BSODs also happend before I had w7 installed.)
i7 @ 2.6
P6T mobo
gtx260 gpu
6GB G.Skill ram.

Nothing's overclocked, everything is stock.
I've ran memtest and it came back clean - I did 1 pass...but I figure that's fine. I'm certain I've installed up to date drivers for my gtx260, etc. Is there anything that can solve these issues? I believe I've flashed my BIOS with the new firmware as well....
Help!

A:18 BSOD's and counting. win7 x64.

I've attached the .dmp files into a folder. From what I've read, this might help you all.....

Thanks.

9 more replies

Hello, Is there a formula that counts rows. What I'm trying to do is count the number of rows that I highlight to see if I'm missing anything. After I check, I would delete this formula. It would be easier than trying to subtract cell numbers or count I,2,3.

Thanks, Mike

A:Solved: Counting Rows

8 more replies

Hi again

This time I've encountered another problem with dates. Below are a series of dates in one column formatted mmm-yy. I have many of these dates ranging from Jan-05 to Dec-05 and a few in Jan-06. I want to have a count of how many Jan-05 I have, how may Feb-05 I have etc. I want a number count. for example I have 2 May-05 and 8 Sep-05. The countif formula does not work since it requires the full date, i.e. May 12, 2005 etc. But then it only gives me 1 count only, since the other May-05 has a different date. All I want is to count the months only. Any idea how to do this?? Do you have to write a macro to accomplish this task??

Mario
May-05
May-05
Jun-05
Jun-05
Jul-05
Jul-05
Aug-05
Aug-05
Sep-05
Sep-05
Sep-05
Sep-05
Sep-05
Sep-05
Sep-05
Sep-05

A:Counting Months only in Excel

11 more replies

Brand new system with Asus A7N8X-X mobo, AMD Athlon processor.

The first hard drive was a western digital. It immediately started making loud clicking noises when I powered it up.

I returned it and bought a Maxtor diamond Max 80GB drive. This one allowed me to install windows, etc, and then started making clicking noises and locking up. Powermax reported that the drive was failing.

Returned it and got an identical Maxtor drive. Everything worked perfectly for a few days. Since I actually got the pc to boot, and some software installed, I discovered that the system was very unstable. A memory test revealed that the memory stick was bad. After replacing it, all was well.

I sent the computer home with its rightful owner, and he called me almost immediately. As soon as he powered it on, the hard drive started making loud clicking noises and locked up. Powermax revealed that the drive was failing.

How likely is it that this computer destroys three hard drives? Is there any possibility that the mobo or power supply is frying these drives? I've been carefully watching heat, and it seems withing tolerable ranges. HD is about 100 degrees, CPU around 115 degrees. The case has two big fans on it, and the cpu has another.

Am I doing something wrong?

A:Three hard drives down and counting

Check and/or replace the HD data and power cables. I once killed a floppy drive because the power cable was assembled wrong and 12V went to the 5V pin..

Check the PSU voltage levels too.

5 more replies

This is multi-part question on how to create different formulas on the attached worksheet.

#1 - I would like to count the number of Start Dates IF the Start Date is blank or greater than today, but only IF there is a date in the Requisition Date column. This would be to indicate the total number of open positions as of today.

#2 - I would like to count the number of cells in column A that are greater than or equal to 17 IF the Start Date is blank or greater than today, but only IF there is a date in the Requisition Date column. This would indicate total number of open positions that have a grade lever of 17 or above.

A:Excel-Counting with dates

7 more replies

Hello,

I recently put a workstation together and am expeirencing the memory counter checking/testing/counting the memory 5 or more times. Sometimes its only three, tonight it was five or six...

The board is an MSI 6368 ver2.1

The BIOS is Award Modular W6368MS Ver 3.1 051501 Pentium 3 1000 Mhz 133 x 7.5 512mb of pc133 generic memory [IBM]

The power supply is 250 watt, and is running Windows Advanced Server, why? I dont know... practise ... lol.. anyways...

It gives me the option "esc" to skip memory test then boot.

I would like to know how to set this counter so it is not counting the memory more than once at boot up.

Thank You

Eli

A:keeps counting memory at boot-up

Enable "Quick power on self test" in BIOS

3 more replies

Hi all,

This summer I designed an Access 2003 database that tracked volunteers for an organization.

They've asked if they could create a report that provides a list of how many volunteers they had in a given period. They only want to count the person no matter how many sessions they've volunteered during the time period.

I've thought about grouping by Unique_ID and then counting the groups, but that leaves me with the question of what to display on the report. Also, I'd like to be able to display the inputted date range (obtained from the query) on the report, if possible.

any ideas on how to accomplish this?

Thanks!
Elizabeth

A:Report Counting Volunteers

11 more replies

current lab wants us to create an abstract class w/ two concrete classes and an interface used by the abstract class (and hence the concrete classes) and to create another concrete claas based on the interface

so far so easy

then he wants us to create an array w/ at least one type of each concrete class...ok..easy enough.

in fact i'm done w/ this part and have it tested

now he wants us to count the number of instantiations of each concreate class

ok so i'm going to create a private static var ( count) in each concrete class and a public static method in each concrete class to return the count

question: where should i increment the counter...i would think the constructor of each class is the place to do so...he said no...

1. should i create public static count routine in each concrete class

2. should i create publice static var count in the abstract class and public static abstract method count in my abstract class

A:counting class types

i presume this is java? the two classes inherit from the abstract class. Ya?
if so you would go with the second option. don't use a method for increment the number let the constructor do it.

1 more replies

Hi,

I have a data set on the semiconductor industry with 4 main columns that looks like this:

Alliance Description Product&Service Transistor_Technology Feature_Size

Alliance Description contains paragraphical company descriptions in each cell. For example, "Multi-year agreement for technology licensing and development. The three-phase agreement includes the transfer of Sharp's 0.25´ process technology to 1Si, joint research and development of 0.18´ technology, and a wafer supply agreement for Sharp. Sharp agreed to buy 20% of the fab's output (more than \$300 million worth of wafer shipments) through 2005. "

Each Alliance can be described as under 3 broad categories of Product & Service, Transistor Technology and Feature Size.

Under each broad category of Product & Service, Transistor Technology and Feature Size, I have sub categories in columns as below:

Product&Service Transistor_Technology Feature_Size
DigBipolar StdAnalog ........ Gallium Silicon ....... >1micron 1 micron....

Total no. of sub categories for Product and Service: 15 sub columns (DigBipolar, StdAnalog etc)
Total no. of sub categories for Transistor_Technology : 10 sub columns (Gallium, Silicon etc)
Total no. of sub categories for Feature_Size : 10 sub columns (>1 micron, 1 micron etc)

The sub categories as stated above (eg., DigBipolar, StdAnalog etc) in each of the 3 broad categories contain either 0s or 1s (this is something like a flag or an indicator va... Read more

A:Counting rows with 0s in excel: Urgent

7 more replies

Hi All,

Please refer to the attached example.

I'm trying to count the number of visits carried out in a particular quarter BUT exlude any visits which are of Visit Type Event. So in the example the result would be 1.

I've been seeing if there is a clean way of doing this as one function but have been scratching my head. Can anyone suggest a method?

Thanks,

Beefy

A:Solved: Conditional Counting of Cells

8 more replies

Hi there,

I have a query that currently displays all data from certain fields in my database when I run the query.

One of those fields in the query is 'Date' another field is 'Name of student' and the other is 'description of duty'. What this is showing is on a particular date, what students have to do which duties around the school.

I need to create another field in the query which will count the number of students doing a particular duty on a certain date.

So for example:
On the 28/11/2011, there are 5 students doing the duty of cleaning up the common room.

Currently when I run the query this is shown as a date in one field, the duty in another field and the students doing the duty in yet another field.

What I want is another field called 'number of students doing duty' which would show (for the example I gave before) the number 5.

Any help ASAP would be appreciated.

A:Record counting in Access 2007

This sounds a bit like School or College course work to me.
This may take more than one query to do what you want, one query to Group the Date and Duty and then a second query based on the first query with the original table added and linked via the Date & Duty fields to count the number of Students.

1 more replies

Is it possible to count how many times a single word occurs in a MS word document. For example, if I wanted to count all instances of the word 'apples' in a document, is there a way to do it?

I've tried scouring MS Office help but without any success (no surprise there I guess).

[edited for typos]

A:Counting Individual Words In Ms Word

Hi Floydoid.
Outside of a macro, the easiest way is to just open the .doc in Word then click Edit>Find.
Type the word you're looking for in the "Find What" box and put a checkmark in the "Highlight all items found" option. Click the "Find All" button. Above the buttons, word will give you the number of times the matching criteria (the word) was found.

3 more replies

Hi. Lets say that i have a table that contains check boxes. My report lists all the checkboxes, and down in the page footer, I want to have a text box that counts the number of checked boxes. My checkbox name is called checkbox and i've tried many variations of =Sum and =Count and can't seem to get it to work. My textbox always ends up showing =Error when I run the report. Any suggestions?

Thanks.

A:Counting Checkboxes in Access Report

Have you tried this variation?

=Sum(Iif([checkbox]=True;1;0))

The problem with this is that you probably want a total just for the page in question. Access doesn't do this without a little more complexity than you might expect, but it does do it. This article from MS shows you how it works:

ACC2000: How to Create Page Totals on a Report

3 more replies

I have a list of incidents catagorised by Date, type, and Cause. I want to show (using formulae) totals as follows

All incidents in a given year - I've done this by using

=COUNTIFS(\$C\$4:\$C\$123,">=01/01/2006", \$C\$4:\$C\$123,"<=31/12/2006")

for each year which works very well. Now I want to total how many of a specfic type of incident occur in a given year - I tried this

=COUNTIFS(\$C\$4:\$C\$123,">=01/01/2006", \$C\$4:\$C\$123,"<=31/12/2006", \$D\$4:\$D\$124, "=contact")

which returns #VALUE! error, I'm guessing its because I've introduced a text value but am not sure.

There must be a simpler and more elgant way to get Excel to do what I want, can anybody help ?

A:Excel 2007 - conditional counting

From the help file:

"Important: Each additional range must have the same number of rows (and columns) as the criteria_range1 argument. The ranges do not have to be adjacent to each other."

There must be a simpler and more elgant way to get Excel to do what I wantClick to expand...

Using Pivot Tables in Microsoft Excel

1 more replies

I have a database that I would like to use to capture numbers of events per month based on certain conditions. For simplicity sake assume I have three columns. Column 1 is the date. Column 2 is the division code (assume for a forumula that one of the codes is NI). Column 3 is the type of event (assume for the formula that one of the event codes is PER). I've been able to count the number of events where NI and PER occur using the COUNTIFS formula. However, when I try to narrow the count to a specific month I cannot seem to get the formula to work. Suggestions? Thanks.

A:Solved: MS Excel counting for three conditions

7 more replies

Hi guys,

In a previous thread I have asked how to conditional format fields within a certain time frame and have been given the answer =TODAY()-[No of days].

This works sucessfully, so that if I want to mark every date more than a year old in red the command is =TODAY()-365.

Is there a way that I can then count these fields?

Basically.. after they have been marked red I want to know how many reds i have in each column..

Sorry... im an excel newbie .

Thanks

A:Solved: Excel, Counting certain fields

Use the CountIf function.

Select the range of cells that you want to have counted and then enter a condition like >365

That should do what you want to do.

1 more replies

I have data of the monthly total of purchases by each customer. It looks something like this: 0,0,0,100,200,0,0,300,0,0,0,20,0,250,0,0. All in separate cells in a row. I want to be able to return the values of 2,3,1. I need to find a way to count the amount of zero values between the non zero values. With or without the amount of zeros following the last nonzero number is a little less important. For reference I have a formula to count to the amount of months since the first purchase and also the amount of months since the last purchase. They are the following: =COUNT(DD2:INDEX(A2:DD2,MATCH("",T(1/A2:DD2),0))) and =ROWS(A2:DD2)-MATCH(2,1/(A2:DD2>0))+108. Any Help would be greatly appreciated. Thanks PS using Excel 2010 I believe

A:Counting the Spans of Zeros between non-zero values

Try the array formula below in DL2. Confirm it with Ctrl + Shift + Enter instead of the regular Enter. Fill down through all of your rows, then fill right as far as you need to. In each column it should list the size of the gap between non-zero entries. See attached for (hopefully) more clarity: =IFERROR(SMALL(IF(\$G2:\$DJ2>0,COLUMN(\$G2:\$DJ2)),COLUMN(A:A)+1)-SMALL(IF(\$G2:\$DJ2>0,COLUMN(\$G2:\$DJ2)),COLUMN(A:A))-1,"") The results I've checked appear to hold up?

4 more replies

I have an issue with counting [COLOR=blue !important][COLOR=blue !important]records[/COLOR][/COLOR]. In one report all records and the one filtered by Director, I need to total up the records in the employee info table and have the count available for a calculation in the reports, Takes the total hours and divides by the number of employees. In the filtered form, Director Report Date I would like it to go and tally the records of all the employees for the director chosen in the form each time the report is run so if they add employees the calculation will always be current. The same thing needs to happen for the ALL employee report... count all records and store. Should this be controlled by the form? I have included a copy of the mdb.

A:Counting Records using form criteria

10 more replies

Hello. I'm on excel 2007. I have two lists of names and other information. I need a formula that will tell me how many names appear on both lists. I can't see anything that seems to do this or I'm just filling it out wrong. Please help!

More replies

I have a database for a senior center membership. Members are from a number of area towns. I am trying to write a report showing the demographics by town. ie gender, age etc. I have grouped a count of members by town, and now I want break that down by age groups. It would look something like this:
ANYTOWN 50-60 60-70 70+
members = 20 10 5 5

NEXTOWN
members = 10 3 3 4

ETC.

I found a function on line that will compute ages from DOB and assign them to age groups. I use this function in a query that gives me the demographic info I'm looking for, including a column named "AgeGrps" My problem is "How do I get a count of each age group by town in the format shown above?" Any help will be greatly appreciated

A:Counting Age Groups in an Access Report

Ron, it may take 2 queries to do this, one to put them in to the age groups and then a second one to Group and count them by Town. Or you could possibly use a Crosstab to do the Grouping and Counting.

Can you post a zipped Access 2000-2003 copy of the Database for us to look at?

1 more replies

got this machine free cause it was infected, thought I got rid of most of the stuff but now I'm at a loss. Keeps getting hit with some "your computer is infected, buy this software" which I know is only going to clean my bank account. Most recent one was right after zone alarm alerted me to a blocked inbound communication "thanks zone alarm" but some still get through.

Here is my dds log

DDS (Ver_09-10-26.01) - NTFSx86
Run by Mark at 21:55:27.64 on Thu 11/19/2009
Internet Explorer: 8.0.6001.18702 BrowserJavaVersion: 1.6.0_17
Microsoft Windows XP Home Edition 5.1.2600.3.1252.1.1033.18.511.201 [GMT -8:00]

AV: ZoneAlarm Security Suite Antivirus *On-access scanning enabled* (Updated) {5D467B10-818C-4CAB-9FF7-6893B5B8F3CF}
FW: ZoneAlarm Security Suite Firewall *enabled* {829BDA32-94B3-44F4-8446-F8FCFF809F8B}

============== Running Processes ===============

C:\WINDOWS\system32\svchost -k DcomLaunch
svchost.exe
C:\WINDOWS\System32\svchost.exe -k netsvcs
C:\WINDOWS\system32\svchost.exe -k WudfServiceGroup
svchost.exe
C:\WINDOWS\Explorer.EXE
svchost.exe
C:\WINDOWS\system32\ZoneLabs\vsmon.exe
C:\WINDOWS\system32\spoolsv.exe
svchost.exe
C:\WINDOWS\System32\svchost.exe -k HTTPFilter
C:\Program Files\Java\jre6\bin\jqs.exe
C:\WINDOWS\system32\svchost.exe -k imgsvc

A:funweb products and more, 26 infections gone and still counting

2 more replies

Hi all, appreciate if you would help me on this.A1 6/11/2015 18:00A2 6/12/2015 10:00Working hours 08:00 to 19:00I want times not worked (Weekend included)From the cell above, I wanted it to count from 6/11/15 08:00 to 18:00 = 10 hrs6/12/15 10:00 to 19:00 = 9 hrsSo the formula should spit 19 hours not worked (Hours worked is 3 hours)Also includes weekend (no need to use NETWORKDAYS)Thanks..

A:Counting hours not worked between two dates

OK,Try this:=(A1-(INT(A1)+"08:00"))+((INT(A2)+"19:00")-A2)Was getting, what you refer to as, UpTime & DownTIme confused.See how that works.EDIT:Modified formula so it is shorter and times are hard coded.MIKEhttp://www.skeptic.com/message edited by mmcconaghy

23 more replies

Greetings

Are we having fun yet?

Cheers

------------------
Reuel Miller
Windows NT Moderator (yes, that does make me biased )

[email protected]

Every morning is the dawn of a new error...

More replies

How do you create a drop down menu and count the number of times you click that value into another cell? But have the drop down menus disappear once you've chosen your value so that you can choose another one but still count your previous selection?Here's the scenario:I have about 20 values in a drop down list according to each person, but a person can have more than one of those categories over a month's span.I have those same values spread across right next to it, 20 columns. Each of those has a box to tally each category when chosen. I want to pick a value from the list, have it recorded, then be able to choose another one but keeping the past selections. Hope I explained this wellmessage edited by mike.vandam

A:Counting occurrences from a drop down list

Well, I'm confused. Keep in mind that we can not see your worksheet from where we are sitting.re: "I have about 20 values in a drop down list according to each person, but a person can have more than one of those categories over a month's span."What do you mean by "according to each person"? Do you mean that you have a column of names and a drop-down list next to each name?re: "I have those same values spread across right next to it, 20 columns. "By "it" I assume you mean the drop down list, correct?re: "Each of those has a box to tally each category when chosen."I have no idea what that means.re: "I want to pick a value from the list, have it recorded, then be able to choose another one but keeping the past selections. "Have it recorded where? Keep the past selection where?I don't see the relationship between your "20 columns of values", the drop-downs, the tally, etc.Perhaps some example data would help. Please click on the following line and read the instructions on how to post example data in this forum.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

4 more replies

I Have this staff rotaion spreadsheet which basicly lists staff members verticaly on the left, the days are listed horizontaly along the top and any abscence is added as follows A = Annual leave, S = Sick etc etc etc.

I have attached a copy for you to take a look at.

The second worksheet calculates all of this activity.

My problem is at the moment the second worksheet is being calculated manually. I want it to be automaticly calculated.

I have tried adding in IF formulas but im having no luck at all

basicly I want the second work sheet to add up all A,S,T's for each staff member??

Can someone pleeeeeaaaaassse help me ?????

Thanks all

A:Counting from a seperate work sheet

Hi Dan,

I'm not sure I understand your problem, but see the attachment, maybe that is what you are looking for. In particular, take a look at range H3:J17 on sheet REPORT.

Jimmy

1 more replies

May 31st started my problem. At first I noticed that when I googled something my searches ended up going to somewhere else. Then I noticed that all of my programs in the start menu dissapeared, i tried to clean my system by going to "Accessories" and "system tools" and "disk cleanup" but nothing is there anymore. I have downloaded and run numerous virus scans. Numerous viruses have been found and I eliminated them, but that never works as there is always something else that is hosing the system. I can not surf the internet, some programs are gone and this has been going on for what seems like an eternity. When I open a program, like a MS Word 2010 document then MS Word 2010 shows up again under "Programs", otherwise, nothing shows up.
I have run anti-virus programs now and nothing shows up, but the problms still exist. Any help is greatly appreciated.
Thanks,
Ron

hp Pavilion a 1540n
OS Version: Microsoft Windows XP Professional, Service Pack 3, 32 bit
Processor: AMD Athlon(tm) 64 X2 Dual Core Processor 4200+, x86 Family 15 Model 75 Stepping 2
Processor Count: 2
RAM: 1982 Mb
Graphics Card: NVIDIA GeForce 6150 LE , 256 Mb
Hard Drives: C: Total - 238464 MB, Free - 159404 MB;
Motherboard: ASUSTek Computer INC., NODUSM, 1.03, MB-1234567890
Antivirus: AVG Internet Security 2011, Updated: Yes, On-Demand Scanner: Enabled

Logfile of Trend Micro HijackThis v2.0.4
Scan saved at 1:09:05 PM, on 6/10/2011
Platform: Windows XP SP3 (WinNT 5.01.2600... Read more

A:Redirect: And other stuff. 2 weeks and counting

6 more replies

I am trying to use "Count" to count each individual record in a Query. I only have 25 records in the database so far, and each time I run the query record #2 counts as "5". Everything else shows a "1". I have looked at my table setup, and all the records are set up just alike. I can't figure out what's wrong.

Anyone have any ideas?

A:Help counting records in Access Query

What kind of query? A Totals Query I hope?
What field are you "counting"?
Are you SURE it's record #2 and not 5 records for that field?

3 more replies

A:Yoga 900 dead -- 4 weeks and counting

I have this problem too, and this is my second Yoga 900 with "dead" issues!  Except, the first time it occurred, I was able to get a replacement becuase it "died" within one month of the date of purchase.  Boy, am I regretting this now!! So far, my issue is 2 weeks and counting, with no call back from Lenovo.  The last time that I called (yesterday, on 6/16/16) they told me that someone would be coming out to service me, but that they were awaiting a "mother board"....????? Red flags all over the place.  I empathize with you and have just contaced CNET,  and also plan on making a bit of noise at home office  (my colleage's spouse knows a few big wigs at Lenovo).  I'm truely sorry that you are experiencing this as well chrisheider.  Please post with your ongoing status, this is a nightmare!!!!

1 more replies

Here's the situation. I've come home for the weekend and found that the computer here is loaded with problems (probably been accumulating for 3 years or so). I've done as much as I could, but here's a detailed description of what I've done so far... and what more is there to be done.

-First tried to run virusscan, but realized that norton antivirus stopped allowing system scans
-tried to run msconfig, but wouldn't let me do anything... assumed it was a virus
-reinstalled norton antivirus 2006, scan once again didn't work (don't ask me why i was so persistant with this)

-went on symantec.com and did a webscan, which at least made my installed and running antivirus start picking up viruses as the file was scanned online... computer then restarted it, and I gave up... quarantined and deleted all picked up files
-lurked around a lot and did some tweaking with RegSeeker, put up a firewall from Zone Alarm, used CleanUP!, used KillBox to get rid of some folders, and loaded .dlls
-ran panda scan, have the log but didn't know how to delete the viruses on there
-currently defragging and running Housecall virus scanner

now, I have a couple problems still. my msconfig works, but my norton doesn't... i just deleted it since there probably is a friendlier program i can use. some other programs like unlinker say that they're missing the correct program associated, yadda yadda... so here's my hijackthis log. please tell me what i need... Read more

A:60+ viruses and counting (deleted as detected?)

I've noticed a lot of analysts on the site recommending online scanners which you've already done. I wanted to also suggest that if you're looking for a good virus protection for free. Check out AVG.

http://free.grisoft.com/doc/1

It's the best free virus protection I've come across and use load it on anyone's PC that didn't have virus protection and they didn't want to buy Norton's...

5 more replies

I?m not sure how it happened, but my Windows 7 laptop started doing an upgrade to Win 10 four days ago, and it still seems to be in the process. The hard drive light periodically flashes. Control/Alt/Delete does nothing. When I power down and try to power back up into safe mode it shows me the Win 10 windows logo and then continues the upgrade process never allowing me into safe mode. Any ideas on how I might be able to fix this?

A:Win 10 Upgrade Hang – Four Days and Counting

Turn it off, unplug it, and remove the battery. Hold the Start Button down for one minute, and then put it back together and turn it on. If that doesn't get you back into 7, it's possible that you have had a hardware failure.

2 more replies

I have a table with about a dozen Yes/No boxes. The Table has a column for each Yes/No choice. Each user will go to a form with 12 choices and can click from 1 to 12 choices. I would like to be able to have a report for each user that will show the number of selections.

Example:
User #1 picks 4 of 12, User #2 picks 8 of 12, and User #3 picks 12 of 12.
I would then like to be able to run a report that looks at at each row in the table and counts how many "yes" then divides that by the number of choices and displays a percentage.

Output on form would be something like:
User #1: 33%
User #2: 67%
User #3: 100%

What would be the best way to perform this task with me stating that my Access 2007 skills are in the beginner stages? Thanks in advance for any suggestions.

Danny

A:Counting Yes/No Boxes in Access 2007

6 more replies

Hi, I have another counting formula required. I currently have 4 statuses New, Problem, Open and Closed. I have a count of days old for open items, the other statuses have -41128 etc.

I have built a formula to distinguish between anything other than "Open" as a "0" as below:

=IF(A:A<>"OPEN", 0,1)

What I require is a formula that will count up the amount of days in total of any open items and not count the closed, problem and new statuses. Please see attached example. Total of open days old should be 167

Cheers

A:Solved: Excel - Another Counting Formula

Try this:

Code:
=SUMIF(A2:A13,"OPEN",C2:C13)
Jimmy

2 more replies

ok heres the setup word 2003 and i need to count the number of characters in a document - how???? and don't say count 'em

A:Solved: character counting in word

open the doc, click tools, then word count.
it does characters to.

2 more replies

A friend asked me to take a look at his machine because it was slow and he thought it 'might have a virus' after McAfee expired - bit of an understatment ! So far Spybot and Superantispyware have detected and cleaned almost 1000 trojans, keyloggers, and numerous toolbars and hijackers.

I'm posting the HJT log to get an informed opinion, because even to my untrained eye it looks like there may still be some issues to resolve. I'm also unsure how many HJT logs to post - his machine runs XP Home edition, but there are four different logons, one for each member of the family; do I need to post an HJT log for each profile?

Any help appreciated.

Logfile of Trend Micro HijackThis v2.0.2
Scan saved at 9:32:22 PM, on 5/07/2008
Platform: Windows XP SP3 (WinNT 5.01.2600)
MSIE: Internet Explorer v7.00 (7.00.6000.16674)
Boot mode: Normal

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\Program Files\Alwil Software\Avast4\aswUpdSv.exe
C:\Program Files\Alwil Software\Avast4\ashServ.exe
C:\WINDOWS\system32\spoolsv.exe
C:\Program Files\Common Files\Apple\Mobile Device Support\bin\AppleMobileDeviceService.exe
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\mscorsvw.exe
C:\Program Files\iolo\common\lib\ioloServiceManager.exe
C:\WINDOWS\System32\svchost.exe
C:\Program Files\Alwil Software\Avast4\ashMaiSv.exe

A:Solved: 700 pieces of spyware and counting !

14 more replies

i need to Count how many cells in col(O) display a "Y" between dates in col(C)

at the moment i use countif but this just counts all the "Y"'s

Excel 2007

each row displays many columns of data

the counting takes place on another sheet in the book as the data sheet cant be edited

each job entry is not necessarily in the correct date order as they are listed per job number col(A)

so i would like a formula to look at each date, access whether it falls between the given dates, and report back how many entries within the dates is marked with a "Y"

A:Counting criteria dependant on dates

Hi, since I have absolutely no idea of what you have my suggestion may not work but maybe you could add an extra column that, based on a formula that checks a specifi dat that could be entered in let's zay Z1 puts a 1 in all cells in a column next to column C where the date should be counted for and then count all "Y' where that column = 1 ?

No version of Excel, no idea of the further lay-out, so it's just a blind suggestion... hope you can do something with it.

2 more replies

Hello,

I am new to this forum but this afternoon I have been experiencing major issuues with my computer and I would appreciate if any among you who read these forum could lend me a hand fixing this........cause I am getting reboots every 20 minutes...formatting would be an option of course but I would preffer another type of solution if that is possible.....

Problem signature:
Problem Event Name: BlueScreen
OS Version: 6.1.7100.2.0.0.256.1
Locale ID: 2057

BCCode: d1
BCP1: 00000064
BCP2: 00000002
BCP3: 00000000
BCP4: 98079D54
OS Version: 6_1_7100
Service Pack: 0_0
Product: 256_1

Files that help describe the problem:
C:\Windows\Minidump\032210-35115-01.dmp
C:\Users\Tiago\AppData\Local\Temp\WER-43259-0.sysdata.xml

This was the message I got from what hapened , also sending the dump files, I don't know if they are of any help but to be honest I am no expert on computers either, just doing what I ... Read more

A:11th Blue Screen and Counting...

Welcome to the forums Drakulea.

For future reference, their is a section of the forums dedicated to Crashes and debugging where most of the users who check crash dumps frequent.

4 more replies

Hi all,

I have an excel sheet with numbers of different users, numbers of different municipalities and in each record a code for a status:A-B-C-D-E-H and X.
I would need to calculate for each user the total of occurrences of the different statuses, as well as the overall total of all his records. For instance user nr 100 has 45 records, with 20 A statuses, 15 B statuses, 10 C statuses, etc...
Thanks in advance for any help.

Eddy

A:Counting the occurence of certain values for several users

9 more replies

Access 2000, Windows XP OS

I need to sort records in groups using the fields:

DATE-OUT , EQUIPMENT , LOCATION , INSTRUCTOR,
1/5/05, LCD-Pro, LAB 101, JONES,

and get a count for the equipment used in the location field and a count of the equipment used by each instructor. In other words what I need to know is

1. How many LCDs were used in LAB101 between 1/1/04 and now.
2. How many LCDa did Instructor JONES use between 1/1/04 and now

The DATE-OUT field has records from 1/1/02 thru 6/9/05, I need to use all the records from 1/1/04 to now. I tried using >12/31/03 in the criteria box, but when I use the group by for the LOCATION and INSTRUCTOR I get separate dates. I just need the date range not each date. They need to be sorted by EQUIPMENT, which only matches any reference to LCD in the field and they need to be grouped by LOCATION, and INSTRUCTOR. When I use group by for the two fields LOCATION and INSTRUCTOR I get nothing. Please help. Thanks.

A:Access Grouping and counting records

6 more replies

I've never posted on a help board before, so I hope I include everything needed. At about 10pm Sunday night my computer started fussing at me, (wanting to change the registry constantly) and this was followed by massive pop-ups. I keep my computer in good shape (I thought), so I knew right away something got me. At that time I was using Avast Antivirus and Spyware Search & Destroy. Both programs didn't find anything, however a program I didn't even know I had found lots....luckily I was suspicious of that and stayed away because I found out later that was actually part of the virus.I installed McAfee (and uninstalled the other 2) ...still nothing found.Installed various other programs, including the VundoFix, which picked up 3 instances but couldn't keep them away.I saw a lot of people were having good luck with Spyware Doctor, so I dl that and after the search came up positive I bought the program (I was desperate and it was now 3am). This program keeps coming up with 1 threat and 39 infections but after I restart they essentially come back.Here are some specific problems i'm having:"userinit.exe error...the application failed to initialize properly.." after starting up, I don't see the startbar or icons, just the background. I use CTRL+ALT+DLT to bring up task manager and run explorer and any other prgms."rundll32.exe" error when I attempt to turn on firewall, or do anything related to firewall (through control panel or networking)I managed to stop a... Read more

A:Infected With Virtumonde (fighting 12 Hrs And Counting)

Not sure if anyone is going to have a go with this one but I have made some progress with it myself....so I thought I would update, and perhaps offer advice if anyone happens to be in the same boat.

I booted from my WinXP disk and went into DOS in order to delete that one file that I couldn't (edniuj.dll) After starting back up I just about screamed because I didn't get those userinit.exe errors. I also saw the startbar and icons pop up. I have yet to get any rundll32.exe errors so I got the firewall going. The only thing that looks off is after a minute or two the desktop background disappears and is replaced with what looks like the inside of an explorer folder, complete with a couple extra clickable icons.

I also went into regedit and searched for anything with MS Juan, found a couple hits, deleted those.
I am currently running Kaspersky again, so far...at 35%, nothing.

I would certainly appreciate any other insight on getting rid or clearing up other places this bug might be hiding.
I imagine i'm not out of the woods yet?

I will post the resulting logs here when they are done.
-Layla

5 more replies

Hi There!

I have a I7 920, with 12GB DDR3-1600 Memory, 2 x 300GB Raptors in a RAID 0, 1 x 300GB standalone and 640GB Standalone, and a ATI 4870x2 video card. I am upgrading using a DVD, and basically it's taken 7 hours before I aborted the upgrade (62% completed migrating folders and files). All my other upgrades have gone reasonably quickly (Though not as quickly as some other installs and upgrades seem to go on lesser hardware) though the other 6 builds I have run. I don't really want to run a fresh install, can anyone suggest a solution? Does W7 not really like ICHR10?

A:7137 Upgrade 7 hours and counting

Try doing it with only 2gb ram install, during installation, put addition ram back in after it cycles & completes. Disconnect any un-necessary USB devices, USB camera, etc. They will install, later

5 more replies

I have a report with students
I have grouped them by age and now I want to count the number of males and the number of females and have it show on the report

A:Access 2000: counting in a report

I removed your extra post and renamed this one. Next time, you can EDIT this one using the Thread Tools dropdown.

1 more replies

I have an excel spreadsheet--in which I cannot use VBA (for security reasons)--and I am trying to count cells. Each day that an occurance does not happen, an accident for example, I add 1 to the current day (for weekdays) and one for each weekend. However, if an occurance does happen, I need to reset the count to 0. Across the top of the sheet, I have the dates. I have a formula that looks like such:=IF(I\$1="E",COUNTIF(\$C\$1:I\$1,"E")+IF(\$C3="X",0,\$C3),IF(AND(I\$1="D",H\$1="D",H3="X"),1,COUNTIF(\$B\$1:I\$1,"D")+IF(\$B3="X",0,\$B3))). The problem is that the formula only counts from the begining, and I need it to change to where it counts from the last "X" (for weekday or weekend as needed). Basically I have two individual sheets on top of one another--!
I am sure that the answer is stupidly simple, I just can't see it. Any help is greatly appreciated.

12 more replies

I'm a phone guy--not a computer expert, but I usually do better than this. I admit, I haven't been able to shake this nasty bug. Any help MUCHO appreciated!
I got the Norton warning, disabled system restore, went in safe mode, downloaded the Symantec removal tool, didn't work, tried to manually delete any instance of "ddcyw.dll" and that didn't work, installed HijackThis and here is my most recent scan log:

Logfile of HijackThis v1.99.1
Scan saved at 10:38:30 PM, on 4/16/2006
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\Explorer.EXE
C:\Program Files\Internet Explorer\iexplore.exe
C:\Program Files\HijackThis\HijackThis.exe

R1 - HKCU\Software\Microsoft\Internet Explorer\Main,Default_Page_URL = http://www.dell4me.com/myway
R0 - HKCU\Software\Microsoft\Internet Explorer\Main,Start Page = http://www.dell4me.com/myway
R1 - HKLM\Software\Microsoft\Internet Explorer\Main,Default_Page_URL = http://www.dell4me.com/myway
R0 - HKLM\Software\Microsoft\Internet Explorer\Main,Start Page = http://www.dell4me.com/myway
R1 - HKCU\Software\Microsoft\Internet Connection Wizard,ShellNext = http://www.dell.com/
O2 - BHO: AcroIEHlprObj Class - {06849E9F-C8D7-4D59-B87D-784B7D6BE0B3} - C:\Program Files\Ad... Read more

A:Trojan.Vundo (ddcyw.dll) 3 weeks & counting!

* Double-click VundoFix.exe to run it.
* Put a check next to Run VundoFix as a task.
* You will receive a message saying vundofix will close and re-open in a minute or less. Click OK
* When VundoFix re-opens, click the Scan for Vundo button.
* Once it's done scanning, click the Remove Vundo button.
* You will receive a prompt asking if you want to remove the files, click YES
* Once you click yes, your desktop will go blank as it starts removing Vundo.
* When completed, it will prompt that it will shutdown your computer, click OK.
* Turn your computer back on.
Post the contents of C:\vundofix.txt as well as a new HijackThis log

2 more replies

I am trying to figure out a formula for Microsoft Excel. I want to be able to count up the number of cells in a column that are being used (or have text in them).

Is there a formula that would count this? Many thanks in advance.

A:(Excel) Formula for counting cells in a column

10 more replies

I'm on a Lumia 1520 (RM-938) running Denim. Error messages says to refresh data, but it doesn't help. Anyone?

A:MSN Health and Fitness stopped counting steps

Post Denim, there is an update to Motion Data. Use SysApp Pusher to verify your (App) setting entry is updated to the latest version.

14 more replies

I am using Excel 2007

I have a .csv file that can be dropped into Excel (see attached - "January Example for Email"). Look at column "F - Study Date Time". I need to auto populate that column of information, separated by total number of entries for a particular hour, into a second spreadsheet (see attached - "CT Exam Hourly Matrix").

Looking at "January Example for Email", column "F", the first entry is "1/1/2012 1:24". On that date, from the 1:00 - 2:00 hour (using 24 hr military time), there is one (1) entry to autopopulate into "CT Exam Hourly Matrix" B:3. The second entry in "January Example for Email", column "F" is "1/1/2012 10:43". So there is one (1) entry to autopopulate into "CT Exam Hourly Matrix" B:12.

Column/Row F:19 & 20 in "January Example for Email" has two (2) entries for that hour to be autopopulated into "CT Exam Hourly Matrix" C:18.

Therefore, the total number of entries for a specific hour will be tallied (sum) and transferred to the second spreadsheet in the appropriate column & row.

Is there a means to automate this process using only Excel or VBA or ??? I apologize for being completely Excel "challenged" and would be most grateful for your assistance. I have no idea what I am doing or how to do it. This is strictly a job related / personal need project to make my daily life sane again.

A:Solved: Excel Vlookup and Counting Entries

Why the duplicate post?

2 more replies

Weird problem I just ran into which I sure is a quick fix. Just today I noticed that when I play a file in Windows Media Player, the file length coutns down rather than up. So if I play a file that is 2:30 in length, it counts from 2:30 to 1 while it's played rather than 1 to 2:30. It's a bit annoying.

What do I need to do to fix this setting?

A:Solved: WMP time file length counting down.

I am using WMP 10. Left clicking on the playing time display near the bottom right of the screen toggles between showing remaining time, elapsed time, or a combination of elapsed and total time.

1 more replies

i have a spreradsheet with a very large amount of rows

All I want to do is to remove duplicate/triplicate email address -

in fact I just want to count the number of unique email address in a column of data

I have tried using an if statement using an OR( A2=A1, A2=A3) on a sorted list to see if duplicate above or below - but that still does not allow me to count the unique entries

I would normally use access and just use no duplicates - but I dont have access on this PC

anyhelp appreciated

A:Solved: counting unique entries in a column

6 more replies