=SUMIF(D80:D100,”13:00:00″,F80:F100)

Could you give some background? Education, skills, jobs you want to go into?

Check for driver updates! My laptop touchpad stopped working after the upgrade, had to get the latest driver for it to work.

Stick that in “ThisWorkbook”.

Basically counts your sheets. Then opens the sheet which equals the count. Stick a minus and a number behind Sheets.Count if you have extra sheets.

———————————

Private Sub Workbook_Open()

i = Sheets.Count

Worksheets(i).Activate

End Sub

It’s linked to your mouse settings in Windows. Go to Mouse properties, then to Wheel. Then under vertical scrolling you can change how many rows you want.

Definitely take her out for lunch & dinner. Bring chocolate, biscuits and any snacks she likes. Ask her if she wants anything from home?

Yep, SOHO and Central are good places to walk around. Tsim Sha Tsui water front is good, get to see that Hong Kong skyline. Could visit Sky100 the tallest building in HK, get a good view if the weather is nice.

http://www.cyberphysics.co.uk/topics/forces/equilibrium.htm

Comes from question 3

LG G4 vote from me. Have a LG G3 at the moment and had switched from iPhone before hand. Amazing screen, good camera, replaceable battery and SD card slot. G5 is coming out next year March time if you can wait. But G4’s are going cheap at the moment, around £300.

Got a travel plug adapter that has every combination imaginable. Also has 2 USB ports in the side. Pretty cheaply built but it works, use it at the moment just for the USB sockets 😀

There’s an app called Greenify. You can select multiple apps that are running all the time then kill their background processes in one go.

Could do some VBA to copy and paste rows to new sheets.

Otherwise I’d add in a new column with row count, add a filter in. Filter in chunks of 500 and copy and paste that way. Probably the quickest way.

Have a look at R. Free opensource stats program, pretty commonly used. A bit of programming knowledge needed. I’m sure there’s tons of resources for it where you can teach yourself.

I’m a data analyst/business analyst (graduate) so only been in the role 10 months now. I mainly use SAS and Excel (VBA) for all of my analytical needs.

I did learn some SPSS at Uni as well but I don’t rate it.

http://www.donotpay.co.uk

Could try giving this a go? I haven’t used it personally but I read about it in the news.

Faucet Inn. Heard they do a good cider… 😆

It’s been a bit iffy for a week. Just have to keep refreshing, I’m listening to it fine at the moment on my phone though.

I’m on Three Sim Only. £10 a month. 200 minutes, unlimited texts and 2GB of Data, switched to them from EE. No complaints at all.

I just graduated Uni last year. Took 3 months off going on holiday, relaxing etc, then I started applying for jobs after I got a bit bored. Started as a business analyst at an industrial gas company in January and the past 8 months has flown by!

I never thought I’d say it but I do enjoy my job, considering it’s the first job I’ve had in my whole life. Company is great, as are the people. Pays well. I guess it can only get worse from here? 😉

+1 Provisional Licence. I got mine when I was 18, lasted me through Uni. Some friends would bring out their passport but it’s a lot more hassle. I’m 22 now and just starting driving lessons so it definitely comes in useful to have anyway!

I like to think I’m at the zoo, just here to sit back and watch the monkeys 😀

Turn off email notifications?

Make a new column with:

=”0″&(your_cell)

Then drag down?

I’ve read users with i5 2500 (3 generations old) and around Nvidia GTX670s able to get good framerates, with settings on medium to high. Having to turn some settings down.

You could insert a button and assign a macro to it to open the document. In the button properties you can set it to do not move with cells. It should stay in place now when the cells are filtered and hidden.

HTH

It works perfectly with Youtube. You have to disable it for 4OD though, and maybe some other streaming sites.

Note: You can add things to a whitelist, so sites like this for example will still get your ad revenue.

There’s a thing called ad *cough* block. Google it…

Not a lot of bass if you listen to any dance or electronic music

Nope, they don’t exist

It was mentioned that some game publishers may impose rules on trading and online passes, which Sony would have no control over. So trading in games etc may cost something.

To play multiplayer on PS4 you will need to have a Playstation Plus subscription. $5 a month, $50 a year 🙁 But it’s the same basis as on the PS3, free games each month and discounts.

Bike related as well 😉

Summary of the reveal 😆

If you want something different than the nextgen consoles have a look at the Oculus Rift[/url].

Sony stock gone up over the past few days. Definitely not to do with the Xbox annoucement 🙂 PS4 will be better 😆

The small insignificant barrel bolt will not stop anyone getting in.

Wasn’t put there by me, I’m not that stupid 8)

Thanks just had a fiddle and I’ve sorted it out.

If you let people connect to your router, you can connect to everyone elses.

Alkaline Trio – The American Scream

I brought a small 500ml bottle of pure squash to mix into my water since I got bored of the taste, or it tasted bad.

Cereal bars are the way, brought loads of them, lots of variety as well.

That’s about it for Bronze, once he gets to Silver/Gold then you’ll need to think a bit harder for what to bring.

10/10 would read again

League of Legends here as well, played quite a bit over the past year.