All Questions
64
questions
0
votes
1
answer
382
views
Comparing two Excel Work sheets for re-used/non existing names
I have two excel worksheets that I need to find names that do not appear on one to the other. They are both very similar, however because of the added names a quick If true/false function will not ...
2
votes
3
answers
489
views
Getting the value in one column from a formula on another column in excel
I have an excel table that looks like this:
Date Original Actual
11/10/10 15 12
12/10/10 12 10
...
24/10/10 2 1
25/10/10 -2 ...
5
votes
4
answers
6k
views
Excel annoyance: How to maintain formulas in a ledger?
A common use of Excel is to create a spreadsheet which functions as a transaction ledger of some kind, where one or more fields in each row is calculated by adding a value or values from the current ...
5
votes
2
answers
4k
views
How can I create a reusable function in Excel 2007?
How can I create a resuable function/formula I can use in formulas in a spreadsheet? In particular I need a very simple DateDiff formula and would like a way to encapsulate this function:
=(((HOUR(...