Reputation
6,743
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 20 41
Newest
 Yearling
Impact
~2.5m people reached

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
Apr
1
comment Merge Excel rows from two sheets
@Khaloymes Edit your question with methods/formulas that you have already tried.
Apr
1
answered Merge Excel rows from two sheets
Apr
1
answered Is there a way to automate cell merging in excel?