#duplicates in excel

[haveyouusedthispokemon]

how do you think we should vote for shinies that we don't currently have, but did once? i'm mostly thinking about shinies that were evolved, here: for example, i have a shiny linoone i evolved from a zigzagoon. i don't currently have a shiny zigzagoon, but it wouldn't be right to say i've never encountered one either. would it make more sense to vote as if i still have this zigzagoon, or do you think that warrants an extra poll option (ie, "i had this shiny but don't anymore")?

I believe it makes sense to vote as though you still have that Zigzagoon, with how the polls are currently set up. Since the 'how you met carries through evolution line', your Linoone was your Zigzagoon.

I'll definitely consider the extra poll option, or simplifying the last 'no' option to 'No I don't have one'

[revvethasmythh]

*laughs nervously* totally not worried about dueling orin. totally not

[freakoutgirl]

I've tried Canva, I've tried Word, nothing fucking works for this portfolio!!!! how am i supposed to show a written report and an excel sheet AND make it look nice!!!!

[volfoss]

Sincerely as a former user of both Excel and sheets, it is nuts how much easier libre office calc is. Not in the typical way that certain things are easier to access but moreso that the formulas and ways things are set up just work with my brain better. I never really had much need to learn formulas in Excel because there were so many and the layout felt over complicated, and don't even get me started on sheets. But with calc, there's a lot more freedom with the formulas and a lot of the skills you have from either of those other programs carries on here. Not a super big point or anything to this post, just simply very appreciative of what calc can do.

[frida--y]

at the, “i miss our old intern” stage at work

[advancedexcelinstitute]

How to Handle Duplicates in Excel Without Losing Important Data

If you’ve ever worked with large Excel sheets, you know how easily duplicate entries can sneak in. From client databases to inventory records, these repeated values can distort your analysis and lead to reporting errors. The key isn’t just removing them — it’s doing so without deleting valuable information.

Many people jump straight to the “Remove Duplicates” button in Excel, which can work well, but only if you’re sure of what you’re deleting. Without a careful review, you might end up losing original data that shouldn’t have been removed.

A smarter way is to use Excel’s built-in features more strategically. For instance, Conditional Formatting lets you highlight duplicates visually before taking any action. This gives you time to scan through the data and verify what’s truly redundant.

Another helpful method is to use Excel’s Advanced Filter. This allows you to copy only unique values to another location, keeping your original data intact. It’s especially useful when you want to create a clean version of your data for analysis without changing the source file.

Formulas also come in handy. By using functions like COUNTIF, you can flag rows that appear more than once. You can then decide manually which entries to keep or discard, giving you full control over your data.

Whatever method you choose, the golden rule is this: always back up your file before making changes. That way, even if something goes wrong, you can recover the original without stress.

Removing duplicates in Excel doesn’t have to be risky or complicated. With a few smart techniques, you can keep your data clean and organized while protecting valuable information. Whether you’re a beginner or an experienced Excel user, learning the right approach will help you work more efficiently and avoid costly mistakes.

For a step-by-step walkthrough on these methods — including tips, examples, and best practices — check out the full article. It’s a great resource if you want to master Excel’s data-cleaning features without compromising your data.

[loredwy]

... okay I must admit I maybe have too many tags

[stealingyourbones]

Danny has been having issues trying to find a job that allows him to use his powers. He’s no longer in the superhero scene anymore but why not still put his powers to use?

After successfully gaining a job as a Stuntman, he didn’t know what he signed himself up to do but he took multiple classes to prepare and fell in love with the profession. His powers letting him further excel in his career as things like flight, intangibility, and duplication all were things that studio heads were delighted of as it lessened the cost of production.

Stuntman don’t get a lot of recognition by average film goers which is fine for Danny. Staying under the radar and living a normal life is all he could ever ask for.

Sadly for Danny, that anonymity didn’t last forever. Danny was hired as a stunt performer in a 90s satire esque autobiography movie written and starring the Gotham Billionaire Bruce Wayne.

During an on set interview midway though Bruce explaining to the interviewer that Hot Shots was his biggest inspiration for this film, Danny casually walked behind the set, just trying to get to the costume department and thinking nothing of being temporarily on camera behind the Billionaire.

