bio  website  

location  
age  24  
visits  member for  3 years, 3 months 
seen  Jul 22 at 10:49  
stats  profile views  633 
Web/print designer with an affinity for coffee, bubblewrap and Pokemon.
I don't fancy myself an academic nor an Excel guru. I just happen to really like Excel and use it for virtually almost anything.
Oh and I'm exactly 0.955224 smoots tall.
Mar 21 
answered  How to conditionally create a hyperlink based on value of a cell 
Mar 21 
revised 
How to conditionally create a hyperlink based on value of a cell
replicated problem & provided screenshot 
Mar 21 
comment 
Keyboard Shortcut to Fit Column Width to Text in Mac Excel?
I don't have my Macbook with me so I can't confirm if this is possible, but have you tried assigning a custom keyboard shortcut to it? I believe Autofit Column Width should be under Format. 
Mar 21 
revised 
IF statement in excel
added other steps 
Mar 21 
answered  IF statement in excel 
Mar 21 
revised 
Excel formula for finding the position of value
added info about ties 
Mar 21 
revised 
Excel formula for finding the position of value
added additional info for updated question 
Mar 21 
comment 
Excel formula for finding the position of value
@fox I'm not sure what you mean. Can you provide a screenshot? If you're dealing with noncontiguous cells, you can create a named range. 
Mar 21 
answered  Excel formula for finding the position of value 
Mar 21 
answered  Embedding an Excel attachment in Evernote 
Mar 21 
comment 
convert a table of 3 columns of {x, y, value} to the matrix table
It does work & I can't imagine how you could fail to make it. However, you're probably running an older version of Excel. IFERROR only works in MS Excel 2007 & above.

Mar 21 
revised 
Excel CSV import treating quoted strings of numbers as numeric values, not strings
added advantage 
Mar 21 
revised 
convert a table of 3 columns of {x, y, value} to the matrix table
minor change, explained parts of formula 
Mar 21 
answered  convert a table of 3 columns of {x, y, value} to the matrix table 
Mar 20 
answered  Excel 2010  VLookup, Search and Match are doing things beyond my imagination 
Mar 20 
reviewed  Leave Open How to stream video and music over LAN? 
Mar 19 
revised 
change link cell formula across sheets
reverted filename 
Mar 19 
comment 
Excel CSV import treating quoted strings of numbers as numeric values, not strings
There is another way, but I don't know if it's possible in your case: have the web app export to commadelimited .TXT instead of .CSV (or just change the file extension of the exported file). This sort of "forces" users to go through the import wizard when they open the file.

Mar 19 
answered  Excel CSV import treating quoted strings of numbers as numeric values, not strings 
Mar 19 
revised 
change link cell formula across sheets
reformatted for clarity 