597 reputation
1513
bio website excelninja.blogspot.com
location Washington, DC
age 32
visits member for 4 years, 9 months
seen Jul 3 at 17:51

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
Dec
27
answered Excel Number Formatting - not to be carried into copied cell
Dec
27
answered Grouping Excel graph categories
Dec
18
comment Why Excel doesn't ask(prompt) to Save the file which is modified while closing
I have a feeling it got downvoted because you failed to mention in the question that you had code at all, let alone code that got rid of alerts. Or, that it may be a duplicate as indicated by another comment on your question. Always going to get downvotes if there are other questions out there with answers. Part of the SuperUser experience is that people really like those who have done homework and ask specific questions rather than present very vague issues.