View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default How to create a sequence based on another column values?

Hi,

Am Sun, 30 Nov 2014 09:25:56 +0000 schrieb obarahmeh:

What I need exactly: I need the sequence to start from 20 then added by
20 whenever the value in column A still the same --- 20, 40, 60, ....
But if the value in column A is changed then the sequence should start
from the beginning again (20,40,..).


please post an example how such a sequence should look like


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional