New to pivot tables, trying to add as a final column, the total of preceding
colums, on a row-by-row basis. Can't get my head round what the source data
- Dec 25 Tue 2007 20:41
Calculated field in Pivot Tables
- Dec 25 Tue 2007 20:41
=IF((TODAY()-B8)gt;30, quot;Overduequot;, quot;Currentquot;),
I have used this formula to set up an invoice tracker.. My question is how
do I make the formula know when an invoice has been paid.
- Dec 25 Tue 2007 20:41
IS IT POSSIBLE?
to copy one excel file to other even when is updated the other file will be
automatically updated too?
- Dec 25 Tue 2007 20:41
Filtering out weekday dead time
I am using NETWORKDAYS function to determine the number of weekdays between
two dates e.g 01/03/06 to 31/03/06 =networkdays(A6,B6) gives the result 23.
- Dec 25 Tue 2007 20:41
Order of drop down list
I have created a drop down list for validation by naming a list of data in a
pivot table. For some reason, when you click on the drop down list it does
- Dec 25 Tue 2007 20:41
Is there a forumula that uses colors instead of cell #'s?
I am creating a worksheet where different items are highlighted several
different colors. Is there a way to create a formula that changes when I
- Dec 25 Tue 2007 20:41
error analysis
- Dec 25 Tue 2007 20:41
Nested if problem
- Dec 25 Tue 2007 20:41
how do i get the equal sign on my formula bar in excel
I do not seem to have the equal sign on my formula bar. how do i receive this?
- Dec 25 Tue 2007 20:41
undo a saved change
help!!!!!!!!!! I have saved a change on a excel spreadsheet that I sould not
of done! Can I get back my old one????