Reputation
5,892
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 15 36
Newest
 Yearling
Impact
~1.5m people reached

Mar
25
reviewed Close Windows 7 x64 4GB ram use only 3.1 GB like x86
Mar
25
answered Excel, how to only sum cells with a value
Mar
25
answered Copy multiple cells from one to multiple worksheets
Mar
24
reviewed Leave Open How to define two multi-level headings styles in a same document?
Mar
24
reviewed Leave Open Import comma delimited numerical data from web
Mar
23
comment Embedding an Excel attachment in Evernote
@Dane So far, at least with Evernote, you're going to have to drop/reattach the file every time you want to make changes.
Mar
23
revised How can I get the hex value of an 8 row column with depending on background color?
added new formula
Mar
23
answered How can I get the hex value of an 8 row column with depending on background color?
Mar
22
reviewed Close How to stop the “Close fullscreen with ESC” popup window in videos?
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.