LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 385
Default Newest month formula

I have a sheet with all 12 months and then I have a column next to the total
column that displays the data from the newest month.

Ex.

May Jun | | Total
1 1 1 2
1 2 2 3

The column that displays June's data again basically makes it easier for me
to look at and manipulate later.

Is there a way to automatically have that column update if I add data in a
July column?
 
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
Automatically use the newest number input in the formulas JessieB Excel Discussion (Misc queries) 1 January 11th 08 07:38 PM
Trying to get a Boolean formula to work month-to-month mstieler Excel Discussion (Misc queries) 4 July 18th 07 10:12 PM
Finding the oldest & newest dates Bob Smith Excel Worksheet Functions 3 April 13th 07 02:27 PM
Special sort for oldest and newest date DTTODGG Excel Discussion (Misc queries) 1 October 11th 06 05:17 PM
Function or formula to convert "text" month to number of month Steve Vincent Excel Discussion (Misc queries) 1 February 4th 06 04:19 PM


All times are GMT +1. The time now is 11:01 AM.

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"