The day the interview was uploaded onto YouTube, Danny’s phone was blowing up from messages from his friends and family telling him he had become an internet sensation overnight. It turns out his casual walk behind Bruce Wayne led to the internet losing their minds trying to find the Bruce Wayne look-alike. I mean, Danny DID become Bruce’s primary stunt double because he looked so similar, that’s the whole point of stunt doubles, but Danny didn’t think it was THAT similar.

[mitsde123]

A Beginner’s Guide to Data Cleaning Techniques

Data is the lifeblood of any modern organization. However, raw data is rarely ready for analysis. Before it can be used for insights, data must be cleaned, refined, and structured—a process known as data cleaning. This blog will explore essential data-cleaning techniques, why they are important, and how beginners can master them.

[oneawkwardcookie]

Didn't expect to use the method for calculating an arithmetic sequence formula today, but that was fun!

[cygnahime]

The urge to say, "oh, but it's easy!" is why IMO teachers below the college level shouldn't teach their best subject. Honestly, college teachers should ALSO be teaching some of their less-good subjects, the things they had to work to learn.

I'm very good at English, and that is why I shouldn't be an English teacher, especially at the level of teaching people to read but also just...in general. Because I learned to read before I have conscious memories. Because my family was reading Shakespeare out loud to me and taking me to performances before school thought it time to touch the stuff.

Which means I don't know how to struggle with these things. I don't know how to learn to read on purpose; I was read to every day of my little life, is how it happened for me. That's not a method you can duplicate in the classroom. It's, you know, great that it's obvious to me, but the whole point of teaching is to provide something to people for whom it is not obvious! I didn't need an English teacher - not that I never benefited from one (thank you Mrs. Hartmann for teaching us about subject/object pronouns and sentence diagrams), but that I would have reached a high level of literacy without one. So English teachers shouldn't be focused on students like me, should they?

My high school chemistry teacher was an excellent chemist, definitely overqualified for the job on paper. But my god she could not teach. If you couldn't understand from the book, or from the one way she was able to explain it, you were out of luck. Because it was easy.

[witchesballad]

hero and villain

THUNDERBOLTS* SPOILER

Pairing: Bucky Barnes x Widow!Reader

Warnings: Forced pregnancy (backstory) and discussion of sexual assault

Summary:

From what Yelena and John spoke of, Bucky expected to see some montage of Winter Soldier highlights. Not the bright and cozy family room, not you standing opposite of him watching the scene unfold with tears streaming down your face. A duplicate of you, younger, your hair a different colour, was handing a package over to a woman he didn't know.

A/N: im weak, i wont survive the winter.... baby fic. We were all talking about the Found Family of it all, what about the Found "Baby I Abandoned and Didn't Tell You About" in the Void?

part one, part two

   From what Yelena and John spoke of, Bucky expected to see some of the Winter Soldier highlights - an innocent's warm blood coating his face, the scream of one of his victims echoing in the inky black, a hit on an uncooperative politician. Not the bright and cozy family room, not you standing opposite of him watching the scene unfold with tears streaming down your face.

A duplicate of you, younger, your hair a different colour, was handing a package over to a woman he didn't know. They're speaking to each other. He opens his mouth to interrupt them, when he's shoved back.

"What-" Another shove. "Are-" Another. "You-" The hands pushing him become fists. "Doing-!?"

He snatches you by the wrists to stop you, and all of the fight seeps out of you. You're still sneering at him as though you hate him for stopping you and not fighting. The two of you were excellent at fighting.

"I thought you died, coming in here." he states, calm enough to set you off again.

You roll your eyes at him, scoffing. It doesn’t convince him that you are as untouchable and unphased as you want it to come across. The tear tracks that had cut through the dust and grime on your face from that last fight, had him thinking otherwise.

A mask for what he can see is a deep sadness. This room...what was so traumatic about a room? He moves to pass you, to get a closer look at the woman he didn't know. 

Your instinct is to grapple him to the ground. It didn’t matter that you were one of the best fighters this world had known, he wasn’t going to use his strength. The two of you had fought each other in the past, but he never hurt you. This has not been the first time you have pinned him, and knowing you, it will not be the last. Your knee is in his back, his hands twisted into your grip.

