MECTILE

Category: Random

  • In Excel, find the value on the last row as a function, not VBA

    Here is a quick post, how to find the value of the last cell in a column. Exaample below uses Column A with the first 3 rows used for the header: =INDEX(A:A,COUNT(A:A)+3)

  • Huge Pine USB to Serial Ports Driver

    Looking for the Huge Pine USB to Serial Ports driver? Setup_For_HugePine.exe Install, then connect your USB device and chose to automatically search for driver.

  • Altrex Light Skinz – the worst product

    I would like to share my experience with Altrex Light Skinz, a product when applied will allegedly protect a car’s headlights from rocks and stones. As I planned to drive from Perth to Melbourne, I was after some headlight protection for the Hyundai Tucson. I purchased Altrex Light Skinz due to their claim of providing…

  • Fake/Counterfeit Canon NB-4L batteries

    I thought I would share my experience regarding fake Canon NB-4L batteries. Let me start by saying I own a Canon IXUS 55, with the girlfriend owning a Canon IXUS 40 both using the Canon NB-4L Battery. I have purchased two spare batteries from eBay, with one of the purchased batteries looking to be fake.…

  • SigmaTel High Definition Audio Codec driver for Windows XP

    Looking for the following Windows XP driver; SigmaTel High Definition Audio Codec? This driver goes by the following Vendor ID 8384, Device ID 7661 (ven_8384&dev_7661), used in the Sony Vaio laptop series, particularly the VGN-FE30B. This driver will also fix the following driver problem Device Cannot Start (Code 10). SigmaTel Audio Driver v5.10.5067.0

  • IMDB Top 250 movies extended, past and present v2.0

    I have further updated my Top 250 list with a lot of cool features. The main improvement is daily updating of ratings and votes, and the automatic insertion of any new movies that enter the top 250. http://imdbtop250.t.com/ A brief explanation on headings: Rank – the rank of the movie sorted by weighted and then…

  • 5 Dimension – a 5 suit playing cards

    I recently purchased a 5 Dimension (5D) deck of playing cards from Canada for $5 (plus $5 shipping to Australia). Unlike a normal deck, the 5D deck has an extra suit, the star, plus a numeric 1 card (as opposed to an ace), a princess card and jokers, totalling 80 playing cards. The cards are…

  • IMDb Top 250 movies extended: all past and present movies

    I like the IMDb Top 250 list as it lets me know about movies I would normally never hear about. The problem though, is that a lot of the movies get pushed off the list by newer movies, and unfortunately you may never get to hear about them again. Hence, I present the IMDb Top…

  • Unlock the Nokia 6300 for under $10 with the iSIM

    Here’s a quick post on a tested method to unlock a Nokia 6300. Well, not quite unlock a Nokia 6300 but trick the phone into thinking your SIM is of compatible carrier. I purchased the iSIM from eBay for $10 including shipping to Australia. When searching on eBay, search for “unlock 6300” and arrange by…

  • Database query in SQL to select first unique record

    Here’s a quick code snippet to create a query that selects all unique records from field1, and selects the first corresponding record in field2 The function First, can be substituted for Last, Min, Max, depending on desired returned record. In the example above, table1 is the recordset, field1 is the field which you want unique…