The topmost picture in the 11:52 post is what I was intending, well they both work..You made my year!.. The countif function is what I found in a reference when I revisited the task, as a 'requirement' for it to filter the column..



Apologies for not getting back on yesterday.. Got 2 hrs in and at it again..

It doesn't have to differentiate between the status format or in my case lack of.. It is intended to just return a unique id result [D] based on [B] and [C]. So one Available ID is shown for the returned category and the next result; though it is same category returns the next available ID..

Thank You for the help, I still can't get it to show a result though the builder says there is one. stepped away from it clear the brain to muddle with vb objects.. there is a program that it is needed to export to.. probably the reason the workbook became a lil jenky.. someone didn't know that saving a wb as csv was a no no at some point without saving prior.. I'll add something that will do it blind without a lot of fuss.

Ironically I was grumbling about it went back in tues and the super'v laughed and said "I asked ya to make that sometime in '04 long before ya came on board".. my reply was well I'm going to Tech and finding out why we aren't using sql for all this hooey...

Attached Files

sample_sheet.xlsx (12.3 KB, 8 views)