The door slams shut as your younger self nearly runs away. A second later, you come back in with the unfamiliar woman.

“Is she one of the younger ones?” she asks as they step through the door, around the two of you on the floor.

There is a whimper of a response, but Bucky can’t see from his position who it comes from.

“I-I-I-I’m next-” 

His chest feels like it collapses in on itself. That’s your voice, he’s never heard you cry before. When he speaks, he directs it up to you, “Your next what? What is she saying?”

You take a deep breath above him, in through the nose out through the mouth, before ordering, “Stay down.”

His hands are released and you get off his back. You don’t move too far, simply sitting with him on the ground. Not risking another grapple, Bucky places his hands palm down, lifts his head to tilt his ear toward the conversation taking place.

“So he’s going to come then?” 

Younger you sniffs and hums an acknowledgement. “I lost him in DC, I think he was assigned another mission.”

The other woman gasps, “Project Insight. SHIELD’s entire archive was released. Three helicarriers crashed into the Potomac.”

“Knowing my luck, he survived.”

Older you snorts in amusement. 

Bucky twists his head to give you a bemused look. He had gathered that they were talking about him - or, the Winter Soldier. But the look fades as the realization sets in. Bob was showing them their fears. Yelena had described this as a shame room.

You were afraid of him. 

The you of the memory continues talking, “I can lead them away. No one will know about this, and when I tell you, you will be the only person to know. It has to stay that way. You will be in danger from HYDRA, the Red Room, and who knows who else. I am telling you because you got me out. You are the only person I trust, Oksana.”

“сестра, you are one of the nests. They will hunt you to the ends of the earth.”

“I’ll do it for her. Just take her far away.”

“She’s yours! You can hide now, with her.”

“I can lead them away. She’s his. They will come for her. They’ll send him. Maybe he’ll kill her outright, he won’t know she’s his daughter.”

The revelation takes its time sinking in. He doesn’t get up, doesn’t move. He just turns onto his back, now trapped between you and a couch on the floor of a memory that isn’t even his. He was wrong. This wasn’t your shame room. It was built for him. The Winter Soldier had committed many atrocities but this was the worst. 

This was a shame room built for him. He had done— that to you.

You take his closest hand - the metal one - in your two, and pull the pair of you to your feet. 

“Your next.” he says, his voice thin. He had misheard your younger self, “You’re a nest.”

He had heard about a subsect of the Widow program, the Nest, dedicated to the repopulation of the small army. The few of the Widows who were left in tact for Dreykov’s nefarious purposes. A program for training swallows. Teenage baby factories. 

You squeeze his hand. “Yes, and you-”

“How can you even look at me?” he was shaking his head,  “It’s not right. What I did-”

“Was as much assault on you as it was for me. You aren’t the only one in therapy. Bucky, this room is not for you. I’m the one that left her. Didn’t tell you.”

“I hunted you, of course you didn’t tell me.” 

As if he could dismiss your self-hatred with his own. The easy forgiveness brought the tears back to your eyes. You close your eyes to block them, gritting your teeth. He brushes your tears away for you, and rests his hand on your cheek. The hesitance in the air makes you open your eyes and make eye contact.

He takes in a breath, as if steeling himself.

“Can I look at her?”

You take his hand and lead him over to the back of the couch so the pair of you might lean over the memory. He had seen the baby as a package of some sort earlier, because younger you had used a shipping box as a makeshift carrier. The cardboard box was stuffed with a soft hoodie as a blanket. The baby had not made a sound the entire time, even as a younger you shoved the box into the other woman, Oksana’s, hands. Ignoring her protests, you tell her, “Don’t tell me where you’re going. Protect her.”

And you leave. Bucky turns his head to watch you go, and when he turns back - Oksana and the baby are nowhere to be found. 

The door opens again. The two Widows walk in, and Bucky trails them back to the couch that they sit down on.

“She’s so little,” he comments. He does not look at you, lest he acknowledge the fact that seeing a reflection of you holding his baby was plucking a heart string.

