Tuesday, June 14, 2011

Fundamental Business Principals

  • Buy items that appreciate in value; rent those that depreciate.
  • If its too good to be true, don't.
  • That which is free, costs.
  • A pressured decision will always rupture.
  • Fast. Cheap. Perfect.........Pick two.
  • Never attribute to malice that which can be adequately ascribed to stupidity 
  • You can sheer a sheep many times, but skin him only once.
  • Business: efficiency in cyclical sales

Tuesday, June 07, 2011

Finding Duplicates in Excel

One of my customers wanted to do the same type of summary in an Excel spreadsheet. We were both surprised that there was no function like this in Excel. But after a few Google searches I came up with a workaround that lets an Excel formula do the same thing as the Distinct Count summary function in Crystal:

=SUMPRODUCT((A1:A99<>"")/COUNTIF(A1:A99,A1:A99&""))

You replace the three sample ranges “A1: A99″ with whatever your data range is. I am not sure I could explain why it works, but it does.