u/Catatouille-

So suppose i have 2 columns. A and B

A has the ID

B has the amount

Now, A has some duplicate IDs, and B has different values for all the duplicate values. For example, there are 3 rows of the ID 10A, and each 3 rows has different amounts.

What formula would i have to use to remove the duplicate ID values, Keep just one value, and all 3 amounts of that ID are added.

A B

10A 1

10A 1

10A 1

But i want it to be

A B

10A 3

Thank you

Damn, things went sideways very fast

So I'm planning to make steak tonight إن شاء الله, I already got a small idea on how i should do it (youtube videos), but i thought of asking here.

Any recommendations and tweaks to make delicious steak?

Hey there, guys!

​

I (25M) is looking for new hobbies or ways to distract myself as much as i can. Life is getting complicated in every aspect, and i keep fighting every time

​

Right now, what i do is exhaust myself physically, working out super intensely, going for a hike now and then, playing some sports, swimming etc etc. You name it. On some days, at night, I'd just train continuously for hours just to distract myself and get me tired. In terms of spirituality i focus on my religion and it helps me sometime, and i occasionally consume beneficial media and play chess to keep my mind continously occupied

​

But i can't keep doing this because it's not good for my body to break myself physically this way everyday.

​

I am a complete teetotaler, I've never in my entire life touched any form of alcohols or any type of smoking stuff. I plan to never do it. I find it disgusting and not disciplined, it's also forbidden in my religion.

​

A guy told me to get a life partner, but i have trust issues, and i am not gonna trust a girl easily. Also, i am not into dating and stuff like that. It's either marriage or nothing for me.

​

Is there something you guys did to enjoy that doesn't involve women or narcotics that helped you distract you for while from the world. If so, drop them down

The cold shoulder

‏اَلسَلامُ عَلَيْكُم وَرَحْمَةُ اَللهِ وَبَرَكاتُهُ‎

I've read many many posts of sisters who are victims of SA. Often, many fear marriage because they think they are not pure anymore or they fear that a guy won't accept them for what happened to them.

First, I'm deeply sorry for the victims. May allah grant you ease, happiness, and peace. May allah also deal severely with the person who harmed you.

Now, let me be clear. By no way are you guys impure. What happened was never your fault. You guys are innocent and pure as always. Don't let a garbage person make you think you are impure.

All pious men ik, wants a girl without a past. Let me be clear about what we mean by a past. It simply means a woman who has done zina in the past. Zina means having intercourse with someone you haven't married with consent.

SA is something horrible, and it happens without a person's consent. So this does not mean that you have a past.

----------‐----------------------------------------------

I know many guys online and physical, الحمد لله I'm blessed with many friends. I've asked very good pious guys if they are okay with marrying a good righteous girl who unfortunately is a victim of this horrible crime, those guys are whom any woman would consider themselves as lucky if they got married to them.

Every single one of them answered with "Yes gladly." They all said that they will happily marry and look after a girl who is a victim well.

So i ask you sisters to never worry about this. If a guy does reject you for the sake of you being a victim, trust me, that's allah saving you from a trashy person. You are better off without them.

So, please don't stress yourself. Be kind to yourself. Seek therapy, try to open up about what happened to you with someone you trust and understand you. Don't try to fight this alone, because it can be very heavy, you'll need help carry the trauma you faced.

Also, do not hide about this to a potential. Inform them as soon as you can. This way, you will know if he is a kind person who will look after you and understand you, or he is not your type.

May allah help us. May allah grant the best happy life for all the victims of SA.

​

‏اَلسَلامُ عَلَيْكُم وَرَحْمَةُ اَللهِ وَبَرَكاتُهُ‎

Everyday I read atleast 3-4 posts saying, "i made dua during tahajjut, did this and that, cried all night but why isn't my dua being answered, so now I'm losing hope" and almost 90% of those duas are for a guy or a girl.

What did you think? Did you expect whatever you ask is going to happen exactly or immediately?

If you are to get whatever you ask for, then this should be jannah. That's where all your wishes come true, not in this life. But often people that are blind, sorry to say especially women (I'm not offending just talking after viewing all the posts), most have lost touch with reality, where they expect everything to happen exactly they want like a wishing well or magical elf granting wishes.

Let me tell u one thing, no matter even if you cried tears of blood, certain things won't be answered in the exact way you want it to be for millions of reasons that only allah know why, it won't happen, trust me ik. I have made simple duas that's so easy to happen for idk how many times, but i never got what i wanted, again I've made duas which seemed impossible and سبحان الله they got accepted, i can't even remember the amount of duas that got answered الحمد لله.

----------‐----------------------------------------------

Allah has guaranteed "Ask and he shall reply," but he never said he'll reply exactly for what we want. He will grant you your wish, or he will replace it with something better. He might save you from something harmful, or he might save it for the judgement day.

Does this mean you should not make dua? No. You have to make dua, at least once per day. Ask dua, but don't get too attached to what you ask for because that's what blinds you.

Keep hope in your dua like this. "Whatever allah gives and decides it's what's best for me." Ask your dua, do your good deeds and pray tahajjut for allah's sake not for the sake of making dua to get married to someone, because when your intention becomes that you lose hope and taste in your ibadah.

----------‐----------------------------------------------

When you make a dua, try your best to achieve it and do all the physical tasks that are necessary to make it come true. Try your level best while making dua, but if you find blockages from achieving it, then change your dua to "Ya allah if this thing is not good for me help me see it and guide me to what's good for me" and make your other duas.

Recite this dua

رَبَّنَا آتِنَا مِن لَّدُنكَ رَحْمَةً وَهَيِّئْ لَنَا مِنْ أَمْرِنَا رَشَدًا

Rabbana atina min ladunka rahmatan wahayyi lana min amrinarashada

Meaning: Our Lord, grant us from Yourself mercy and prepare for us from our affair right guidance.

----------‐----------------------------------------------

Remember! this is not jannah for all your wishes to come true, and don't follow these quotes that says "Allah would not have guided you to make this dua if he doesn't want it to happen for you", no hadiths or quran ayah says that. That quote is wrong, IMO

Our Prophet Muhammad (peace be upon him) made 3 duas, one of them was "his ummah not to be destroyed by fighting among themselves", he also made dua for his uncle abu talib's hidayah and prophet nuh (a) made dua for his son. Those weren't granted the way they wanted. So that quote i mentioned earlier doesn't make sense.

You want more proof, fine. Some people get the urge to make to dua die immediately, and it's 100% clear in islam. we should not make such duas, so it's very clear that it's from shaitaan.

I hope you understand this.

Allah granted me this knowledge through experience. It's islamically and logically sensible. May allah grant me hidayah and beneficial knowledge

If i am wrong or made a mistake, please correct me.

Read the below post on my personal experience of what i did to see my duas come true

https://www.reddit.com/r/MuslimLounge/s/5TcvBXbARj

My niece is selected as a prefect الحمد لله so I'm planning to get her a good book as a gift إن شاء الله, can you guys recommend Any books that's like lord of the rings vibe, anything that's pure fictional that's suitable for someone under 16. It should not have any sort of inappropriate things.

‏اَلسَلامُ عَلَيْكُم وَرَحْمَةُ اَللهِ وَبَرَكاتُهُ‎

Is anyone here married to a person who's not lankan or do you guys know someone who married like that?

Could you share the challenges you/they faced and how did you meet your spouse?

Since the gold market is unpredictable and sometimes it's super high, title.

Also, did you guys decide your mahr, or did your family do it for you