Thread: Find Last Value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
comparini3000 comparini3000 is offline
external usenet poster
 
Posts: 22
Default Find Last Value

I have many entries describing sales events, and one of the columns in every
entry is quarter. I'd like to find where one quarter starts and where one
ends without doing any filtering or deleting.
For example, i have

___K___
1|Q1
2|Q1
3|Q1
4|Q1
5|Q1
6|Q2
7|Q2

I'd like to use a code that, in this example, would return row 5 as the last
Q1 value. Is this possible?
thanks in advance

comparini3000