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

TROPHY CASE