|
Error: "ran out of resources" running 5,000 row array
I'm using an array formula to calculate the Gini coefficient of
columns of data. I'm getting the 'Excel ran out of resources' message
on any array more than 5,000 or so rows, which seems very low to me.
I'm using Excel 2007 and have 3 GB of RAM, so it's not clear where the
problem is.
Does anyone know of a fix for this? Either a way to free more
resources, or to calculate Gini coefficients...
|
2 |
12/31/2008 5:24:03 PM |
|
|
Deposit slip?
I want to print deposit slips from a spreadsheet. I don't find any
templates or samples. I can make my own except for the special font
and machine codes that the bank and account number are printed in.
Anybody know how to do this?
Thanks...
|
5 |
12/31/2008 5:19:11 PM |
|
|
Multiple IF's in one cell
I would like to find a formula that will allow me to sort/find a name in
several columns of names and if it is one of the columns then indicate which
column heading it was under. I've tried embedded IFs but I have limited
experience with using multiple formulas in one cell.
...
|
3 |
12/31/2008 4:45:05 PM |
|
|
Macro security, how to make it work
We have a spreadsheet that we use in Excel 2003. It's fairly awkward to find
the info that we need on the sheet.
I've since created a couple macros that really work well, but when I have
the macros attached to the spreadsheet, we get error messages about security
and the macros are disabled.
How can we avoid these errors and make the spreadsheet automatically load
the macros enabled,...
|
1 |
12/31/2008 4:24:32 PM |
|
|
Formula to show correct month?
Good morning.
Cells formatted with '=2-WEEKDAY(TODAY())+TODAY()' are showing the
correct day of the month since I used a sum +1 formula for subsequent
days. That seems to do the job.
The cells in the left column of the day of the month that show just
the month using '=TODAY()' are showing "Dec" for yesterday and today,
which is correct, but also show "Dec" for tomorrow and Friday, which...
|
4 |
12/31/2008 4:17:59 PM |
|
|
pushing data from one worksheet to another
Hi,
I am new to VBA. I was given this to try(probably from this forum):
Private Sub Worksheet_Change(ByVal Target As Range)
Set r1 = Range("T2")
Set r2 = Range("AR5:AR47")
If Intersect(Target, r1) Is Nothing Then Exit Sub
dsheet = "sheet2"
Application.EnableEvents = False
r2.Copy Sheets(dsheet).Range("R7:R49")
Application.EnableEvents = True
End Sub
QUESTIONS-
1. This copies the fo...
|
5 |
12/31/2008 3:44:48 PM |
|
|
1st part works; how to get an actual date dumped?
I was able to put together 2 macros and am pleased with results. When
I click on a button that has the macro below assigned to it, it puts
the date for this week's Monday into L2 which shows the beginning of
the week and which then affects all the rest of the dates in the sheet
that are dependent on L2:
**********************************
Sub MondayStartDate()
ActiveSheet.Unprotect
A...
|
6 |
12/31/2008 2:52:23 PM |
|
|
Lookup in two columns for same value
Hi and happy new year to uall,
I have a problem, where I am trying to match a value in one of the
sheets (say 1) to either of the two columns in another sheet (say 2)
and then return the value to Sheet2 from the 3rd column of Sheet 1
Sheet 1:
GM MG 1
JF FJ 2
DM MD 9
JS SJ 6
JM MJ 23
Sheet 2 (Should look like this)
GM 1
MG 1
MJ 23
MD 9
...
|
4 |
12/31/2008 2:28:48 PM |
|
|
Alt+Tab not working
Hi guys, I had the same problem and I got it cleared from a bootup scan with Avast Home Edition. Now its working perfectly. Hope this solves your problem.
Regards
Senthil
EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com...
|
2 |
12/31/2008 1:31:20 PM |
|
|
Parameter query issues, Excel 2003
Hi, I have a table in MS access as the external data source. I want to
add a parameter value, so I Edit the query and add [?] in the value
field. When I run the query it does not prompt me for a value.
However, when I put a valid value straight into the query (where I put
the question mark), it does produce the required result, hence the
query itself should be okay.
Ultimately, I want to cre...
|
5 |
12/31/2008 11:16:42 AM |
|
|
Prada shoes (paypal payment)www.king-trade.cn )
Footwear (paypal payment)www.king-trade.cn )
Paul Smith shoes
Jordan shoes
Bape shoes
Chanel shoes (paypal payment)www.king-trade.cn )
D&G shoes
Dior shoes
ED hardy shoes
Evisu shoes
Fendi shoes (paypal payment)www.king-trade.cn )
Gucci shoes `
Hogan shoes (paypal payment)www.king-trade.cn )
Lv shoes
Prada shoes (paypal payment)www.king-trade.cn )
Timberland shoes
Tous shoes
Ug...
|
2 |
12/31/2008 6:17:01 AM |
|
|
Turn a series of numbers in a cell into specific ranges
I will have on going spreadsheets that will have one column of comma
delimited numbers.- the cell could contain anywhere from 15 - 150 numbers.
What the desired result would be - in a new column is to turn that series of
numbers into ranges or groupings
for instance in my cell if I had
1,2,3,4,5,6,7,8,12,13,14,15,17,18,19,20,21
my new column would contain
1-8,12-15,17-21
Each sp...
|
6 |
12/31/2008 12:43:11 AM |
|
|
Changing relative to absolute cell references in large block of cells
I have a large block of cells set up that I now find I need to move. The
cells were originally set up as relative since I needed to do things like
fill down & right, etc. But now I find I need to move that entire block of
cells to another location, and of course, now the cells are referencing to
cells that don't exist. I need to change the entire block before moving and
I don't see any w...
|
6 |
12/30/2008 9:21:29 PM |
|
|
Filter One Sheet into Many
I would like to create many sheets out of one... I have a dataset which has
a group column, I want to be able to create a sheet for each group in this
column and only have those records displayed on the new sheet and name the
sheet by the group...
Is there a way of doing this?
Regards - Paul
...
|
5 |
12/30/2008 8:55:41 PM |
|
|
VBA + Excel Performance: your feedback requested
Hello all - The Excel development team is currently investigating a number
of scenarios where VBA macros take longer to run in Excel 2007 than in
earlier versions (i.e. Excel 2003).
I am looking for folks who believe they have run into a VBA performance
slowdown and who would be willing to share their code/workbook/steps to
reproduce the issue. Given the enormous variety of solutions p...
|
2 |
12/30/2008 8:37:28 PM |
|
|
Current Monday and future Sunday.
I google the archives and came up with this for the Monday of the
current week, i.e., I start the work week on Mondays and that's how my
time sheets operate. So today being the first day of the work week
which ends the following Sunday, here is what I found for Monday of
the current week:
=2-WEEKDAY(TODAY())+TODAY()
So today the time sheet shows Dec.15 for today, Monday.
How can I ge...
|
6 |
12/30/2008 4:53:58 PM |
|
|
Query using database criterion
I have stored some data in sheet named "Data" in database format with
following headers:
Column Heading Type of data
===== ====== ========
A Supplier_Name Text
B Machine_Model Text
C Table_Length Numeric
D Table_Width Numeric
E ...
|
2 |
12/30/2008 4:52:14 PM |
|
|
Adding a field for county in a table of address info
I want to add a county column in a table with address information. I have a
list of towns for each county but I am not sure how to best indicate which
county that town is included in. I have a list of 700 or so addresses so I
don't have time to just type in county info for each address.
...
|
5 |
12/30/2008 4:39:57 PM |
|
|
Count - If over a certain hour of the day
Hi...
I am hoping someone can help me... I know there must be an easy way to
do this, but I am at a loss.
Any help would be appreciated.
I am using Excel 2003.
I am trying to add the number of times a file runs after a certain
timeframe.
For example:
Column A Column B
1 12/01/2008 1:40 PM
2 12/02/2008 4:52 PM
3 12/03/2008 4:31 PM
4 12/04/2008 3:18 P...
|
10 |
12/30/2008 4:37:18 PM |
|
|
Calculate cell reference
I have the following lookup which is working exactly the way I want:
=VLOOKUP($C$4,Sheet2!$C$2:$M$19,MATCH("1M",Sheet2!$C$1:$M$1,))
The problem is, I need it to change it's lookup based on user input. If the
user types 2 in a certain cell I need this lookup to change to:
=VLOOKUP($C$4,Sheet2!$C$20:$M$37,MATCH("1M",Sheet2!$C$1:$M$1,))
If the user types 3, it needs to change to:
=VL...
|
5 |
12/30/2008 3:21:19 PM |
|
|
Find and Replace
Hi All, Happy New Year to everyone!!! Hey, I have a question: i have a
spreadsheet in which several cells in one row have the sameinformation, let's
say letter "N", as non-paid. the columnsare dates. And also i have columns
with "StartDate" and "EndDate". like for example, an employee has "N"
(non-paid) days from 9/1/08 through 9/15/08, but after the research the first
2 days are paid. ...
|
5 |
12/30/2008 2:42:09 PM |
|
|
Joining some conditions
I have several IF statements that I'd like to join into just one.
(I use row 10 as an example)
=IF(LEFT(B10,1)="A",I10-0.01,J10)
=IF(OR(C10="BOG",C10="BLM"),I10-0.01,J10)
=IF(LEFT(B10,1)="W",I10-0.01,J10)
=IF(FIND("SHORT",G10)>0,I10-0.01,J10)
=IF(LEFT(B10,1)="F",I10-0.01,J10)
=IF(LEFT(B10,1)="U",I10-0.01,J10)
=IF(LEFT(B10,1)="Y",I10-0.01,J10)
Basically checking the values of column...
|
3 |
12/30/2008 1:09:09 PM |
|
|
Compatibility mode won't stay off
My company has moved over to Office 2007 almost completely. By
default I would prefer to open a new spreadsheet and save spreadsheets
in Office 2007 format .xlsx. I clicked the ribbon, clicked Options,
clicked Save, and changed it to Excel Workbook (*.xlsx), then clicked
OK. But when I close Excel and reopen it the new spreadsheet is in
Compatibility mode again. When I check that setting ...
|
4 |
12/30/2008 8:41:00 AM |
|
|
Find the last, 2nd last and 3rd last data in a column
I have data listed in several colums and need to create a formula to
detail the last (most recent) 2nd last and 3rd last piece of data in
the column.
I have used the following formula to display the last but cant edit
this or create another formula to get the 2nd and 3rd last pieces of
data.
=LOOKUP(2,1/(A:A<>0),A:A)
Thanks in advance
Jamie...
|
4 |
12/29/2008 11:45:07 PM |
|
|
Pivot chart
I am working with Excel 2007 trying to create a chart. When creating the
line chart within a pivot table, the pivot chart is putting the data that
needs to be in the horizontal axis in the legend series. I would like it to
be switched. The button to switch these items is grayed out. Why is that? If
I just created the data in the Excel spreadsheet (not using a pivot table),
it is not gray...
|
2 |
12/29/2008 8:59:03 PM |