Microsoft Office Forums - View Single Post - [Solved] Assigning numbers to every group in a set of data

Thread: [Solved] Assigning numbers to every group in a set of data

View Single Post

Old

03-27-2021, 04:29 PM

Marcia

Marcia is offline

Marcia uses Windows 7 32bit

Windows 7 32bit Marcia uses Office 2013

Marcia uses Office 2013

Office 2013

Expert

The original poster

Join Date: May 2018

Location: Philippines

Posts: 527

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Default

Thank you Purfleet.

The MATCH formula must return 1, 2, 3, 4, 5, 6, 7, 8...... It left out numbers 2,3, 6, 17 and 18.

The formula IN THE GroupNameX must populate all the rows with the chosen name for each group by Name3.

Reply With Quote