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

enter image description here

Microsoft MVP - Excel

twitter: @IngeborgNZ


Apr
28
answered Excel - Problems with Vlookup
Apr
27
answered Matching grades to names in separate sheets
Apr
27
comment Excel - Problems with Vlookup
Why then did you select this answer as the solution? It clearly does not present the solution to your problem. In fact, the suggestion of this answer is pure nonsense.
Apr
24
comment MS Word Mail Merge: Validate Data
Wouldn't it make more sense to check the data quality at the data source, i.e. in Excel, before even starting to use the workbook in the mail merge?
Apr
22
comment Custom Data Validation in Excel 2010
Good luck with your question. Some further explanation would help, but it's up to you.
Apr
22
comment Custom Data Validation in Excel 2010
How can you add your name as a number? Let's say your name is Alex. How would you enter your name Alex as a number? That just does not make sense. Your question does not make sense. Don't abuse the people who are trying to help you. Reflect and get your premises right. You need to define your outcomes a lot more clearly. "Enter names as a number" does not cut it. What do you need? Allow only alpha character? Allow only numeric characters? Allow letters and numbers but not symbols like +_)(*&^%$$# -- be specific. As it stands right now, nobody knows what you really need. Define it.
Apr
22
comment Custom Data Validation in Excel 2010
Please provide a few examples of what is allowed and what is not allowed. How can someone enter their name as a number? That does not make sense. Provide some real examples. What are the columns? What is the expected input?
Apr
13
comment In Visio, how do I create a chart with coordinates throughtout time
@dav, I hope you're not an architect or builder. The door should be hinged on the other side. It should open up into the room, not into the wall. I see this mistake in many cheap housing projects.
Apr
11
comment In Visio, how do I create a chart with coordinates throughtout time
Where does the data come from? Why Visio? This would be a piece of cake with Excel. You could embed the Excel chart into Visio.
Apr
7
comment Why doesn't isformula() work on Excel 2011 for OS X?
I added some more to the answer.
Apr
7
revised Why doesn't isformula() work on Excel 2011 for OS X?
added 818 characters in body
Apr
7
answered Why doesn't isformula() work on Excel 2011 for OS X?
Apr
6
comment How to split a Excel file with excel Macro
If you don't know what you are writing about, please skip the question and move on to something that you have some expertise in.
Apr
5
comment How to split a Excel file with excel Macro
Tools menu? Really? What if the OP uses a currently supported version of Excel? In the last seven years, no new Excel version has had a Tools menu.
Mar
27
reviewed Reject suggested edit on Transparent regions of pasted png display as black in Inkscape
Mar
27
reviewed Reject suggested edit on Windows 7 Ready to use system image
Mar
27
reviewed Reject suggested edit on Is there an application or some other method that would update Chromium in Windows?
Mar
24
reviewed Approve suggested edit on py2app install error on Mac OS X mavericks
Mar
24
reviewed Approve suggested edit on Can't run localhost PHP server on OSX Mavericks
Mar
21
answered VBA macros “deleted” after closing excel file