Thread: [Solved] Assigning numbers to every group in a set of data
View Single Post
 
Old 03-27-2021, 08:45 AM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
Match kind of works for the name code as it will return the first match

=MATCH([@Name2],[Name2],0)

And for the name try

=IF([@Name3]<>"N","",INDEX([Name],MATCH([@Name3]&[@GroupName],[Name3]&[GroupName],0)))

Added extra columns to sheet tNames (2)
Attached Files
File Type: xlsx NameCoding_Purfleet.xlsx (36.5 KB, 8 views)
Reply With Quote