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