Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Solved
Timestamp in Excel 2003
Posted on 2011-02-15
Experts - I need your advice?
I have a timestamp problem. This formula:
=IF(A1<>"",IF(B1="Date/Tim
works for me. However, the formula must be populated throughtout column B to accomodate scan data entered into column A. With worksheets added for each day and hundreds of lines used in each worksheet, I reach Excel 2003 size restrictions.
Can I create or move the formula in column B down one row as I go? Can I do this with a formula instead of a macro?
Gary - Cincinnati
I have a timestamp problem. This formula:
=IF(A1<>"",IF(B1="Date/Tim
works for me. However, the formula must be populated throughtout column B to accomodate scan data entered into column A. With worksheets added for each day and hundreds of lines used in each worksheet, I reach Excel 2003 size restrictions.
Can I create or move the formula in column B down one row as I go? Can I do this with a formula instead of a macro?
Gary - Cincinnati
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
3
7 Comments
Formulas are fixed parts of cells and must be there for them to function.
To dynamically add formulas, you will need VBA.
BTW
If you move up to Word 2007/2010 (as scary as it is) the limit on the number of rows changes form 64K to about 1 million rows, which might help a bit.
To dynamically add formulas, you will need VBA.
BTW
If you move up to Word 2007/2010 (as scary as it is) the limit on the number of rows changes form 64K to about 1 million rows, which might help a bit.
Sorry for asking but what r u trying to acheive ? when move the formula to B. I maybe slow but did not understand your problem expect that it is obvious that you are reaching limitss and in this case nothing but the solution of 'More Limit' like rspahitz suggested could help you.
If you state clearly what is the problem then maybe we could help. Finally why not VBA ??
gowflow
If you state clearly what is the problem then maybe we could help. Finally why not VBA ??
gowflow
Turns out the reason my worksheets were growing so large was due to some formatting issue with my Master worksheet. First I tested how much capacity I was using with the data I was adding -- this was not an issue. Then I noticed the large size of my empty Master. By clicking Cntrl-End I detected that I was using the whole worksheet!! Then, by replicating this Master I quickly reached Excel 2003 limits.
I learned a lot through this issue. With your help I was able to save my design project from disaster.
Thanks for the prompt reply. I feel confident having you guys to back me up.
Gary
I learned a lot through this issue. With your help I was able to save my design project from disaster.
Thanks for the prompt reply. I feel confident having you guys to back me up.
Gary
Glad you found the answer. Excel has a lot of weird things like that, where it doesn't necessarily handle things in an optimal way (like formatting things in entire blocks) and the results can be mysterious (like large file size even if only one cell has a formula in it.)
Just one more tip, maybe not related: to get to what Excel thinks is the end of the spreadsheet (excluding formatting), use Ctrl+G then click on the Special button, the select Last Cell.
Just one more tip, maybe not related: to get to what Excel thinks is the end of the spreadsheet (excluding formatting), use Ctrl+G then click on the Special button, the select Last Cell.
Featured Post
Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Do you use a spreadsheet like Microsoft's Excel? Have you ever wanted to link out to a non excel file on your computer or network drive? This is the way I found to do it!
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
Suggested Courses
Course of the Month10 days, 8 hours left to enroll
719 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.