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

Aug
12
revised Excel 2007: Filtering out rows in a table based on a list
added 127 characters in body
Aug
12
revised Excel 2007: Filtering out rows in a table based on a list
added 355 characters in body
Aug
12
comment Excel 2007: Filtering out rows in a table based on a list
Updated my answer. Sorry if the screenies are ugly.
Aug
12
revised Excel 2007: Filtering out rows in a table based on a list
added 355 characters in body
Aug
12
comment Excel 2007: Filtering out rows in a table based on a list
Bah! Imgur ruined the screenie :(
Aug
12
comment How to render some text with given font file?
@flashnode It works for me too, I'm on Win7 Ultimate. Though I had to make sure the path is enclosed in double quotes.
Aug
12
answered Excel 2007: Filtering out rows in a table based on a list
Aug
12
revised How do I prevent VLOOKUP from breaking after I add a column to a named range?
added 725 characters in body
Aug
11
comment How do I prevent VLOOKUP from breaking after I add a column to a named range?
While I was typing out my answer, you had already sent yours. My goal was to show the OP how to use the match function to suit his specific needs. Please feel free to down-vote should my answer be erroneous.
Aug
11
answered How do I prevent VLOOKUP from breaking after I add a column to a named range?
Aug
11
answered How to render some text with given font file?
Aug
11
answered How do I transpose and combine cells in Excel?
Aug
11
revised Excel Conditional Formatting for Cell condition in Range
added 484 characters in body
Aug
11
answered Excel Conditional Formatting for Cell condition in Range
Aug
10
revised Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
added 144 characters in body
Aug
9
revised Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
added 663 characters in body
Aug
9
comment Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
I'll update my answer shortly to help you parse the time string. You'll need to add a space between the time and the AM/PM notation. Then use VALUE to let Excel interpret it as a time.
Aug
9
answered Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
Aug
9
answered Photoshop text spacing issue
Aug
8
revised Split a string in a cell in Excel using numbers as the divider
added 44 characters in body