Find a Value the first Time It Occurs

J

jabbott

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.
 
L

Luke M

What are you wanting to do with the info?

To return position (column number) of number 1234 within row 2:
=MATCH(1234,2:2,0)

A formula that signals it's the first occurence:
=COUNTIF($A2:A2,A2)=1

This could be used in a helper row, or as a conditional format formula.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating percentage growth rate from a cumulative figure 4
Macro to select and delete levels of a document 2
Creating a Search using a combo box and then creating a report. 4
Autonumber field in Excel that behaves the same as Access 0
Duplicate Mail Merge Record Every Time 5
Finding the proper style field and the numbered paragraph value within the style 0
Drop down list control value in vba 2
Sumproduct but only first time corresponding value is seen e.g. un 1

Top