Consultant

Hi,   Excel 2013. I am trying to do a scatter chart for the table below. I can plot the values but I want the dots to vary in shape and colour depending …

Sum based on dates?

Hi there, I have created a large spreadsheet and I was wondering if it was possible to create a formula where the value of a cell updates automatically based …

Moving value of cell into another if row contains “x”

hi there,   I have a number of excel price lists I am working on and I need to know the following: How do I move the value of a number of different cells …

Product owner

Hi, Thanks ia dvance for your help. I am looking for a macro/funcntion that does below: Coulmn1 : Has comments that I add in each day Column2 : Maintain the …

easy one but how?

I have 36 months of data and am trying to calculate YTD YOY results. I know =((x-y)/y)*100 will get me a YOY percentage change comparing two months in …

Comparing each month’s daily sales with multiple years as columns

Hi everyone, I’ve been scouring the internet for a solution to this but can’t find exactly what I’m looking for. I have gathered …

Sum multiple columns, one with a variable

Hi I need a formula that will calculate the total of    – all in column C * £35 – all in Column D * £35 – all in Column …

Comparing values of two columns

Hi Guys!    I’ve run into a problem when comparing data values of different columns in excel.  I am trying to compare two data sets to see …

MR

Hi – I have an issue with an INDEX MATCH MATCH formula to sum multiple values based on a less than criteria: Below is the table in question: Cell A1 …