View Single Post
 
Old 10-03-2015, 08:56 AM
balajigade balajigade is offline Windows 8 Office 2010 32bit
Novice
 
Join Date: Oct 2015
Posts: 4
balajigade is on a distinguished road
Default 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 ?
Reply With Quote