vunsev

I don't want to add up the contents of B column. I need to count it only if the names matches for example something like. =COUNTIF(A:A, "Peter") AND (B:B, "3"). I only want it to count it if it matches both condtions. Didn't explain it very well in my previous post.

I have a excel spreadsheet I have a list of names going down in column A and data going down in column B. So basically I need to count the data in B but only if the name in column A is correct.

I have been given a budget for a new CMIS Server at around £1200. Any ideas where I can get a half decent server for that price? 4GB memory would be ideal.

I am looking for a web based printer supplies stock monitoring system. Phew! I would like to create a system where I can see how many of each cartidge I have left. If possible I would like it to display levels of stock, and when one is brought from our stock it would automaticaly send an invoice via email to the department who have logged in. Any ideas or thoughts?

Espresso is far too expensive for us this year so any alternatives out there?

I'm buying a new home computer. Any thoughts? Intel Core 2 Quad (Q9300) Processor FSB1333MHZ £181.04 Asus P5K Premium/WiFi-AP Motherboard £106.42 Corsair Dominator 4GB Memory Kit 1066 DDR2 £84.21 CCL Value GeForce 8800GT 512MB £114.16 2 x 500GB Western Digital Caviar SE16 WD5000KS £129.23 OCZ 700 Watt Game X Stream PSU £75.21 2 x Samsung SH-S203 SATA Dual Layer DVD Writer £31.56 Creative X-Fi Xtreme Audio OEM 7.1 Channels £26.84

Has anybody used this software before? We are a Primary looking into this.

We have previously (before I was employed here) been using Chart-It software for Year 1 pupils to create charts. Unfortunatley due to this software being created in 1994 and no support offered anymore and not being able to use it in the new XP suite. I don't see how it was ever used before to be frank. I need an alternative. Freeware would be ideal. Any ideas?

Yes that worked, thanks very much.

Sorry, I am very new to programming how would I do the things you have said. Can you rewrite the code for me please?

This is my current code, how can I change the range to E9,E10 and onward to continue the code until the range cell is empty. Dim Cellname As String Dim rng As Range Set rng = Sheets("CPD").Range("E8") Cellname = rng.Text MkDir "C:\Documents and Settings\administrator.BILLESLEY1\Desktop\CPD\" & Cellname Any help would be greatful.

I have a problem with Rnager Primary. I have installed it in an ICT suite with 30 client machines and 1 teacher station. Around 24 of the client machines can be "seen" by the teacher station but the remaining 6 can not. I have reinstalled on the teacher station with version 9.01 (I think). But the same thing happens. Interestingly enough, I installed the tutor software on a seperate machine and it could see the remaining 6 client machines that the teacher station can not "see". So I am almost happt to say it has nothing to do with client machines but it is the teacher station not "seeing" the remaining 6. Any ideas?

Yeah that's what I thought might be the solution, the only problem is its my core switch controlling the entire network!

I have been telnetting my HP 6108 Procurve Switch to install a firmware update. I attempt to telnet again and I get the error message "Sorry, the maximum number of telnet sessions are active. Try again later." Any ideas?

I conected a dull modem(serial to serial cable) to a computer and hyper terminaled to the switch.

Has anybody have a working moodle at a primary school, I have been asked to evaluate possible VLE's for a primary school. Any thoughts on Moodle, or any others for primarys?

I previously had Mind Manager 2002 on my network. Unfortunately I do not have the installation media. Does anybody have any idea where to get this software? I have tried mindjet but they seem to be useless after countless emails and phonecalls.

Hi, I need to find out the ip address of my hp6108 core switch in order to log onto the console and check the event log. Any ideas?