5,117 reputation
21130
bio website
location
age 24
visits member for 3 years, 3 months
seen Jul 22 at 10:49

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 non-contiguous 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 comma-delimited .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