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

enter image description here

Microsoft MVP - Excel

twitter: @IngeborgNZ


Dec
18
comment Excel formula to calculate the total time spent on various tasks
Mock up the desired result in your spreadsheet. Enter the numbers manually. Take a screenshot. Upload that to a free file sharing site, since you cannot yet post images. Post the link here.
Dec
12
comment Adding Index to Match formula
The last G:G is the column where the Match function looks for a match to the value of the Max function. Match(what,where,0). The "what" is your Max function. The "Where" is G:G. That will return a number. This number is then fed to Index(A:A, number)
Dec
12
answered How To Autofill (Using VBA) Until Adjacent Cell Equals a Particular Value
Dec
12
answered Adding Index to Match formula
Dec
9
revised Capturing Text from Pivot Table
added 61 characters in body
Dec
9
answered Capturing Text from Pivot Table
Dec
9
answered How can I write-protect a worksheet, while permitting link jumping to another worksheet to enter comments?
Dec
9
comment Capturing Text from Pivot Table
Be creative. Use a file sharing site. Post a link. If the computer says that you can't post a link, just post the url as text. Some people here will be able to copy and paste that into the address bar of their browser.
Dec
9
comment Capturing Text from Pivot Table
Can you mock up what you would like to see and post a screen shot? It is not clear what you want to achieve.
Dec
7
answered Change background color of rows which are present in another column
Dec
3
answered Excel Pivot: make 1-dimensonal data 2-dimensional
Dec
1
awarded  Yearling
Dec
1
comment Finding the right graph to display inter-department connections
@dav If somebody asks what the best software is to do tabular calculation, one possible answer would be that it's Microsoft Excel and a link to where it can be downloaded. This answer is the same concept. You wouldn't expect me to provide the Excel source code and I don't think I need to provide the code for this tool to make this a valid answer. Yes, it contains a link to the tool, but it also shows what the product is called, what it does and who created it. That's not a link-only answer.
Nov
27
comment Specific sequential numbering in excel 2010
You could mark this as the answer, then, right? So others will find it too.
Nov
27
answered Specific sequential numbering in excel 2010
Nov
26
answered Finding the right graph to display inter-department connections
Nov
21
comment IF and then condtional format
please mark the answer, so others can find it.
Nov
21
comment Excel Fill from another sheet
You're funny. Thanks for the rep.
Nov
21
answered Excel Fill from another sheet
Nov
21
answered IF and then condtional format