1,056 reputation
312
bio website tduhameau.wordpress.com
location California
age 38
visits member for 2 years, 3 months
seen May 12 at 17:35

I work with Excel all day, trying to learn and teach as much as I can.

I've recently started a blog where I write about the ways I use Excel to make my job easier. Check it out at http://tduhameau.wordpress.com/


Oct
24
comment Locking cell range in Excel
this locks the cells but it doesn't change the display as in the screenshot.
Oct
24
answered Locking cell range in Excel
Oct
23
comment Extracting Data Between two Characters in Excel
if you do this, use >* if you can have data after >
Oct
23
comment Extracting Data Between two Characters in Excel
@DougGlancy Edit done.
Oct
23
comment Extracting Data Between two Characters in Excel
do you want to do this with a formula or with a macro?
Oct
23
answered Extracting Data Between two Characters in Excel
Oct
22
answered Automation for filling in sets of numbers in each row
Oct
16
comment Efficient approach of selecting large amount of rows in an Excel file
Why do you need to select them anyway?
Oct
11
answered Copy text value and formatting to another cell
Oct
11
answered How to identify cells in Column A that contain any of the values in Column B
Oct
11
revised Excel formula to calculate power of
added 57 characters in body
Oct
11
answered Excel formula to calculate power of
Oct
10
comment How to filter source sheet in Excel pivot table drill down?
It's working fine for me on Windows 7 Pro SP1, Excel 2010 32 bit.
Oct
9
revised Is there a way to disable “top left click switches to metro app” behaviour in Windows 8?
minor change for validation
Oct
9
suggested approved edit on Is there a way to disable “top left click switches to metro app” behaviour in Windows 8?
Oct
9
awarded  Commentator
Oct
9
comment “Cannot group that selection” error when creating pivot table
+1 on Adam's comment. I've had the same experience in the past, come to think of it.
Oct
8
answered “Cannot group that selection” error when creating pivot table
Oct
6
answered Collapsing rows of duplicate dates in a column leaving one row with a subtotal?
Oct
5
revised Get list of all installed software in each Virtual Machine
Simplified question and clarified formatting