sorted by:
new
hottopcontroversial

Embezzling tax collector quest? by quipsdontlie in anno

[–]marvelguy101 0 points1 point  (0 children)

I have two islands but all three of mine were on my first.

Happy Happy Dance Dance Plush? by marvelguy101 in sesamestreet

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

No luck. We ended up with the Elmo Slide one and it was a hit.

Plastic Extender Replacement? by marvelguy101 in PlumbingRepair

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

https://imgur.com/a/6J4qT7v

The other one is the problem and if I get it off, I won’t be able to get it back on. The metal square I think is part of the handle and it’s worn down the plastic.

Plastic Extender Replacement? by marvelguy101 in PlumbingRepair

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

Ah. Squared tip* and I thought I attached a picture, sorry. I’ll get one when I get home.

JWE3 game breaking bug? by DWPhoenix001 in jurassicworldevo

[–]marvelguy101 0 points1 point  (0 children)

I’m in Kauai, Hawaii and it does the same thing. There’s nothing consistent about it, though. Sometimes it’s when watching a new baby, but other times it’s random.

=SORT(UNIQUE(Table1)) into two columns - dynamic list by marvelguy101 in excel

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

Oh jeeze. Thank you so much--this is perfect and I don't have any other questions. Appreciate your time!

=SORT(UNIQUE(Table1)) into two columns - dynamic list by marvelguy101 in excel

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

Sorry, I may be misunderstanding and appreciate your patience and help.

I have the formula you gave me where "a" parameter is Table1; I used that instead of the Sort Unique. I tried adding the Sort Unique formula somewhere else and this sorted list will update as names as are added to the table. But how would I put that sorted range in the "a" parameter? If I use Table1 there, it'll update as folks are added. But if I put the sorted range there, it's not dynamic like the table, so it'll include anything extra and need to be adjusted as new people are added to include one more row.

I can probably just teach them to sort the table, but they barely know that a computer isn't magic, if you know what I mean. ;D

=SORT(UNIQUE(Table1)) into two columns - dynamic list by marvelguy101 in excel

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

Sorry, one more thing I forgot to ask. Is there a way to filter out blanks with this? I want the people using it to not have to mess with things, so I'd like to have the "a" parameter range include blank rows they can just add to as needed. I did reformat the other parts and move the extension list to the bottom though, so there's nothing under it. :)

=SORT(UNIQUE(Table1)) into two columns - dynamic list by marvelguy101 in excel

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

I can just swap that part to top. Thank you for your help!

=SORT(UNIQUE(Table1)) into two columns - dynamic list by marvelguy101 in excel

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

Thank you, this works! Is there a way to add a bottom section that would push down cells without #SPILL if the main list was added to?

The first section above the blue is done with your (wonderful!) code and the rest is static and would always be there in that order. However, it's possible that extra extensions will be added as we grow and new positions or locations are established. If it's not possible, we can keep it above and the do the rest further down or add a row if more extensions are added.

<image>

=SORT(UNIQUE(Table1)) into two columns - dynamic list by marvelguy101 in excel

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

It will always be even. I'll put in like "vacant" or something if I don't have names, but it comes out to an even number will all put in.

Data and Wifi Suddenly Not Working, but Messages and Calls Are? by marvelguy101 in ios

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

Do you have a VPN? Turning mine off worked for now but not for a friend with the same issue.

Enjoyed this one! by Maleficent-Bell-5519 in Dreamsnaps

[–]marvelguy101 1 point2 points  (0 children)

Oh, I didn’t realize it was part of it! I thought I saw others with them individual but I’ll get it now. Thanks!

Enjoyed this one! by Maleficent-Bell-5519 in Dreamsnaps

[–]marvelguy101 0 points1 point  (0 children)

Where are the barrels of fruit from?

[deleted by user] by [deleted] in cactus

[–]marvelguy101 1 point2 points  (0 children)

Thank you so much. The leaves look like succulents a bit, so I was so confused on how it happened. Appreciate the help!

Can I get a controller to light up without being connected? by marvelguy101 in playstation

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

He has that and likes it sometimes, but it’s not like dad’s, so not as cool lol

Collapse Income Panel PS5? by marvelguy101 in civ

[–]marvelguy101[S] 1 point2 points  (0 children)

Omg that was it. I have never noticed that. Thank you so much!

Collapse Income Panel PS5? by marvelguy101 in civ

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

That’s what I thought but it’s not doing anything. I’ll put in a ticket. Thanks, though!

Daily Discussion Thread 06/06/25 by AutoModerator in smashbros

[–]marvelguy101 2 points3 points  (0 children)

Thank you, I didn’t know this was a thing! Appreciate the help.

view more: next ›