4,882 reputation
21130
bio website imagineza.com
location
age 24
visits member for 3 years
seen Feb 26 at 19:22

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
30
reviewed Close Can I add my own books to Kindle for PC and have them sync with my Andoid phone?
Mar
30
reviewed Leave Open Laptop detects HDMI connection but won't display anything
Mar
30
reviewed Leave Open Windows 7 won't open any program
Mar
26
comment How to conditionally create a hyperlink based on value of a cell
@gm2 I think you're misunderstanding the OP's question. Excel is creating a "phantom" hyperlink even if you don't mean to.
Mar
26
reviewed Reject suggested edit on How do I get VLC to play on the second monitor on windows?
Mar
26
reviewed Close How do I prevent vlookup returning 0 for values that are blank in the lookup data?
Mar
26
reviewed Leave Open Restrict Bandwidth by IP
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