Search results

That worked, thank you so much that is a huge help!

Hello, I am an administrator working with excel on a regular basis at an itermediate level but am at times baffled by a particular problem with excel! I would sincerely like some help with the uploaded file. I am trying to create an hours worked spreadsheet in 24 hour time, and have created...

Hi Jason and Luke, Yes, if it was 1.30am on a Saturday it was actually a Friday night shift and if it was 2.45am on a Saturday night shift it would have been logged as Sunday. Hope that clarifies a bit. Thank you for your help.

Hi bit of a humdinger of a problem here. I oversee a project that runs shifts on a Friday and Saturday night from 21.00hrs to 03.00hrs. I have information on who visited the project for every shift logged in a spreadsheet with part of the columns logging day, date and time. The day is...

I am trying to run an if formula on a range of cells. I am trying to write a formula that would work like - IF(B4:B23="*ds*","","No DS")so if the letters ds are present in the selected range of cells it will return a blank or a 'No DS' accordingly, but the formula as I am attempting to write it...

Thank you!

I want to use a simple sumif formula to sum the numbers in one column based on if it says 'August' or 'September' in another. I've tried sumif(c:c,a:a="August") but this doesn't work, where am i going wrong please? Thank you.

I thought that might be the case. I have a number of pie charts on a number of pages as opposed to a lot of data in one pie chart. I'll see how far I can get changing the text size. Thank you.

Hi LukeM, Thank you for your help I'll see what I can do with your suggestions, do appreciate you having a look at it. Regards.

Does anyone know how to format or resize the category name data labels on a pie chart so that the text is not splitting words. I can't 'grab' the corner of the boxes to resize them to get the text to fit. I know I can replace the data labels with text boxes but there's a lot of them. Any...

That works brilliantly, thank you!!

I know I may be asking for something that cannot be done here! I am reading information from a set of cells in one spreadsheet into another to create a table and pie chart from a summary sheet, I am using ='Feedback sheet summary'!E$2 to 'read' the first cell from the orginal sheet, into a...

I am using a feedback form that asks for three positive and three negative comments and I am logging these in a column, I am trying to flag up where repeated words or phrases come up, for example - 'air conditioning' or 'car parking' within these comments so that when the conferencing manager...

Hello, When dragging formulas into adjacent cells the formula automatically 'counts up' as you drag horizontally across, does anyone know how to get this to work when dragging a formula vertically down please? An answer to this would save me so much time as I am manully changing formulas on...

Hello, I am looking for a formula that can find and count repeated matching text in a column, whilst weeding out text like 'a' or 'the'. I am logging feedback comments from forms and want to be able to find a way of flagging up repeated words/comments that are coming up. I've tried using...