View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] rachitm@gmail.com is offline
external usenet poster
 
Posts: 23
Default last duplicate value

Hi...

How could I find the last duplicate value the following way:


IF this is the data,


A B


1: day1 Jan
2: day1 Feb
3: day1 Mar
4: day2 Apr
5: day2 May
6: day3 June
7: day3 July
8: day5 Aug
9: day5 Sep


How could I display the last value of each type and the respective
column B data (in a textbox):

A B

day1 Mar
day2 May
day3 July
day5 Sep


Thanks!