Assigning numbers to every group in a set of data

		Microsoft Office Forums > Microsoft Excel > Excel
Assigning numbers to every group in a set of data

03-29-2021, 01:41 PM

p45cal

Windows 10 Assigning numbers to every group in a set of data

Office 2019

Expert

Join Date: Apr 2014

Posts: 963

You have the UNIQUE function available? In cell E2:
=MATCH([@Name2],UNIQUE([Name2]),0)
copied down.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assigning shortcut to Original mode in Tracking group	Editor	Word	3	05-26-2019 07:12 AM
Assigning the Legend to Data Columns	jelkin1	Excel	1	12-10-2015 06:12 AM
Linking/Assigning Excel data 2 shapes (Timeline functionality)	mediaset23	Visio	0	07-31-2015 04:18 AM
Trying to autofilter 8-10 rows of numbers to sort in a group	Jack-P-Winner	Excel	0	11-25-2013 10:55 PM
Assigning a single task to a team or group	djcozens	Project	1	07-09-2012 05:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:04 PM.