Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rossmcl
  • Order by date
  1. rossmcl

    EXCEL: Using Sumif to find Averages...

    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
  2. rossmcl

    EXCEL: Using Sumif to find Averages...

    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...
  3. rossmcl

    Hiding Excel when running a function

    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
  4. rossmcl

    EXCEL: Using Sumif to find Averages...

    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...
  5. rossmcl

    EXCEL: Using Sumif to find Averages...

    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...
  6. rossmcl

    Selecting a random line from a txt file and displaying on my web page.

    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
  7. rossmcl

    Selecting a random line from a txt file and displaying on my web page.

    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...
  8. rossmcl

    Selecting a random line from a txt file and displaying on my web page.

    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...
    • rossmcl
    • Thread
    • Replies: 10
    • Forum: PHP
  9. rossmcl

    Recalcing formulas in a worksheet in Excel

    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...
  10. rossmcl

    Static IPs in PHP

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

    Static IPs in PHP

    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...
    • rossmcl
    • Thread
    • Replies: 4
    • Forum: PHP
  12. rossmcl

    $_SERVER['REQUEST_URI'];

    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
  13. rossmcl

    $_SERVER['REQUEST_URI'];

    Anyone else help me on this?
  14. rossmcl

    $_SERVER['REQUEST_URI'];

    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 . ' ' ...
  15. rossmcl

    $_SERVER['REQUEST_URI'];

    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...
  16. rossmcl

    $_SERVER['REQUEST_URI'];

    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...
  17. rossmcl

    $_SERVER['REQUEST_URI'];

    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
  18. rossmcl

    $_SERVER['REQUEST_URI'];

    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 =...
  19. rossmcl

    $_SERVER['REQUEST_URI'];

    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...
    • rossmcl
    • Thread
    • Replies: 15
    • Forum: PHP
  20. rossmcl

    UK Help needed - phone/pda advice

    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...

Part and Inventory Search

Back
Top