5,699 reputation
1723
bio website teylyn.com
location New Zealand
age
visits member for 2 years, 10 months
seen yesterday

enter image description here

Microsoft MVP - Excel

twitter: @IngeborgNZ


Oct
14
reviewed Approve suggested edit on Random Sampling in Excel based on specific criteria from other colums
Oct
9
answered Excel 2013 scatter plot
Oct
8
answered Copying worksheets in Excel
Oct
8
comment How do I get image hyperlink in text?
Post a sample file and explain in context. What do you have where?? Hyperlinks on what? Have you copied web page content and pasted it into Excel as html? And now you want to extract the URLs for the images? Please understand that we cannot see your screen. You really, really need to explain properly what you need.
Oct
8
answered Use data from a drop down list to populate table
Oct
7
answered Is it possible to make a pivot chart a subset of pivot table?
Oct
7
answered Can Excel 2010 Cell Formula Reference Another Cell For A Portion Of The First Formula?
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.