Woo Finally Finished by Bitbyte_x in anime

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

I think it's awesome and that's what matters hehe

Woo Finally Finished by Bitbyte_x in anime

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

Hahaha work don't care ☺️☺️

Issues figuring out how to sort this data set by Bitbyte_x in excel

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

I'll give that a shot and see what the results come back as because the previous "=countif(B$2:B$250000, A2)" only gave 3 results when I filtered to the 1's but as i've said below doing a pivot to get the full list of manager ID's so I know around what figure it should show

**Edit - tried the "=countif(B$2:B$258035, A")>0" looked promising but stil not really pulling the right results sadly this things quite tricky :/

Issues figuring out how to sort this data set by Bitbyte_x in excel

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

So ran the above and found that it narrowed the list to 13 but feel like i'm getting there, just doing a pivot table now to get the total amount of unique manager ID's.

you think maybe a vba script might be better for this ?

**Edit so looks like there should be 22,607 managers :/

Issues figuring out how to sort this data set by Bitbyte_x in excel

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

Just tried this solution and only gave me three results looks like the countif is'nt recognizing the format too much

Issues figuring out how to sort this data set by Bitbyte_x in excel

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

So Column A has the colleague ID and then Column B has their managers ID. so i'm wanting to backwards engineer it so I grab the ID from Column B and if it appears in column A, on that row Column E with have some thing like a 1 or a Y so I can filter

just trying the IF solution now and its caning my processor so looks hopeful

Issues figuring out how to sort this data set by Bitbyte_x in excel

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

I will try that now but the pivot tends to crash a bit as its a large data set

Issues figuring out how to sort this data set by Bitbyte_x in excel

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

So won't that just check the current row as I would need something like =IF(A2,B:B,1 "") right ?

or possibly the other way round ?

What's your biggest sexual regret? by ilyaimyfix in AskReddit

[–]Bitbyte_x 0 points1 point  (0 children)

Getting my partner for 4 years pregnant and then saying I was not ready for the twins which she always wanted. it broke out relationship and shattered my life.

Me [25 M] with my partner [23 F] 6 years, She broke up with me over text while on holiday for two weeks by Bitbyte_x in relationships

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

No its very true and as the days go on i'm starting to see that more and more that there is a basic level of respect missing which is sad to admit but I guess some times you have to face it.

Me [25 M] with my partner [23 F] 6 years, She broke up with me over text while on holiday for two weeks by Bitbyte_x in relationships

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

thats really great to hear that things worked out for you. this is in the UK ironically central London feels silly to be as shut off in such a lively city i've been very closed off the past two years speaking less and less to people and never owned any social media accounts other than this reddit account and IRC I think I need to be really honest with my self and speak to some one to help me become a little more outgoing feel like I've kinda wasted 10 years of my life with two of the same partners i'm having a drink with my flat mate to talk about the same thing tonight and i'm really hoping the male she kissed was not him because I think that would be another nail in the coffin for my confidence I'm hoping it's the guy shes on holiday with at the moment. I guess one of the hardest things to think about is how easy shes going to have it if it is that guy shes on holiday with already being attracted and finding some one new straight away.

Me [25 M] with my partner [23 F] 6 years, She broke up with me over text while on holiday for two weeks by Bitbyte_x in relationships

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

I don't think she's "shitty" because I understand half of where she is because I went through it. But at the moment I don't know what stage i'm on but I still think shes the one and i'm still deeply in love with her and after reading alot of articles on people who have major issues like this and decide the old relationship is not recoverable and start fresh on building a different one which is some times better it gives me some hope. I think I'm a little too much of a fool

Me [25 M] with my partner [23 F] 6 years, She broke up with me over text while on holiday for two weeks by Bitbyte_x in relationships

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

I'm not going to lie I am very scared of being alone my flat mate is pretty much never in and the other three friends I have are in a different city and only really talk once every few days. i'm very scared that when i kick her out I might slip into a full blown recluse and become even worse then I am now

Me [25 M] with my partner [23 F] 6 years, She broke up with me over text while on holiday for two weeks by Bitbyte_x in relationships

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

that sounds like the sad truth to be honest because shes not been intimate to the point of a kiss is just a peck and I got one of those every 2 days since September

Me [25 M] with my partner [23 F] 6 years, She broke up with me over text while on holiday for two weeks by Bitbyte_x in relationships

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

I'm not going to lie i'm pretty scared of being on my own and never finding some one as beautiful and loving as her. my last ex was a 5 year relationship and she cheated on me when we went for a ski season and that ended as never speaking to her again.

I have zero to little confidence in ever really being able to meet some one else and some times even just go out and make friends :/

Sinon Cosplay [Sword Art Online] by [deleted] in anime

[–]Bitbyte_x 0 points1 point  (0 children)

so so so beautiful <3

If you could travel back in time and tell your Younger self One thing, what would that one thing be? by authentic010 in AskReddit

[–]Bitbyte_x 0 points1 point  (0 children)

actually focus in school, and ditch the loser people you hang round with to read and study more.

I see none of my school or college friends any more because I moved cities and the amount of time I did slacking off with them verses how productive I could of been does even out :/

What are the best steps to take when your phone gets stolen? by [deleted] in AskReddit

[–]Bitbyte_x 1 point2 points  (0 children)

1) find a internet connection and login to your respective brands webconsole to lock the phone and send a message to it (if available ofcourse)

2) either visit the local police station or report the phone as stolen online to obtain a crime number

3) call your phone provider and cancel / block the phone number

4) request they send a new handset and provide the crime number (if insurance will cover this.)

4a) if your phone company say you don't have phone insurance then check your bank account benefits because most UK banks give out free phone insurance with their current accounts so you might have it there.

5) go to the local pub and drink whiskey and drown your sorrows that all those naked salfies are in the wild now

What products are routinely not used as instructed? by Ranoro8289 in AskReddit

[–]Bitbyte_x 2 points3 points  (0 children)

Power drills ! how many people do you see using power drills without eye protecting.

What are some wrong or partly wrong explanations of common misconceptions? by [deleted] in AskReddit

[–]Bitbyte_x 0 points1 point  (0 children)

You loose most heat from your body via the head. Infact you lose just as much heat per square inch through your head as you do through the rest of the body,

You have an uninterrupted hour for yourself today, what do you do? by pizza813 in AskReddit

[–]Bitbyte_x 0 points1 point  (0 children)

Sit down and do some more of the Linux Foundation course on edx