Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with macros
Can someone help me with this problem? The task is something like
this. In one row we have some codes, like a,a,a, b, c, c, d, e, e, e. In another row I have to mark them so that every code that is unique has number 1 next to it, and the one that is repeating must have numbers from 1 to something, depends on the number of repeatings. So in my case it would look lik this. 1st row 2nd row a 1 a 2 a 3 b 1 c 1 c 2 d 1 e 1 e 2 e 3 Can please someone make me a macro for this? Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with macros
you dont need a macro in fact...
here is the situation: header(A1) counter(B1) a =IF(A2<A1;1;1+B1) a copy formula seen above etc |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with macros
On 12 pro, 09:56, "Snake Plissken"
wrote: you dont need a macro in fact... here is the situation: header(A1) counter(B1) a =IF(A2<A1;1;1+B1) a copy formula seen above etc It works! Thank you! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with macros
B1: =COUNTIF(A:A,A1)
and copy down -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Snake Plissken" wrote in message ... you dont need a macro in fact... here is the situation: header(A1) counter(B1) a =IF(A2<A1;1;1+B1) a copy formula seen above etc |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with macros
no problem - of course data stored in first column has to be sorted with
ascendindg or descending mode before copying the formula, and everything can be done by macro, however task is simple so we can "avoid" a macro ;) |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with macros
A slight modification to your formula in order to produce the numbers the OP
asked for originally... B1: =COUNTIF($A$1:A1,A1) ...and copy down Rick "Bob Phillips" wrote in message ... B1: =COUNTIF(A:A,A1) and copy down -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Snake Plissken" wrote in message ... you dont need a macro in fact... here is the situation: header(A1) counter(B1) a =IF(A2<A1;1;1+B1) a copy formula seen above etc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Macros | Excel Discussion (Misc queries) | |||
Macros Problem | Excel Discussion (Misc queries) | |||
Problem with Macros! | Excel Programming | |||
Macros problem with XP | Excel Programming | |||
Problem with macros on Mac | Excel Programming |