We needed a First-name & Initial list.
DaleFor a group attendance list. For Privacy reasons we can’t list of the attendees full-name, but their first name and last name initial was considered private enough. The Excel function…
The joys of DLL hooks and eTrust Antivirus.
This is a guest post by Allan, a bloke I work with. Allan asked my opinion of what was wrong, and I suggested a DNS server issue. (Our DNS servers…
One way to anonymise live data for test use
Take your table/spreadsheet with your live data and sort ONLY the field holding the surname into A –> Z order sort ONLY the field holding the first name into Z…
Excel: how do I calculate the date 24 weeks from today?
The question was: Need to create series with dates in intervals of 6 weeks 24 weeks and 52 weeks. want it to be set to do it automatically. Can anyone…
“VBA? You wrote VBA code for that?”
exclaimed a colleague. “Is that like Visual Basic?” Well kind of, VBA is Visual Basic for Applications. Which is a scripting language for the Microsoft Office system. I’d had a…
Microsoft Office Excel cannot find the data you’re searching for.
I’m doing some analysis of Help Desk data, and I often use Excel for this task. Now I know a helpdesk caller did log a problem with the subject “five…
How to use VLOOKUP on Microsoft Excel
VLookup allows you to check to see if cell A exists in a range of cells. This might be useful if you want to compare two lists of names, or…