Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-03-2015, 08:56 AM
balajigade balajigade is offline Sequencing duplicates Windows 8 Sequencing duplicates Office 2010 32bit
Novice
Sequencing duplicates
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sequencing duplicates VBA: Delete duplicates in each row bandaanders Excel Programming 2 09-02-2015 08:15 AM
Sequencing duplicates Removing duplicates saurabhlotankar Excel Programming 14 05-26-2015 10:13 AM
Conditional Formatting Duplicates Joanne Excel 6 08-05-2013 02:46 AM
Mail duplicates mixy Outlook 0 02-10-2011 12:54 AM
Sequencing duplicates sum of duplicates zxmax Excel 1 09-29-2006 08:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft