Sequencing duplicates
I have a table something like this :
mon a b c e
tue b a f a
wed b d a d
thu a c b f
fri d b c a
sat c b c e
I want a sequential counting of appearance of the values a,b,c,d & e in the second table in following pattern :
mon a-1 b-1 c-1 e-1
tue b-2 a-2 f-1 a-3
wed b-3 d-1 a-4 d-2
thu
fri
sat
--and so on---
How I manage this ?
|