View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jabbott jabbott is offline
external usenet poster
 
Posts: 3
Default Find a Value the first Time It Occurs

I have a row of values that shows the total cumulative number of sales of
items by month. Occasionally, there may be no sales in a month for an item
so the cumulative value would stay the same for more than one month. I want
to select a number in the row the first time it occurs and not select it if
it repeats.