What, you don’t understand random?
New Site For Your Geeky Needs
Well it's happened, I've joined up with my fellow Team Hack-A-day members to collaborate on a new project.  I'm officially presenting to you, ahead of schedule, a site that is for geeks, by geeks.   What I truly mean to say is that we are going to be like your geeky co-worker, bringing stuff to you that we think you'll find interesting.  Whether it be info about making beer, what games to play...
Review – Motorola X205 Xbox 360 Headset
I made a recent Woot.com purchase of this headset simply for the fact that it was a Xbox 360  accessory and it was very, very inexpensive.  It was so cheap, at a price of $3.99, that I felt the need to buy two just to justify the $5.00 shipping.  I don't think I even stopped to really read the description or even the picture. I eventually received both headsets, or this article obviously wou...
LOTRO Goes Free
Coming very quickly, as in this fall, The Lord Of The Rings Online will be turning into a free to play game. “Warner Bros. Interactive Entertainment is bringing quality games based on The Lord of the Rings to multiple platforms, and the franchise’s expansive adventure story lends itself perfectly for LOTRO free-to-play, giving a wide range of players the opportunity to experience the game...
R.I.P. PS3 LINUX
Dearly Departed, We are gathered here today to mourn the loss of our dear friend PS3 Linux. It is always a tragedy when somebody so young is taken from us. Some of you barely even knew PS3 Linux, such it was that time was lost between you. We know not what the future would have held, what impacts PS3 Linux might have had in our lives. One thing is certain, we have lost something preciou...
Nyko Apologized To Me
Just last week I got a little angry that Nyko Lied To Me since they goofed up when I asked them about a pre-order item from BestBuy.com. Last night I received a direct Twitter message from them stating: "We have seen your blog post and would like to apologize for the confusion. We were going by BestBuy.com's description and NOT the SKU number. We should have checked the SKU number, and for ...

My Crazy Excel Formula

Posted By: Snorkle256 on July 6, 2009 in Computers, Hack - Comments: No Comments »

This formula is designed to extract asset numbers from monitors (a) and computer numbers (b) after the help desk program dumps summary fields.  First is goes through and looks for the monitors and if it doesn’t find any the error function runs the search for computers.  The trick is that not only numbers are returned but words as well so after you put the formula in you have to do replaceall to change the words to nothing.

=IF(ISERROR(MID(D1,SEARCH(“a?????**”, D1),8)),(MID(D1,SEARCH(“b?????**”, D1),8)),(MID(D1,SEARCH(“a?????**”, D1),8)))

Log In

Advert

Categories

Advert