5,522 reputation
21134
bio website
location
age 25
visits member for 3 years, 8 months
seen Oct 27 at 5:50

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.


Apr
9
answered Conditional count
Apr
8
awarded  Yearling
Apr
7
comment Referencing the sheet name is not working
To isolate which part of your formula is causing the error, try typing "=CELL("filename", A1)" into another cell.
Apr
7
revised Referencing the sheet name is not working
added 11 characters in body
Apr
7
revised Referencing the sheet name is not working
edited tags
Apr
7
answered How to lock a formula with self reference?
Apr
6
revised How can I set a keyboard shortcut to switch between Excel tabs?
clarified, added keys
Apr
6
answered How can I set a keyboard shortcut to switch between Excel tabs?
Apr
5
revised Finding values that only appear once in column
added another formula based on OP's clarification
Apr
5
answered Finding values that only appear once in column
Apr
4
reviewed Close Is there a windows console emulator?
Apr
3
comment At exporting table to excel, double numbers are changed as date type
Best practice is to NEVER open CSV files in Excel. You can either import data in the file, or force Excel to go through the Text Import wizard by changing the file extension to TXT.
Apr
3
answered Can Excel automatically adjust cell contents to retain a consecutive pattern?
Apr
3
comment In Excel, how to find the value after decimal and replace entire cell with this new value?
So you wish to round up only values that contain 99, 88 or 77 at the end?
Apr
2
revised Find last row in sorted table for matched value
added corrections to formula
Apr
2
comment Find last row in sorted table for matched value
@Moses Yep, just enter it in the first cell under Last_Match_Date (using Ctrl+Shift+Enter) then copy it down to the other cells. You were getting the error because you replaced A2 (or the lookup value) with another array not parallel to the arrays in the formula.
Apr
1
revised Find last row in sorted table for matched value
added 218 characters in body
Apr
1
answered Find last row in sorted table for matched value
Apr
1
comment Why do I get an #REF! error after sorting?
Are you running Excel 2003 or below?
Apr
1
revised Merge Excel rows from two sheets
OP modified question, had to update answer