We needed a First-name & Initial list.
For 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…
For 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…
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…
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…
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…
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…
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…
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…