The pair of you lean in, and you huff out a laugh, as you nudge him, “Looks like you from tip to tail, doesn’t she?”

He looks up at you, sees the tiny features that made the baby beautiful to him. His jaw is left hanging. “Looks like you.”

You grimace and apologize to the baby, “Sorry, junior.” You reach down to poke the baby’s nose.

Bucky’s heart clenches, imagining it all turn to smoke and shadow. He had not touched anything to do with this room, contributing to the dreamlike quality that this all held. But you touch the baby, scrunching your nose when the baby adorably wrinkles her face against your finger.

A voice, not yours, and yours at the same time speaks from the younger you.

“You knew then. Don’t be stupid. You don’t deserve her. ” 

There is something behind you - and on the wall. Bucky puts his hand on your shoulder to move you and the baby behind him, put himself in between. Instinctively, you scoop up the baby. 

But there is no standing between you and your shadow. As if you had a second arm attached at the elbow, a darkness - a void - clamps down on your wrist and twists.

When you yelp, Bucky reaches into the split in space and yanks the shadow from you. You recoil, hunching over the baby. Your good arm still cradling her to your body, turned away from the chaos. The darkness manifests itself as the younger you. She sneers at Bucky. 

“Look at me, Soldat.” she says, enraged, “You forgot a name on the list. Where is the effort to make amends, Sergeant James Buchanan Barnes?”

She goes for a strike. Pale and frozen, he takes the hits. You can see the pattern, the memory is taking the same moves you would use now, not the Red Room clone that you used to be. Or have you always been that obvious, telegraphing your punches? You watch Bucky and understand him. You understand why you could pin a super soldier like the Winter Soldier.

He has never hurt you, but you know that’s because he would never fight you.

You draw your gun to help, but your aim shakes with the weight of it on your broken wrist. In that instance, the woman who had rescued you from Dreykov restrains you. With her arm around your throat, and your injured arm twisted behind.

With her holding your arms and dragging you back, you can only call out.

“She’s not me, Barnes!” you shout at him, “Kick her ass!”

You watch him sink into a place he hasn’t in a long time. Bucky would never hurt you, but the Winter Soldier has no mercy. Following your command, the metal hand reaches back and grabs the ankle of the twenty year old assassin on his back. In a maneuver too quick to track, he has her pinned and her throat caught in his hands. She gasps for air, tilting her head up- to look at you. Her mouth moves - and you hear her (not yours and yours at the same time) voice from Oksana behind you.

“See how he hates you? See how the hero will never love the villain? He will always hurt us.”

That’s not true. He never fought back.

With that flimsy plate of armor around your heart, you bend your head to bite Oksana. Her recoil gives you enough room to drop and spin, knocking her feet from under her. You use the momentum to slide yourself away and point your gun up at her. She drops and you turn the muzzle on yourself - your younger self. Two bullets for your ledger. Daddy Alexei would be so proud of his little murderer, dripping red.

Bucky staggers to his feet, eyes wide and fearful before he looks at you. Child murderer. There’s no shadow to remind you of what you are, but you know. This memory is a decade old. You have just shot a twenty year old who has just escaped the prison that held her for her entire life. He must see the same child you do. 

His face twists into something else, and it’s worse than you could have dreaded. He looks at you with pity.

You feel it then.

That same rush of adrenaline that comes with firing a shot - that same rush of adrenaline that comes with quarrel for the sake of quarrel - that same rush of adrenaline when he looks at you with any other expression, when he shines that spotlight attention on even a fraction of you. 

You want to be mad, to tell him off for pitying you, but the relief that all of you are okay hits you before the urge to fight comes up like nausea.

He steps forward, and you think he’s just going to leave you. But he comes behind you to help you to your feet.

You take the opportunity to put the gun away and cradle the baby. You trace her fragile skull with your finger. The pain radiates from your wrist to the tips of your fingers. You deserve this pain. You don’t deserve to touch her. This is why you left her behind.

Bucky still hasn’t stopped supporting you, leaning into your back as he wraps his metal arm around your waist. You feel his other hand move to support your wrist, careful to not touch the inflamed bruising. 

