Just had a thought while away from the computer; are you looking for the formula to give you both columns, as in the likes of for Status S:


2022-07-12_205028.png
and for Status A:
2022-07-12_205048.png?

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)

I'm not seeing a result in the 'builder':
2022-07-13_124614.png
It's also complaining of a circular reference.


OK, the file has slightly different data in it, so asking msg#11 again:
Is this what you want to see for A?:
2022-07-13_124857A.png
and this for S?:
2022-07-13_124828S.png


Edit post posting. I see you answered msg#11 while I was responding. So you might find that useful.

Could you post a file with you having filled in manually the results you expect to see?

Hmmmm that might actually be useful.. right now all I added was a count for status' that aren't A/vailable.. Your going to get me in a rabbit hole with this lol. Back in the day when did this I would wrap one thing up and like you realize a new function. Back then I did a lot of freebie work for friends of friends and whoever hoping to land a backend tech position..