5,039 reputation
1621
bio website teylyn.com
location New Zealand
age
visits member for 2 years, 7 months
seen yesterday

enter image description here

Microsoft MVP - Excel

twitter: @IngeborgNZ


May
19
comment Toggled Hyperlink with If:Then formula
Just use the hyperlink cell style. You can then use conditional formatting to remove the color and underline when the cell shows '(NOT IN USE)'. Excel does not apply the hyperlink formatting unless it recognizes that the cell contains a hyperlink. Nesting the Hyperlink() function within an IF() function obscures this recognition.
May
18
answered Toggled Hyperlink with If:Then formula
May
18
answered Select cells based on other column
May
6
awarded  Constituent
May
6
reviewed Approve suggested edit on .exe is not a valid Win32 application?
May
6
reviewed Approve suggested edit on Is there anyway to move a partition on the outer platter of the disk closer to the inner spindle?
May
6
reviewed Approve suggested edit on Partition and not booting
May
6
reviewed Approve suggested edit on Uninstall Homebrew completely, which isn't located at the standard /usr/local location
May
6
reviewed Approve suggested edit on Aligning numbers in Table of Contents in Microsoft Word
May
5
answered Conditional formatting in Excel 2013 for C8=blue and bold if C5>C2
May
1
comment Reformat data through macro excel 2010?
I said that this code is based on your screenshot data sample and that you need to adjust it.
May
1
answered Reformat data through macro excel 2010?
May
1
reviewed Edit suggested edit on Reformat data through macro excel 2010?
May
1
revised Reformat data through macro excel 2010?
Include images
Apr
30
comment How to get excel to auto-outline hierarchy into groups?
If you don't want to subtotal any numbers, that is, if you want the grouping just so you can collapse certain sections, then you need to apply the grouping manually. The grouping function is severely lacking, IMHO. Maybe Excel is not the right tool for what you would like to achieve.
Apr
30
answered How to get excel to auto-outline hierarchy into groups?
Apr
29
comment Excel: how do I insert changing cell values in my sum?
Please post a screenshot or a sample file and mock up a few scenarios. Your explanation is hard to grasp. What does where A1 is x mean, especially since you say that A1 is always 0.8?
Apr
29
awarded  Caucus
Apr
28
revised Excel - Problems with Vlookup
added 344 characters in body
Apr
28
comment Excel - Problems with Vlookup
An answer should only be selected if it answers the question. You can always add your own answer and accept that as the solution. I've added a write-up of the solution approaches.