Search results

Our Hosted UC solution based on Mitel would be a good choice. https://www.talktalkbusiness.co.uk/products/voice/business-phone-systems/hosted-voice/ Can use physical Mitel IP Phones, softphones etc etc Comes with a centralised corporate directory out of the box, or you can upload your AD...

Spotted the Cliosport sticker on a book in the boot 👍

No. Couldn’t get this working unfortunately Sent from my iPhone using Tapatalk

No I did the CF using “Format only cells that contain” and then “Cell Value” with a less than and more than rule. I’ll look at trying to use the formula options as per your instructions. In terms of the 0 or null, cells in column BC are bringing over a number populated elsewhere within the...

Ok will take a look tomorrow Thanks Sent from my iPhone using Tapatalk

Ok, so I have setup some basic conditional formatting rules as per the below picture The aim of the CF is to highlight a cell in red in column BF if the value is greater or less than what's in column BC - this works fine What I want to do is where yo can see red cells in column BF with a...

Thanks I'll have a look Sent from my iPhone using Tapatalk

Ok :) Well for example, say I want to highlight cells A1:A3 if I've selected or just even by moving over any other cell in row 1 with the cell selector. Then the same for row 2, 3, 4, etc I was just thinking to have cells x1:x3 highlighted by using a red think border or something similar...

Yes the cells could be empty or populated. It's more of a visual thing so when I am in any cell on a given row, three cells of my choosing (within the same row) would be highlight. I'm guessing it's not something that can be done using CF, maybe a VB code which is beyond me haha Sent from my...

Is that not just based on what's in that cell. I can do that no problem. I want it to work when you just select a cell or navigate around cells using the keyboard if that makes sense Sent from my iPhone using Tapatalk

Is it possible to have it so say for example I highlight any cell on a row, certain cells are highlight on the same row. Sent from my iPhone using Tapatalk

Cheers mate, will give it a go :)

What's going to be the easiest way to get the columns populated with the site name and code that changes each time?

Thanks mate, appreciated. Think I need to get my head around it first haha :)

No, Lancaster is done in the example above, what I need is for the ones below Lancaster starting with Medway, so it would be... -- 375 - Medway (which already exists on the sheet) --- 375 - Medway - Survey/WIC Install (new row needed) --- 375 - Medway - Survey Results Uploaded (new row needed)...

Afternoon - I am hoping one of the resident Excel gurus can assist me with the following. I need a way of being able to complete what I want to achieve in bulk rather than doing it all manually - hopefully :smile: I have a list of data, example below, where I need to get the unique site name...

Finally got my Plus 32Gb in Black today, ordered on the 9th before 9am. Loads on the O2 forum still kicking off as the higher capacity models haven't come in. O2's communication and general service on this issue has been appalling.

Amazing work. My ideal job!

1 week in with the Mac Mini as my Plex server and everything runs a treat, no issues with transcoding and access to the server remotely is a great added extra. Also decided to have CouchPotato and SABnzb setup on there as well, so I don't have to have the MBP open all the time - the only down...

Too late now lol. Mac Mini it is :)

Managed to get a 2012 Mac Mini for a decent price so that's my server sorted.

Decided to get a Mac Mini to setup what I want as I've been testing out some features on my MBP such as using Roomie Remote with Plex Home Theatre and it's going to be great :) Trying to get hold of a 2012 model but they still got for decent money.

Plus I already have a 2TB WD MyBook Live now which I use in my current setup so all of the files can stay on there and just get a smaller HDD to run the OS.

Cheers for that. I use to build my own machines a few years back but since preferred my Mac's :D, but it's tempting to look at knocking up a self build just for the fun :D

Yeah I think the NAS may be out of the question now as it's not worth the risk in paying so much and there maybe transcoding issues. I would rather by a Mac Mini for £399.

It seems the App on the Smart TV is able to play back the media file directly as there was little to no CPU usage on my MBP for the PMS.

Ok, so after checking my MBP whilst playing a film via Plex through the Chromecast there is a fair bit of CPU processing resource being used... So yeah, transcoding is very important for my needs :blush:

What I am not clear on is how much actual transcoding is taking (if any) in my current of using Plex. I could be wrong but it seems that my 2 devices (Smart TV and Chromecast) are able to play back the media direct from the storage device, so if this is the case then is there much to worry about...

Yeah I am not sure I want to go down the "full" server route. I am just thinking it would be easier of having the PMS on a 24/7 NAS so I don't have to reply on the MPB. I would ideally only want to spend upto £200 on a NAS (with storage) anyway... if it doesn't cost in then I wont bother and...

I have recently rediscovered the simplicity of using CouchPotato and Plex for my Media streaming and it's great. The only down side is my MBP is the Plex Media Server and needs to be on when I want to fire up a movie either on my Samsung Smart TV using the Plex App or Casting to my Bedroom...