Insert value into column L if...

S

sal21

If is possible with a macro...
My problem, i have this sheet with many value into column A (all valu
are already oredered) is possible to insert into column L the coun
numebr of value repeated from a equal range block?
Example:
into line 3 and 4 is present the same value 4500450961 well inert int
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 iner
into column L the numer 3 into L11, blank the other line refered line 1
and 13

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

Tks

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

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

Iinsert value into column L ... 2
Compare aumont and insert "Balanced"... 0
Insert two lines each time a value in Column L changes 4
list date in the form and vlookup 0
tranfering value if... 3
compare celles and put value into Q 0
Insert Blank Row Based on Value in Column A 1
Define Certain Exact Range 2

Top