672 reputation
1513
bio website
location Seattle, WA
age 32
visits member for 5 years, 2 months
seen Nov 12 at 21:56

Jan
24
answered Excel 97-2003 Macro does not work in Excel 2013
Jan
23
suggested approved edit on Excel 97-2003 Macro does not work in Excel 2013
Jan
22
comment Check value is numeric and no more than n digits
OP stated digits. Hence my response. And even if it was characters, since we are dealing with numbers, it is more reliable to validate within a range (unless you need to limit the numbers after the decimal point).
Jan
21
answered Check value is numeric and no more than n digits
Jan
20
answered Using VBA to name a cell name box in Excel
Jan
8
answered EXCEL: Lookup a value and the minimum date
Jan
8
comment EXCEL: Lookup a value and the minimum date
You actually can with Array formulas. His application may not work here, but it is possible.
Jan
8
awarded  Popular Question
Jan
7
comment Splitting an excel 2010 spreadsheet into multiple workbook files based on column value
It will require a lot of VBA. Seems like if you are going to invest the time to do this, it may be better to convert the whole thing to a Database. Easier to grow (or stay large with >280k records already) and easier to maintain and send reports from.
Jan
3
comment How do I sum across a list of columns defined in an extra column or cell in excel
This is a great solution for your situation @darasd. The only issue with your requirements is that you can't sum based on color without VBA.
Jan
3
comment Is it possible to put a spreadsheet in Thunderbird templates that will calculate?
Seems like you should be doing all the heavy lifting in Excel then copying and pasting what you need into an email body. There is no way (that I know of) to embed a working Excel object into the body of an email (outlook, gmail, thunderbird, or otherwise).
Jan
3
answered Excel 2010 refresh advanced filter
Jan
2
comment excel equation to find corresponding value
Good catch @Scott. I've edited to swap them around.
Jan
2
revised excel equation to find corresponding value
Swapped the columns to match OP request.
Dec
31
answered Is it possible to copy a worksheet so that worksheet references are transfered relatively to the new workskeet?
Dec
31
answered Why is that sometimes the excel goal seek doesn't stop exactly at zero
Dec
31
comment Conditional filter in excel
Try recording a macro of you doing this using the filter in E6. Then try modifying the macro to use B1. THEN post here with specific issues you are facing.
Dec
27
comment How to convert two columns into one column of CSV?
Try opening your CSV file in notepad. Does that show the data how you are expecting?
Dec
27
comment How do I tell MS Excel to use the non-standard decimal separator in graphs and charts?
I don't think that custom formatting can change decimal separators.
Dec
27
answered excel equation to find corresponding value