251 reputation
15
bio website
location
age
visits member for 2 years, 9 months
seen Jul 11 at 12:16

Jul
14
comment Solving a linear equation with excel
The fastest way i can think of would be to solve for y, then have a list of x value (- whatever to + whatever) where the Y value is calculated. ~ y= (29x - 3)/12
Jul
4
comment Find 5 second peak value in Excel
Do you want to be able to enter a single time and get those results, or would you want to have extra columns in the data table ( or a new table) which calculates for each 5 second block?
Feb
14
comment text to column delimiter split at any number
Short of a Vba solution those giant formulas are the way to go for this.
Feb
2
comment need excel files to be opened and maximize and always be opened
The first is possible, you would need to write a script that runs every x minutes (using windows task scheduler) check to see if excel is open, from there you can maximize the window and/or open the file. This is a non trivial programming task.
Jan
27
comment Retrieving the count distribution of groups of cells in Excel 2007
If you are able to modify the original data set you can use remove duplicates to get rid of the repeating entries then use countif to count the uniques
Jan
21
comment Extract items from 1 huge cell in Excel
I think your original comment about text to columns combined with a find formula is a more flexible solution.
Jan
15
comment How to Analyze the Trend of Data In Google Spreadsheet and Excel
I would use a Pivot table.
Jan
8
answered MS Excel 2010 - Multiple PivotTables using the same filter
Jan
6
awarded  Citizen Patrol
Jan
2
comment Excel ran out of resources while attempting to calculate one or more formulas
That much data may be better served by a database in terms of speed (assuming the valuable output information is in the pivot table). But depending on the formula complexity, this approach may require a fair bit of messing around.
Jan
2
comment Excel ran out of resources while attempting to calculate one or more formulas
2 things off the top of my head to check. 1) does the 6gb machine have other programs using more memory? 2) are both excel versions EXACTLY the same (same updates, etc applied)
Dec
26
revised How to paste Excel data as fixed-width text?
removed uneeded step from solution
Dec
26
comment How to paste Excel data as fixed-width text?
Quite right.. last tab not required... i had assumed that the cells would insert additional characters. I will update my answer to fix it
Dec
23
awarded  Yearling
Dec
21
answered How to paste Excel data as fixed-width text?
Dec
21
comment How to paste Excel data as fixed-width text?
i have a possible solution that would involve pasting from one workbook to another workbook (then from the other workbook to wherever you are paste. does that fit with your workflow?
Dec
19
answered Copy/paste filtered column in Excel - error message
Dec
9
answered Conditional formatting with date and time
Dec
9
comment How can I change the default date format?
@RossFabricant you are correct, however excel's default formatting for all cells is general, which means the excel will guess the data type based on what you enter. I don't know of any interface in excel that allows these guesses to be customized.
Dec
9
comment read excel sheet into jagged array
I don't think there is a standard excel function for that (that I know of anyway). For this purpose I've rolled my own according to need.