Search results

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 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...

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.

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...

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...