“Do you want me to take her?” he asks. You take a breath to steady yourself. He’s standing so close that swaying on your feet leans you into his chest. You shake your head, but hand her over all the same. “We have to find Sentry.”

“Bob.” you correct. You still had the image of that sweet civilian who grabbed a gun and ran into a field of soldiers to distract them. It didn’t matter that Valentina dyed his hair and poisoned him against you and the team. “His name is Bob. He needs our help.”

There’s no Winter Soldier in the soft look you receive. “You came in here not knowing if we can save him.”

“We haven’t moved on. Can you carry her?”

“Yes, of course,” He adjusted the baby as if to show off how capable he was. You grit your teeth at the back of your mouth to not see a father holding his baby. You have a mission. Save Bob.

You nod and lead the way to the door out of the room.

---

[localfandomenjoyer]

What powers would the demigod children of Perse Kronide have? Since Perse's primary domains are Loyalty and Vitality, not the ocean, would they still have aquatic powers? I can definitely see them having greater ability to endure physical illnesses and injuries, surviving what would normally kill other mortals and even demigods, kinda like how the Uzumaki Clan from Naruto are known for their vitality. Not sure how the Loyalty aspect would appear in her kids - the ability to hold people to their words? Sensing duplicity and deceit in false promises? They're all probably excellent warriors though given their mother is such a badass 💅 Oh wait, since the Big 3 kids are naturally given more authority and leadership at the camps do you think the same applies to Perse's kids? They're children of the Queen of the Gods, surely that affords them some level of prestige and respect. The thought of Perse having demigod kids never occurred to me, but now that you confirmed their existence I'm super invested in thinking about their cabins, inherited godly traits, relationship with the other cabins, etc. Does Perse only grant kids to worthy couples who want a baby? Does she grant them to single parents if they're financially and emotionally responsible and ready for parenthood? Sooo many questions!

I'm thinking vitality would come with aquatic powers, just more precise in scope than a Poseidon kid and with no direct affinity for the sea. That said, the sea would be gentler to them, but that has more to do with oceanic spirits liking their mum. You are right about the endurance too. Perseleia kids have better stamina and heal faster than most, plus they can help others recover faster as well by boosting the vitality of others. The more powerful and aggressive among them could even inflict enemies with weakness.

Loyalty definitely comes with an ability to sense duplicity and allegiances. You are right to say they'd be natural leaders too, though they lack the raw strength of a Big Three kid.

I've answered a bit on what criteria Perse uses for choosing families, but yeah, it's worthy couples who want children. Inherited godly traits are probably very minor. Perse wants her children to fit in with the new family, so they'd very much look like their mortal parents. I imagine they will all be somewhat reminiscent of Sally Jackson, with kinder appearances, darker hair tones and bright eyes since Perse won't be able to help it. Anyone who meets Sally will definitely assume she is a demigod daughter

The Perseleia cabin get along well with most others, but they do inspire envy and bitterness at times. Perse selecting for good couples means her children have better home lives than even the average mortal, let alone a demigod, so imagine how a child like Annabeth must feel overhearing a Perseleia kid talk about writing letters to his parents when she hasn't seen her dad in years?

[prettygirl-gabi]

Chapter 3: Focus on Us

Rating: General Audiences

Warning: none

Paring: Paige Bueckers x !photographer fem reader

Fandom: Women's basketball

Summary: "you're important"

Welcome to chapter 3 of Through The Lens. I hope you all enjoy and there is more to come...stay tuned my loveies!! 🏀💕📸

It was late, and my tiny dorm desk was cluttered with camera equipment, SD cards, and a cup of lukewarm coffee I’d forgotten to drink. The incident in the gym with Paige lingered in my mind as I sat editing footage for my final project. My fingers hovered over the keyboard as I debated whether to open the file labeled “Gym Footage – Paige.”

Curiosity got the better of me, and I clicked play.

The screen flickered to life, showing Paige’s face as she fumbled with my camera. Her brows furrowed in concentration as she adjusted the angle, murmuring to herself, “How does she make this look so easy?”

I couldn’t help but smile at the way she treated my camera like it was something sacred. Then her tone turned serious.

