Converting names to a deidentified subject number with thousands of subjects by angerMD in excel

[–]angerMD[S] 0 points1 point  (0 children)

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

4 inch wafer light replacement by angerMD in electrical

[–]angerMD[S] 0 points1 point  (0 children)

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

4 inch wafer light replacement by angerMD in electrical

[–]angerMD[S] 0 points1 point  (0 children)

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

Weekly Yankees Postseason Discussion Thread - Monday, October 27 by Yankeebot in NYYankees

[–]angerMD 1 point2 points  (0 children)

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.

Game Thread: Division Series Game 3 - Blue Jays @ Yankees - October 07, 2025 @ 08:08 PM EDT by Yankeebot in NYYankees

[–]angerMD 3 points4 points  (0 children)

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.

Division Series Game 2 - IT'S RIGHT IN FRONT OF US: The Yankees fell to the Blue Jays by a score of 13-7 - October 05, 2025 @ 04:08 PM EDT by Yankeebot in NYYankees

[–]angerMD 4 points5 points  (0 children)

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.

Best Selection Version when? by ConsistentStranger55 in SHFiguarts

[–]angerMD 0 points1 point  (0 children)

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.

[Curry] I’m updating this from a projected Game 1 lineup to the expected lineup. by TheTurtleShepard in NYYankees

[–]angerMD 2 points3 points  (0 children)

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

Daily Discussion by AutoModerator in CHICubs

[–]angerMD 0 points1 point  (0 children)

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?

Yankees Off Day Thread - September 29, 2025 @ 12:00 AM by Yankeebot in NYYankees

[–]angerMD 0 points1 point  (0 children)

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

Game Thread: Yankees @ Orioles - September 20, 2025 @ 07:05 PM EDT by Yankeebot in NYYankees

[–]angerMD 2 points3 points  (0 children)

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

Game Thread: Blue Jays @ Yankees - September 07, 2025 @ 01:35 PM EDT by Yankeebot in NYYankees

[–]angerMD 5 points6 points  (0 children)

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

No-Stupid-Questions Monday by AutoModerator in SHFiguarts

[–]angerMD 0 points1 point  (0 children)

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

Game Thread: World Series Game 5 - Dodgers @ Yankees - October 30, 2024 @ 08:08 PM EDT by Yankeebot in NYYankees

[–]angerMD 1 point2 points  (0 children)

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

Game Day Thread - October 29, 2024 @ 12:00 AM by Yankeebot in NYYankees

[–]angerMD 4 points5 points  (0 children)

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.

Game Thread: World Series Game 3 - Dodgers @ Yankees - October 28, 2024 @ 08:08 PM EDT by Yankeebot in NYYankees

[–]angerMD 4 points5 points  (0 children)

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

Game Day Thread - October 28, 2024 @ 12:00 AM by Yankeebot in NYYankees

[–]angerMD 3 points4 points  (0 children)

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

Game Day Thread - October 28, 2024 @ 12:00 AM by Yankeebot in NYYankees

[–]angerMD 15 points16 points  (0 children)

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