5,894 reputation
1823
bio website teylyn.com
location New Zealand
age
visits member for 3 years
seen 9 hours ago

enter image description here

Microsoft MVP - Excel

twitter: @IngeborgNZ


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
Sep
23
answered Make formula impossible to find / read
Sep
22
comment Formula to determine available options based on prerequisites
There is no easy way to do this. Even with VBA (although your mileage of "easy" may vary). It is never easy to use formulas or VBA to compensate for bad data architecture.
Sep
16
comment Group Data By Multiple Columns
Please edit your question. Don't assume that everybody knows what a t-test is. Explain what needs to be done with the data and what you want to see as a result. Post an Excel sample file to a file sharing service. Enter the expected results manually. Explain the logic.
Sep
16
answered Excel - Keeping a running total based on a name
Sep
16
comment Group Data By Multiple Columns
cross posted in stackoverflow.com/questions/25858336/… -- please don't post the same question in more than one StackExchange site.