I have a pretty simple spreadsheet where I have a key in one worksheet with employee initials and another worksheet with all employee system login times. The initials are my lookup on the login time worksheet.
I am trying to create a formula in the first worksheet that will look for the employee's initials in the second worksheet and return the earliest login time
When Sheet1!A2 = Sheet2!H:H
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.”
David Miller (dlmille)
It was one of those days…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.