Not your question?
Ask your question
View similar questions
Check out some similar questions!
Question about Dynamic Range for Pivot Tables - Excel 2007
[ 1 Answers ]
I have tried writing a module that will create a pivot table in a named worksheet with a range of data that changes from day to day. I was able to do with easily in Excel 2003 but when I tried to duplicate that in Excel 2007, it doesn't work. It fails with a Run-time error 5: Invalid procedure...
Get max of date field in a table for a particular month
[ 3 Answers ]
Hi, I have data in a table as follows: Key date 101 4/25/2006 101 4/26/2006 101 4/27/2006 101 4/28/2006 101 5/25/2006
Using fuction "Mode" within a Pivot Table? Or calculating the mode with conditional?
[ 4 Answers ]
I want to know which number appears most frequently within a table by instructor code. For example, I want to produce a report that searches column A for an instructor code (for example, any instructor code "ba*") and then finds the mode of the corresponding cell in column B. I know I could...
Excel - frequency / mode / pivot table.
[ 0 Answers ]
Hi there, I'm struggling to achieve my end goal in Excel; I have a list of dates (presently the list of dates is divided into individual worksheets with 20 rows and 5 columns of dates per worksheet. I have 30-40 worksheets). My objective is to obtain a list of the dates that match...
Question on placed-in-service date
[ 1 Answers ]
Hello, I have a question regarding the placed-in-service date for rental property. I had a room ready as a rental in which the renter moved-in during the same month. Their first rental payment was the beginning of the next month. Therefore, is the placed-in-service date when the room was... View more questions Search
|