936 reputation
211
bio website tduhameau.wordpress.com
location California
age 37
visits member for 1 year, 11 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/


Jul
24
awarded  Nice Answer
May
6
awarded  Constituent
Apr
29
awarded  Caucus
Dec
5
answered Excel Using Reference for Worksheet names
Nov
20
answered Excel formula to convert “Today, 10:18:03 AM” or “Tuesday, May 14, 2013 12:06:36 PM” to Excel date
Nov
20
answered How to rearrange data from a set of columns to another set of columns
Sep
25
awarded  Yearling
Sep
21
answered Is it possible to “unpivot” or “reverse pivot” in Excel?
Mar
14
comment Excel combining INDEX and MATCH
+1, the route I chose not to take.
Mar
14
comment Excel combining INDEX and MATCH
@PeterAlbert: 1)it should only be $B if I didn't offset the column, 2)the question is working on French or other regional settings with semi-columns, so I stuck with that presentation.
Mar
14
answered Excel combining INDEX and MATCH
Nov
28
answered Trying to put up a one liner in Excel
Nov
28
comment Trying to put up a one liner in Excel
where are the As stored?
Nov
28
comment Attendance marking in Excel
so you can only have one present at a time?
Nov
28
answered Attendance marking in Excel
Nov
13
answered Excel Condition
Nov
7
comment Named Ranges, Cell References and Validation
You have quite a few questions that haven't been closed. Have you really not gotten a good answer out of any? If you did, try accepting the correct answers, this will help you get answers in the long run.
Nov
7
answered Named Ranges, Cell References and Validation
Nov
6
comment Microsoft Excel Price Formula
The first option will change the way the number looks without changing the value, the second will change the actual value.
Nov
2
comment Is it possible to rope pictures in Excel
I usually use it to offset complicated selections rather than reselect