Thanks dangelor, however what i am asking for is a bit more complex. Say for example with the recency of sales. I want excel to search 12 columns (each a month of the year and check for data in each. Then I want it to generate a number ranking based on the sales recency. So if the sale was in the previous three columns, assign a 3. In the previous 6, (as in 6 months), but not in the last 3, then assign a 2. And if they have had a sale in the previous 12, but not in the previous 3 then assign a 1. That way I can group all of the 1s together and so on. So I can segment my lead lists.

Can anyone help me with data this specific?