LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 88
Default Reporting the maximum date within rows with the same keydata

"TIMOTHY" wrote in message
Good
What is the exact use of using array in formula.



I wasn't suggesting an array formula here. With a block of cells, typically
in a single row or column, Ctrl+Enter applies the same formula as the
activecell to the entire selection but adapted in each cell for relative
addressing as applicable.

An array formula is applied with Ctrl+Shift+Enter and the formula will be
placed between curly brackets

https://support.office.com/en-us/art...2-ecfd5caa57c7

Peter T


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date reporting in cell Boenerge Excel Worksheet Functions 1 September 12th 07 01:48 PM
How do I view the maximum rows in Excel 2007 (Million Rows)? shanth Excel Discussion (Misc queries) 2 January 15th 07 05:45 PM
Problem with USEDRANGE.ROWS.COUNT reporting one row too many Peter Rooney Excel Programming 9 January 18th 06 03:51 PM
Reporting number of rows on a userform dht Excel Programming 1 June 23rd 04 11:13 AM
Selecting multiple rows from listbox for reporting Brett9[_2_] Excel Programming 3 November 5th 03 11:07 AM


All times are GMT +1. The time now is 02:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"