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 help me?
The answer is simple. You can use the Excel Date functions to do this:
To break down what is happening here, [...]
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 problem where an extract of an asset report only had the “Last user” and “Last software scan date” on the first record for each [...]
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 things I hate about my iPhone”.
But Excel couldn’t find it (see picture right).
The problem was caused by the Excel feature “Find [...]
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 DVD’s for example.
Just like the example pictured here:
(click on the picture to see all of it)
The formula used above is: [...]
Recent Comments