bio | website | |
---|---|---|
location | ||
age | ||
visits | member for | 3 years, 3 months |
seen | Jul 11 '14 at 12:16 | |
stats | profile views | 14 |
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. |