| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The MAX value of certain type ?
Hi Ayato, =MAX(IF(A1:A7="Y",B1:B7)) Enter above formula as an array formula (with Ctrl + Shif + Enter ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert date type to text type | Excel Discussion (Misc queries) | |||
| Excel will not let me type any characters....I can type in Word. | Excel Discussion (Misc queries) | |||
| Excel will not let me type any characters....I can type in Word. | Excel Discussion (Misc queries) | |||
| how to change all the words of one type(Gunsuh type)to another | Excel Discussion (Misc queries) | |||
| Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) | |||
![Colo[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
