5,829 reputation
1723
bio website teylyn.com
location New Zealand
age
visits member for 2 years, 11 months
seen 15 hours ago

enter image description here

Microsoft MVP - Excel

twitter: @IngeborgNZ


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.
Sep
16
comment Excel formula sumarizing items over quarters of year
Can you manually create the expected result? How do you want to handle duplicate dates?
Sep
15
answered How do I edit a Gantt Project Bar Graph in Excel
Sep
14
answered Auto-fill rows from columns in another sheet?
Sep
14
answered How to create up lines in charts in Microsft Excel 2013 for Windows?
Sep
12
answered Conditional Formatting of a column based on values of another column
Sep
11
comment Ignoring value IF “[Value_if_false]”
Your question is not clear. Please edit and include the expected result.
Sep
10
answered Excel 2010 area chart drop off
Sep
10
answered Excel: How to skip specific rows when importing a CSV
Sep
9
comment How do I get an entry to re-show up for auto-completion
The rogue value may be a typo that does not impact the length and causes the value not to appear in the filtered data. Some more ideas added to the post above.
Sep
9
revised How do I get an entry to re-show up for auto-completion
added 520 characters in body
Sep
9
reviewed Approve suggested edit on deshuffling pages imposed in booklet form to sequential single pdf pages
Sep
9
reviewed Approve suggested edit on Pressing 1 key registers 2 keys?
Sep
9
reviewed Approve suggested edit on Right shift key not working with " key
Sep
9
reviewed Reject suggested edit on How to remove addresses from Thunderbird's autocomplete drop-down?
Sep
9
comment How do I get an entry to re-show up for auto-completion
I added some details to the answer.
Sep
9
revised How do I get an entry to re-show up for auto-completion
added 724 characters in body