755 reputation
520
bio website dudewheysmehblog.blogspot.com
location Pittsburgh, PA
age 29
visits member for 2 years, 6 months
seen yesterday

Pursuing my MBA/MSE at Carnegie Mellon University (Dec 2014 grad date) & interned in PwC's IT Strategy and Enterprise Architecture practice (Summer 2013). Before my Masters, I was a Software QA Tester with a dual Bachelors in Business Management and Economics. Aside from work and study, I dabble in Music, Philosophy, Games, and other random interesting things.


May
29
comment Formula in Excel graph
This most likely isn't going to work the way you want it to as your range will probably evaluate to a single number. Check this out: How to Divide a Range by a Range
May
29
comment cross page excel forumlas
Thank you, LordZardeck!
May
27
comment Too much text for an Excel cell — how to make the cell scrollable
As far as my testing has shown, no. It's just a text box that sits on top of the worksheet. It can link to one other cell (via the LinkedCell property), so using this, like @sinni800 said, you can put the same value in the cell behind it, and use that in formulas and computation.
May
27
answered Too much text for an Excel cell — how to make the cell scrollable
May
23
awarded  Scholar
May
23
accepted How to check data with SHA1?
May
23
comment Excel: Exporting Formula to other languages?
This might help, from StackOverflow - Convert Spreadsheet Formulas to Java.
May
21
comment How to find specific phrases in unspecified locations and add to new column on MS Excel
I would suggest doing some manual preparation before hand to have the data, less sparse and more organized. If you can, try to get all of the email addresses to the same column. Then use Data Validation > Text to Columns, with : as the delimiter. It will return only the email addresses without the prefix email:.
May
14
answered How to check data with SHA1?
May
14
revised How to check data with SHA1?
Tried to limit the scope of the question and be specific.
May
14
comment How to check data with SHA1?
@whoever is downvoting: Can you please tell me why so I can fix the question?
May
14
asked How to check data with SHA1?
May
10
answered How can I check to see if a group of cells in an Excel spreadsheet have equivalent relative formulas?
May
8
awarded  Vox Populi
May
8
awarded  Suffrage
May
4
revised Autofill a Cell in Microsoft Excel
Fixed title
May
4
suggested suggested edit on Autofill a Cell in Microsoft Excel
May
4
answered Autofill a Cell in Microsoft Excel
May
3
comment Outlook archive like Gmail
This solution will require you to run a macro and it will archive all the mails from the inbox: [answers.microsoft.com/en-us/office/forum/office_2010-customize/…
May
3
answered Shortcut in Word or Excel for Special Paste?