6,237 reputation
1823
bio website teylyn.com
location New Zealand
age
visits member for 3 years, 4 months
seen Mar 24 at 19:41

enter image description here

Microsoft MVP - Excel

twitter: @IngeborgNZ


Oct
1
comment How to bring to front a series in a scattered chart
I edited my answer to include an approach for Excel for Mac
Oct
1
revised How to bring to front a series in a scattered chart
added 908 characters in body
Sep
30
answered Create an “inverse” pivot table
Sep
30
comment How to move the dotted lines while I copy in MS excel 2013
have a look around the internet for disabling animations. There are many, many, many hits for that. Then try the exact opposite of what is suggested. Toggle hardware acceleration for example in the various dialogs and settings.
Sep
30
awarded  Explainer
Sep
29
answered How to move the dotted lines while I copy in MS excel 2013
Sep
28
answered Can't get VLOOKUP working with roster spreadsheet
Sep
28
comment How to bring to front a series in a scattered chart
The chart type does not matter. The screenshot shows a Scatter plot, by the way. It also does not matter if the chart is created with macros. What matters is the order of the series. The lowest series in the dialog will be plotted on top. When the chart is created with macros, create the series you want to see on top as the last series added to the chart.
Sep
28
answered How to bring to front a series in a scattered chart
Sep
28
answered Excel lookup() always returns last value
Sep
28
comment How to move the dotted lines while I copy in MS excel 2013
Could be just a screen rendering issue. Why do you need them to move?
Sep
24
comment How do I edit a Gantt Project Bar Graph in Excel
@Agentleader1, did you finally find some time? I find it a bit strange that you post a question, are happy that people spend time on the answer but then you don't find the time to try it.
Sep
24
comment Given multiple start dates, how to assign counts to relative date values?
I made an edit with a slightly different approach.
Sep
24
revised Given multiple start dates, how to assign counts to relative date values?
added 574 characters in body
Sep
24
awarded  Autobiographer
Sep
24
comment Pivot table with two headers in MS Excel
with the two levels of headers that won't be so easy. You could copy the table underneath again, add a column for the period, quickly fill in the data, remove the now superfluous columns and headers and then you can unpivot.
Sep
24
answered Pivot table with two headers in MS Excel
Sep
24
answered Given multiple start dates, how to assign counts to relative date values?
Sep
24
comment Given multiple start dates, how to assign counts to relative date values?
I don't understand this table. How can a user whose start date is in march have a value for 2014-01, which I presume is January. Or what do the labels in row 1 stand for?
Sep
23
revised Count Unique values based on criteria within 2 columns
format