Sunday, January 18, 2009

Circuit City Begins Liquidation

Yesterday I happened to be shopping next door to a Circuit City and when I came out at around 9:45, I saw a line. I guess people wanted to see what sort of sales there would be on the first day of Circuit City's liquidation. I didn't think that they'd have any drastic reductions yet, since they are planning to complete liquadation somewhere in March, but who can resist standing in a line?!

Even though nearly every item had a special sticker on it, the "sale" prices were still a bit too high for me - still well above what I could get the stuff on Amazon for. For some reason, Circuit City only had one cash register open, and there didn't seem to be more than 4-5 members of staff on the floor, even though there had to have been 100-125 people standing in that line with me, and lots more people streaming in after that. Meh.

Thursday, January 08, 2009

Finding Duplicates in Excel

Here's an easy way to find duplicate entries in excel using excel's OR function. This method is pretty much obsolete in Excel 2007 and above since it has a built-in duplicate finder/eraser, but for earlier versions, such as Excel 2003, this is still a useful trick.

Let's say you have a list of customer numbers and names and need to find duplicated entries. This sample list is unrealistically short, so imagine a list like this with hundreds of entries.



Using excel's OR function, we can check to see if the entry above or below a particular row contains the same number. To facilitate the calculation, create a new column in front of the data you wish to check.




Then enter the calculation into cell A2: =OR(B2=B1, B2=B3)

The logic behind this calculation will return a TRUE response if EITHER of the conditions are met. It looks to see if either the cell above (B1) or below (B3) cell B2 is a duplicate. Copy this formula down.


Remember that in order for this formula to work, the list of customer numbers will need to be sorted first, so that duplicate entries show up adjacent to each other. You can apply an auto-filter or just data/sort the list.


In this case, sort by customer number.


After the list is sorted, column A will show TRUE for the entries which are duplicated. To group the TRUE entries and find them more easily, you can further sort the list by column A, or apply an auto-filter to the sheet, or you can apply conditional formatting to column A to highlight TRUE entries in color.



bobbypd. Get yours at bighugelabs.com/flickr