| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DMAX function for Office 2007
I hope I can explain this in words...
I have some excel worksheets, the first worksheet has a table with multiple house listings and their sales price, along with other info. The table also includes the type of dwelling, (ex, condo, ranch style, victorian). In another worksheet, I was trying to use the DMAX function to get me the max sale price for each type of dwelling. When I used the help it showed... Dmax (database, field, criteria) I was putting =DMAX(selecting the worksheet with the data, then selecting the Header for Sales Price, then selecting the worksheet that I am putting this formula in and typing C10 , which says one of the types of dwellings) I tried for hours, different ways of doing this and I could not get anywhere. Can anyone understand what I am asking, and please explain what I am doing wrong? THANK YOU! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200710/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to open Office 2007 files using Office 2002 XP | Excel Discussion (Misc queries) | |||
| can not find the pivot function in office 2007 | Excel Discussion (Misc queries) | |||
| Can not find Pivot function in office 2007 | Excel Worksheet Functions | |||
| Performance not upto Office 2003 standards in Office 2007 | Excel Discussion (Misc queries) | |||
| MSNStockquote function is not working in Office 2007 beta | Excel Worksheet Functions | |||
Threaded Mode
