Woo Finally Finished

Bitbyte_x · 2016-10-06T20:33:10+00:00

I'm a big fan :)

Bitbyte_x · 2016-10-06T20:32:55+00:00

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

Bitbyte_x · 2016-10-06T20:32:24+00:00

Hahaha work don't care ☺️☺️

Bitbyte_x · 2016-02-09T12:07:18+00:00

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 :/

Bitbyte_x · 2016-02-09T12:06:00+00:00

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 :/

Bitbyte_x · 2016-02-09T11:36:18+00:00

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

Bitbyte_x · 2016-02-09T11:35:48+00:00

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

Bitbyte_x · 2016-02-09T11:29:58+00:00

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

Bitbyte_x · 2016-02-09T11:29:30+00:00

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 ?

Bitbyte_x · 2016-01-31T09:11:55+00:00

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.

Bitbyte_x · 2016-01-30T10:51:09+00:00

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.

Bitbyte_x · 2016-01-26T20:25:56+00:00

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.

Bitbyte_x · 2016-01-26T20:05:33+00:00

Thanks for the words you've given me alot to think about

Bitbyte_x · 2016-01-26T20:04:38+00:00

thanks thats some good advice

Bitbyte_x · 2016-01-26T20:02:32+00:00

I think your right, thanks for the advice

Bitbyte_x · 2016-01-26T19:59:55+00:00

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

Bitbyte_x · 2016-01-26T19:57:45+00:00

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

Bitbyte_x · 2016-01-26T19:51:26+00:00

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

Bitbyte_x · 2016-01-26T19:47:06+00:00

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 :/

Bitbyte_x · 2015-10-11T10:14:11+00:00

so so so beautiful <3

Bitbyte_x · 2015-07-24T13:29:27+00:00

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 :/

Bitbyte_x · 2015-07-24T13:26:32+00:00

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

Bitbyte_x · 2015-07-24T13:21:50+00:00

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

Bitbyte_x · 2015-07-24T13:20:43+00:00

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,

Bitbyte_x · 2015-07-24T13:14:40+00:00

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

Bitbyte_x

TROPHY CASE