Donate SIGN UP

andyGTBristol

1 to 13 of 13

Avatar Image
andyGTBristol

Excel Formula Help

Hello, I have a spreadsheet in Excel 2010 with due dates in column L, what formula could I use in column M to display an alert when the date is past due / no date is entered. ie due date in cell L4 is...
15:00 Wed 24th Feb 20161 answer, last by Ellipsis 15:05 Wed 24th Feb 2016
Avatar Image
andyGTBristol

Hainault Loop

Do any tube trains do a complete circuit of the Hainault loop now or do you still have to change to get all the way round ?
10:00 Sun 21st Feb 20161 answer, last by Jonathan-Joe 14:37 Sun 21st Feb 2016
Avatar Image
andyGTBristol

Conditional Formatting In Excel Charts

Hi, I am using Excel 2010 and want to create a chart with conditionally formatting that turns the chart background green when the data is above target and red when it is below. There are only two...
14:27 Thu 11th Feb 20165 answers, last by Floyd_P 00:27 Sat 13th Feb 2016
Avatar Image
andyGTBristol

Countif / Sumif In Excel

I have a spreadsheet in Excel and am trying to count the number of issues per dept. that have gone past due. What is the best formula to use ? Depts are in column G and dates in column L Thanks...
12:25 Wed 01st Jul 20152 answers, last by Aquariel 19:33 Wed 01st Jul 2015
Avatar Image
andyGTBristol

Excel Autosum Issues

I have a spreadsheet that I manuallu update with a new tab each week to compile figures, I have an autosum set up to calculate from each sheet and put in to one master, is there a solution that Excel...
08:45 Wed 24th Jun 20152 answers, last by Peter Pedant 21:47 Thu 25th Jun 2015
Avatar Image
andyGTBristol

Count By Icon Colour In Excel

Is there any formula (manual or otherwise) that I can use in Excel to calculate the number of cells that have an icon that is a particular colour in ? I have 3 different coulured icons for people...
13:01 Tue 23rd Jun 20152 answers, last by EdmundD 14:47 Tue 23rd Jun 2015
Avatar Image
andyGTBristol

Paste Link Not Working In Excel 2010

I have a graph in an Excel spreadsheet that updates regularly and I need to paste it as a link so it also updates within another spreadsheet but when I try to use 'Paste Special', the 'Paste Link' is...
20:04 Tue 09th Jun 20151 answer, last by ll_billym 20:41 Tue 09th Jun 2015
Avatar Image
andyGTBristol

Embed A Chart In Excel 2010

Hello, I have a pivot table (with a chart) in one Excel spreadsheet and I need the data to copy in to another spreadsheet that updates at the same time as the original. Is there a way to link the data...
08:03 Wed 03rd Jun 2015
Avatar Image
andyGTBristol

Excel Help

Is there any way to prevent Excel from updating from a source table when the source data is updated, I had a feeling using $ somewhere in the formula would do it, but need to some clarification.
10:55 Sun 31st May 20152 answers, last by honzstgirl23 11:35 Sun 31st May 2015
Avatar Image
andyGTBristol

Datamatch 2 Excel Spreadsheets

Hi, I have two excel spread sheets that I need to data match, the large (master) version is approx. 60000 lines and the second is weekly report with approx. 200 lines, I need to match against name,...
11:09 Sun 30th Mar 2014
Avatar Image
andyGTBristol

Vlookups In Excel

Hi, I have two seperate spreadsheets of data, is possible to run a VLOOKUP from one against the other ? I need to verify an account number and part of a name. Thanks...
10:19 Wed 07th Aug 201311 answers, last by dr b 11:26 Wed 07th Aug 2013
Avatar Image
andyGTBristol

Speadsheets

I have a spread sheet with account numbers (all 16 digits) they have a space every 4, is there an easy formuala I can use to remove spaces and just leave one space after the first four ie 1234...
11:35 Tue 06th Aug 20137 answers, last by andyGTBristol 12:37 Tue 06th Aug 2013
Avatar Image
andyGTBristol

Excel 2010

Hi, Can anyone help me out with formulaes on Excel ? I have a spreadsheet with account number that are in various conatations, they are all 16 digits and I want them all to be 4 digits then a space...
09:05 Tue 06th Aug 20135 answers, last by verndoug 12:21 Sat 10th Aug 2013

1 to 13 of 13