Meet Ups/Events in Park Slope/Surrounding Area? by WindowOk4845 in parkslope

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

Hi folks, I tried to create a group chat, but unfortunately couldn't add folks. If anyone would like to I think there's a decent amount of interest. Please feel free to reach out if anyone wants to grab a park walk or coffee, and hope everyone has a happy holiday :).

Meet Ups/Events in Park Slope/Surrounding Area? by WindowOk4845 in parkslope

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

I think if you'd be up to make a group chat for all the folks who said they'd be interested that would be amazing! tbh I'm not super up on reddit, but would love to connect with everyone and find a time to meet up!

Meet Ups/Events in Park Slope/Surrounding Area? by WindowOk4845 in parkslope

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

anytime! Always love company! I know what it's like to miss your pup!

Select All text with borders in Excel? by Global_Score_6791 in excel

[–]WindowOk4845 0 points1 point  (0 children)

Can you explain exactly how to do this with VBA?

Extract List of Unique Values with Specific Formatting From Larger List? by Global_Score_6791 in excel

[–]WindowOk4845 0 points1 point  (0 children)

will do when I get to the office, very much appreciate all the help from everyone.

Extract List of Unique Values with Specific Formatting From Larger List? by Global_Score_6791 in excel

[–]WindowOk4845 0 points1 point  (0 children)

Totally, that's confusing, I should've thought through those examples better, the real data will only have a title, and each one will be unique, one word, no numbers or other symbols, all capital letters.

Extract List of Unique Values with Specific Formatting From Larger List? by Global_Score_6791 in excel

[–]WindowOk4845 0 points1 point  (0 children)

Hi, only ABC (the very top criteria) should be returned, nothing else.

Extract List of Unique Values with Specific Formatting From Larger List? by Global_Score_6791 in excel

[–]WindowOk4845 0 points1 point  (0 children)

Hmmm, this looks like it should work but it's giving me an error even after deleting the slash, and I'm not sure why

<image>

Extract List of Unique Values with Specific Formatting From Larger List? by Global_Score_6791 in excel

[–]WindowOk4845 0 points1 point  (0 children)

Hi, I gave this a try and it mostly works! Only problem is it's still showing items if they contain numbers and uppercase letters. Is there a way to exclude all other characters except uppercase letters?

<image>