View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sal21[_71_] sal21[_71_] is offline
external usenet poster
 
Posts: 1
Default Iinsert value into column L ...


If is possible with a mcro...

my problem, i have this sheet with many value into column A (all value
are already oredered) is possible to insert into column L the count
numebr of value repeated from a equal range block?
Example:
into line 3 and 4 is present the same value 4500450961 well inert into
column L the numer 2 into L3, blank the other line refered line 4

into line 11, 12 and 13 is present the same value 4500451080 well inert
into column L the numer 3 into L11, blank the other line refered line 12
and 13

if the value into acolumn A is present only one insert into column L
the value "0"

Tks.


+-------------------------------------------------------------------+
|Filename: ADD_NUMBER.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3786 |
+-------------------------------------------------------------------+

--
sal21


------------------------------------------------------------------------
sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040
View this thread: http://www.excelforum.com/showthread...hreadid=465484