Search results for query: *

But with average it uses all the cells you give it. I want it to get a result by telling it to average on a range of cells, and only when it is a particular value (ie A or B). I think Average is a bit simplistic for what I am trying to do? rossmcl

Hi Geoff, your formula suggestion didnt work for me. Let me explain exactly what I am trying to do, as I may have not been clear. For example, this is the data I have. Some A's, soem B's etc. A 6 A A 6 B 1 B BA 5 A 4 A A 3 B 3 For the above dataset, I want the averages to be...

How do you stop it being visible on the screen when an Excel function is running? At the moment, I have a function doing a lot of cell offsets and worksheet creates etc. I want to stop all this being visible on the screen. (ie I dont want the cursor to move etc). Is this possible? thanks rossmcl

Thanks all. xlbo: Hi Thanks for you suggestion, this works (kind of). The Sumif part works perfectly, but the COUNTIF part is not doing exactly what I need it to do. Basically the COUNTIF is including ALL rows with the Team, and I only want it to average the rows where a number or 0 is...

Hello I have two columns in Excel. Column A contains Football Clubs, Column B contains Goals Scored (there is a diferent row per week) I want to create an summary for each football club, of the average number of goals they scored in the season. Do I use Sumif (or another function) to find...

Do I have to put the <script src="http://www.yourwebsite.com/function.php"></script> into the header part of html? Or do I just place it where I want it to run? And how do I pull out the variable that is in the php file? (sorry, I am a real novice to php) Thanks rm

Thanks spookie, that worked a treat. Next question (I am a real beginner!) - how do I embed that php into an html file. (I cannot change my index.html to index.php, as it is already in use, and linked from a lot of other peoples sites.) I need to call that .php file that has the above script...

Hello I have a text file with 100 lines of text. I want to use a function in php to randomly select one of these lines of text every time my website is loaded, and display it on my website. Is this possible with php? If so, how do I go about doing it? (Sorry if this is a simple question, my...

Hi I have a spreadsheet with a few VBA-driven formulas. When I manually recalculate the cells with the forumulas in them (by placing my cursor at the end of the formula and hitting Return, it all works fine. But when I add a button to the worksheet, and try to recalculate that way, I cannot...

Thanks for the ultra-fast reponses. One question - how do you add cookies? (sorry, I am not an PHP or internet programmer) Rossmcl

Hi, I use the following code to store the IP address of a visitor to my site. It worked perfectly...until I recently changed ISP. This new ISP doesnt give me a static IP address. So I am wondering, does anyone know of a cunning way in PHP so that when I enter my website, it doesnt store my IP...

Okay, I can accept this. What I cannot accept is why http://www.foolfillment.co.uk/refer/index.php gets it working every time, using the code from this site: http://www.textism.com/tools/refer/ Hmmm. What is he doing??? Thanks RM

Anyone else help me on this?

Here it is: <?php $filename = "VisitorsDetailsBlog.txt"; $handle = fopen ($filename, "a+"); $todaydate = date("Y-m-d H:i:s"); $visitorInfo = $HTTP_SERVER_VARS['REMOTE_ADDR']; $url = $_SERVER['REQUEST_URI']; $test = $_SERVER['HTTP_REFERER']; fwrite($handle, "\r\n" . $todaydate . ' ' ...

I am clicking links both ways. When I click on a link GOING TO his site, it shows up on his log file. When I click on a link from his (or many other) sites COMING TO my site, diddly squat appears on my site. Really frustrating, I put it down to 'HTTP_REFERER' being useless, but having now...

I just cannot believe that it seems to pick up a lot of URLs on his website, but it doesnt pick up ANY on mine. Anyway, I made a couple of typos on my code which are now fixed. The thing is, on his site, my website comes up when I go to his site from mine, but it doesnt come up when I go from...

So how is this website getting the information?!? http://www.foolfillment.co.uk/refer/index.php It comes from this site: http://www.textism.com/tools/refer/ but I cant work out what they use to get the URL Any help very much appreciated RM

I have tried this before and it always comes up blank. Any ideas? Here is my code. ==== <?php $filename = "VisitorsDetailsBlog.txt"; $handle = fopen ($filename, "a+"); $todaydate = date("Y-m-d H:i:s"); $visitorInfo = $HTTP_SERVER_VARS['REMOTE_ADDR']; $url = $_SERVER['REQUEST_URI']; $test =...

Any help much appreciated here. I am trying to store visitor details of people that visit that use my website. I do it to a text file as my domain provide doesnt provide MySQL (actually they do, but it is blooming expensive for my hobbyist needs.) What I am trying to do is add the URL of the...

Hi, I am in the United Kingdom, and wanting to buy a phone/pda. My main requirements are 1. to be able to download my yahoo email into the outlook on the PDA 2. ideally be able to listen to MP3's 3. have some sort of word or notepad functionality 4. preferably handwriting recognition / stylus...