View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ananth Ananth is offline
external usenet poster
 
Posts: 51
Default Start Date and End Date

Can help me to find out the cell ref that shows value last


A B C D E F E G H
1 Des Jan Feb Mar Apr May Jun Start End
2 Project-1 0 1 2 1 0 0
3 Project-2 1 1 1 1 1 1
4 Project-3 0 0 0 0 1 1

I want to see in Col G & H results as under :

Start Dt End Dt
Project-1 Feb Apr
Project-2 Jan Jun
Project-3 May Jun

Any help will be greatly appreciated