5,244 reputation
1621
bio website teylyn.com
location New Zealand
age
visits member for 2 years, 9 months
seen 3 hours ago

enter image description here

Microsoft MVP - Excel

twitter: @IngeborgNZ


3h
answered Excel: INDEX and array on another sheet
Aug
18
comment summing up numbers when criteria match
I've added a date scenario to my answer.
Aug
18
revised summing up numbers when criteria match
added 89 characters in body
Aug
18
answered summing up numbers when criteria match
Aug
18
answered Excel Vlookup for 2nd, 3rd, 4th or 5th text value, instead of 1st matching value
Aug
18
comment Auto Updating Month Over Month and Year Over Year formulas
With charting, a lot depends on the data layout. You need a dynamic chart. Looking at a formula out of context is useless. You need to show us your data structure. Use a file sharing service and upload a sample, then explain what you want to achieve in context.
Aug
18
answered Finding most repeated names
Aug
14
comment Excel: Count visible cells in table with specific value
Why not use helper columns? They're easy to maintain and can be hidden. And yes, you might need more than one, but what's the problem? At least you (or your successor) will have no problems understanding helper columns in a year's time, whereas a formula with nested Sumproduct/Subtotal/Offset/Search will be harder to understand. If you are worried about performance: The Offset does more harm than a few helper columns. It is volatile and will cause the whole sheet to recalculate on EVERY change.
Aug
14
answered How to switch the “input field” between “formula mode” to “numerical mode”?
Aug
14
answered Excel: Count visible cells in table with specific value
Aug
13
answered Adjacent bar charts with different scalings
Aug
13
comment Excel 2013: Drop down list with date range?
You can enter the list of values directly into the list source field of the data validation dialog, of course. No cells. No mess.
Aug
13
comment Excel 2013: Drop down list with date range?
May I ask why you want to avoid this? It's the easiest way to populate data validation drop-downs. Stick it in a hidden sheet and you're done. Add to the list as required. What would you want as an alternative? A named formula that produces an array of values? VBA?
Aug
12
answered Excel 2013: Drop down list with date range?
Aug
12
comment Excel: Percentages and ranges
What is in J6 and J8? Instead of posting a formula, describe the desired output and the business logic. Post a sample file. Use a file sharing service and post a link.
Aug
10
answered Excel autofill problems
Aug
4
revised Excel chart colours
added 2 characters in body
Aug
4
answered Excel chart colours
Jul
8
answered IN EXCEL, how do you add 2 columns then blank one of the columns without effecting the balance?
Jul
8
answered Delete previous word in Excel