“Hey, Y/N,” she began, her voice soft but sincere. “I know you’re probably still upset about what happened, and honestly, you have every right to be. But I hope you know how much I admire you—your work, your passion, everything. You’re incredible, and I hate that I hurt you.”

My chest tightened as I listened, her words more heartfelt than I expected.

The video continued, capturing the moment I returned from the bathroom. Paige must have thought she’d turned the camera off, but it kept rolling as we talked, laughed, and shared pieces of ourselves on that cold gym floor.

By the time the video ended, I felt a mix of emotions—touched by Paige’s honesty, but also incredibly awkward knowing it had been recorded. Still, I couldn’t bring myself to delete it. Instead, I duplicated the footage onto a hard drive, labeling it simply as For Paige.

At the next practice, I made my way to the gym, the hard drive tucked securely in my bag. I was nervous to hand it over, unsure how Paige would react.

She spotted me as soon as I walked in, her face lighting up with a grin. “Hey, stranger! Decided to stop avoiding me?”

I rolled my eyes, though I couldn’t hide my smile. “I was never avoiding you.”

“Sure,” she teased, jogging over to meet me. “What’s that?”

I pulled the hard drive from my bag, holding it out to her. “It’s… the footage from the gym. I thought you might want a copy.”

Her smile softened as she took it from me, her fingers brushing against mine. “Thanks, Y/N. I didn’t think you kept it.”

I shrugged, trying to play it cool. “It’s good footage. And, well… I think it’s important.”

Paige’s gaze lingered on me for a moment, her expression unreadable. “You’re important.”

The words hung in the air between us, making my heart skip a beat. Before I could respond, Coach blew his whistle, calling the team to start drills.

Over the next few weeks, Paige and I grew closer. At games—both home and away—she made a point to check in on me, making sure I had a good spot to shoot from and subtly positioning herself during warm-ups to shield me from stray balls.

“Protecting your camera,” she’d say with a smirk, though the warmth in her eyes told me it was more than that.

At home games, her attentiveness didn’t go unnoticed by the team—or the fans. KK and Azzi teased us relentlessly, while fans on social media began speculating about our dynamic, tagging us in posts with captions like, “Paige’s photographer girlfriend?”

One particular home game, as I set up my equipment during warm-ups, Paige jogged over, her usual grin in place.

“Let me try,” she said, gesturing to my camera.

I raised an eyebrow. “Try what?”

“Taking pictures,” she said, her tone playful. “You make it look easy, but I bet it’s harder than it seems.”

I hesitated, glancing at the camera in my hands. “Paige, this is expensive equipment. What if you drop it?”

She placed a hand over her heart, feigning offense. “Y/N, I’m an athlete. I have excellent hand-eye coordination.”

I laughed despite myself, eventually handing her the camera. “Fine, but if you break this one, you’re buying me a new one.”

“Deal,” she said with a wink, taking the camera from me.

She spent the next ten minutes snapping pictures of her teammates—some candid, some posed—and even turned the lens on me a few times.

“Paige!” I protested, holding up my hand to block her view.

“Come on, you’re the star of this project,” she teased. “Let me get one good shot.”

Reluctantly, I lowered my hand, letting her capture a few photos. She grinned at the screen, clearly proud of her work.

“You’re a natural,” I admitted as she handed the camera back.

“Only because I have the best teacher,” she replied, her tone soft.

Later, as the game began, I couldn’t help but notice how Paige glanced my way after every big play, her smile brighter than usual. When she made a block that sent the ball flying dangerously close to my corner, she immediately looked over, mouthing, “You okay?”

I nodded, giving her a thumbs-up, and she grinned before returning to the game.

By the time the night ended, I had more than enough photos for my project—and a growing collection of memories with Paige that I knew I’d treasure.

■■■■■■■■■■■■■■■■■■■■■■

-Thank You For Reading!🩵��

-prettygirl-gabi🎀✨️

Tag list: @sayurireidotcom , @astroeliza .... (more to be added)

[kcscribbler]

OK but Loki's magic includes duplication-casting, and now he can also manipulate time.

So theoretically, he could cast an accurate-on-the-molecular-level duplicate of himself into any timeline, without leaving his new throne.

That would have made an excellent after-credits scene.