Thread: How to label a row within a grouping
View Single Post
 
Old 11-05-2018, 12:03 PM
wheddingsjr wheddingsjr is offline Windows 7 64bit Office 2016
Advanced Beginner
  
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default How to label a row within a grouping
Hi all

I am working on a spreadsheet with 25k+ lines and need to identify whether a grouping has a certain "type" within the group (see attached). What I would like to do is go through the list and in column 'C' designate whether or not the type ' APP G' is in the group. If it isall the other lines within the group should have the letter 'Y' and if it doesnt the letter 'N'. Any assistance would be greatly appreciated.

Thanks
Attached Files
File Type: xlsx Book2.xlsx (16.9 KB, 15 views)
Reply With Quote