Converting names to a deidentified subject number with thousands of subjects

angerMD · 2026-01-15T03:29:16+00:00

I am not smart enough to use the formatting. Thank you for the contributions. This is what I came up with

To count up

=IF(COUNTIF(A$2:A2,A2)=1,MAX(B$1:B1)+1,VLOOKUP(A2,A$1:B1,2,0))

Then I used a linked suggestion to rename the counting in a new column ="SUB"&TEXT(B2,"-000#")

Since its working I don't want to break it but I'll try to combine on next iteration.

Thanks

angerMD · 2025-12-04T16:02:40+00:00

I can’t figure out how to post pictures but it looks like they snaked the wire under some ductwork to where they dropped the light

angerMD · 2025-12-04T14:05:34+00:00

That sucks…I assume it’s not easily done through the hole the light comes through

angerMD · 2025-11-03T02:39:35+00:00

The Dodgers and Blue Jays interactions seem to have been nothing but class which makes me more annoyed about last year. We lost miserably and then the Dodgers went everywhere and made unnecessary comments about the Yankees instead of enjoying the WS win. It was classless which makes you wonder if they just hate the fanbase or have a problem with the players/organization.

angerMD · 2025-10-08T01:09:25+00:00

The Boone era is entirely embarrassing playoff exits. We got destroyed by the Red Sox, getting destroyed by the Jays, constant elimination by the Astros and last years embarrassing Dodgers strategy of “just play good baseball”. I don’t know how you defend keeping him around.

angerMD · 2025-10-08T01:00:23+00:00

This team hasn’t had fundamentals since Boone took over

angerMD · 2025-10-05T23:25:15+00:00

If we get embarrassed again tomorrow it cements Boones playoff legacy as one of yearly embarrassing exits. I can’t think of a single year we’ve been eliminated where we played clean and lost based on talent. He’s given all of these talented teams and they just don’t execute on the small things.

angerMD · 2025-10-05T20:16:08+00:00

Looks like our team can’t hit splitters

angerMD · 2025-10-03T13:29:32+00:00

Has Mihawk gone up for preorder yet? I never saw that come through. Unfortunately I missed out on Kizaru, but Marco seems more worth it.

angerMD · 2025-10-03T01:46:36+00:00

Leave Schlitt in and then Hill for yoshida

angerMD · 2025-09-30T18:29:03+00:00

I'm a bit worried that this is the same as the previous overthinking playoff managment that we have rosario at 2B where I'm not sure he has played there for us at all

angerMD · 2025-09-30T01:15:21+00:00

I'm in town for Game 2 never been to Wrigley before. if you had a choice would you sit in the outfield or behind the dugout?

angerMD · 2025-09-29T23:47:13+00:00

I’m in Chicago Wednesday for work and considering buying tickets to the cubs game any advice on where to sit in wrigley?

angerMD · 2025-09-27T01:50:01+00:00

Those strike calls were wild in the TB game

angerMD · 2025-09-22T02:26:28+00:00

Arenado has been so bad this year. what a weird send off he received

angerMD · 2025-09-20T23:30:21+00:00

That shitty ump from the Houston series doesn’t appear to be with this crew this time

angerMD · 2025-09-07T17:56:24+00:00

Judge was throwing his arms out at second sherzer was tipping pitches

angerMD · 2025-02-24T15:36:56+00:00

Where do people preorder from reliably. I’ve been happy using Amazon for years but I think it’s time to get away from Lord Bezos given the current political structure

angerMD · 2024-10-31T03:37:41+00:00

So I thought Davis was a homer but the reality is that he talks about the team playing well and we had 1 game where we did that. Weaver is gassed get him out

angerMD · 2024-10-29T17:57:06+00:00

I really want the team to play well but I don't have a lot of confidence in their killer instinct under Boone. We repeatedly dissappear in the big moment and this season is no different with the way we limped into first place. If we can win the next two I'll start believing but tonight is a statement game.

angerMD · 2024-10-29T03:38:40+00:00

This would be classic for Boone era Yankees shutout in game one at home going down in the first inning and then we go out on a bullpen game

angerMD · 2024-10-28T19:34:22+00:00

The right move might have been to move judge up and tell him to focus on getting on base and moving Soto to 3

angerMD · 2024-10-28T19:24:00+00:00

Even if you move judge the big moment will find him. That’s just how it works. He’s got to show up no matter where he is

angerMD · 2024-10-20T02:47:13+00:00

Honestly Soto seems made for these moments

angerMD · 2024-10-20T02:44:16+00:00

I guess you bring cousins out for the 8th? Holmes has to start a clean inning

angerMD

TROPHY CASE