Free Microsoft Excel 2013 Quick Reference

Make 1 Million Dollars $$$

Dear Internet Friend,

I made over 1Million Dollars my first year with thys system.

If you are at all serious about making money online, this will be the most important letter you've ever lucked onto. Here's why:

I made over $1600 my very first month marketing Online.
I generated over 137,000 Hits to my Site in my Second Month.
I went from over $40,000 in debt to being completely debt free in six months.
Currently, I make up to $1200 a day Online!
Best of all, I have no job!

Visit this site for more information: http://www.argent-argent.net/moneyforlife.html


Post your answer or comment

comments powered by Disqus
Dear Internet Friend,
I have test this system and i make 1 Million dollars/ YEAR

If you are at all serious about making money online, this will be the most important letter you've ever lucked onto. Here's why:
I made over $1600 my very first month marketing Online.
I generated over 137,000 Hits to my Site in my Second Month.
I went from over $40,000 in debt to being completely debt free in six months.
Currently, I make up to $1200 a day Online!
Best of all, I have no job!

There have been four instances where Microsoft has shown Office 12 to the public. Some high-level customers went out to Redmond in August. They showed it at the Professional Developers Conference in September. They showed it at the Publishers Summit in late September, and then again at the MVP Summit in late September. To get in, you had to sign an NDA saying that you wouldn't discuss what you saw. However, some facts about Office 12 have been made public on various Microsoft websites, so I feel pretty safe in talking about these items. (After I wrote this, I went back and noted the public source where someone from Microsoft talked about the feature to make sure I am not treading anywhere that I shouldn't).

1) This is the most substantial new release of Excel since '95 or '97. (Source: my opinion).

2) The grid is expanding to 2^20 rows and 10,000+ columns. The final column is column XFD. The final row is around 1.1 million. (Source: Dave Gainer Weblog)

3) Charting has been completely rewritten. There are not new chart types, but the look and feel of the charts is light-years ahead of the current charts. (Source: Julie Larsen-Green Video on Channel 9)

4) You can now natively create PDF files from all Office applications. (Source: Steve Sinofsky released us from NDA for this one fact and said we could tell about this)

5) Pivot Tables and conditional formatting have been made easier. Conditional Formatting is incredibly powerful now - you can easily create visual views of your data. (Source: Julie Larsen-Green Video). I *love* the Data Bar view as shown here in Dave Gainer's Blog

6) Keyboard-centric people will love that every single option available in the program will now be keyboard accessible. Not half, not most , but every single option. I love the keyboard, I love memorizing keyboard shortcuts for the common things (I even think, Alt-EIJ when I need to edit-fill-justify. It is hard for me not to say, "just Alt-EIJ that range"). And yes - there is a classic mode for people who know the old shortcuts. (Source: Jensen Harris blog)

7) Mouse-centric people will love that a new floating toolbar appears with the stuff usually in the right-click menu. It is the same sort of semi-transparent thing that Outlook 2003 shows when a new e-mail arrives. If you move the mouse towards the toolbar, it becomes solid, otherwise it fades away. I can see that this will be a huge timesaver - all of the good options just a few pixels from the current cell. (Julie Larsen Green Video)

8) They have completely re-thought menus and toolbars. Word 1.0 offered 20 commands. Excel 2003 has 350 commands. There is no way to effectively layer 350 commands on 9 menu options - people can not find what they are looking for. The new user interface is called "The Ribbon". It is context-sensitive like the current right-click menus. Instead of tiny toolbar icons, it has big buttons and words. The most powerful things are very evident in The Ribbon. For a lot of people blogging about the release, they all seem to have heartburn that there is not a "classic" view that will bring back the old menu system. I initially thought this was insane. However, after seeing it first-hand for a couple of days, I really think that this is a vast improvement. I think this is a small hurdle, it will annoy me for 2 days, but once I get past it, then I have the full power of 1.1 million rows and more power to analyze data with Excel. (Source: Jensen Harris blog)

9) In the MVP Excel breakout session, they showed some other features that have not been shown elsewhere. There are some gems in here, just in case #2, #3, #4, and #5 weren't enough. As soon as Dave Gainer talks about them, I will bring them up.

My take... a lot of people are still using Excel 97 or Excel 2000 and this is fine because Microsoft had not added much new stuff since Excel 97. It made it great as an author, because a screen shot from Excel 2003 looked almost like the screen shot from Excel 97 - you could write about seven years of Office releases with one book.

However, I think that this version has so much good stuff - it will be very very compelling for people to upgrade. I was talking with a casual Excel user last night, and just that day, he had been burned by the 65,536 row limit. Other people want more than 3 conditional formatting. It will be easier for regular people to find the powerful features that are currently buried.

The "gotcha" that I can see - upgrading needs to be an all-or-nothing thing for a company. If you have Excel 12 and have 350,000 rows of data and some of your co-workers are still on Excel 2000 - you won't be able to share that data.

Anyway - I've started this post for us to discuss the changes. If you hear of a new feature, feel free to post about it here.

Bill

"ATTENTION Entrepreneurs: Millionaire Retires and Gives His Multi-Million Dollar Business Formula To You" You'll even get a copy of his million dollar website by
visiting
www.resell-rights-make-money-online.com

P.S. Only the first 52 people to visit the website will be accepted.

---
MAF Anti-Spam ID: 20060719221729Z2h0PvD7

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

Mediocre user struggling with this one!
My task is to make 1 cell react to inputs in 3 data cells. There are only 3 possible answers; 100%, 70% and 0% and I am struggling with multiple logic with the "if" function, hope someone can help.
Scenario.
Cell G15 should provide the answer.
If F3 is less than 60 and F5 is less than 62000, return 100%, If F3 is less than 60 and F5 is greater than 62000 but less than 124000, return 70%, if F3 is greater than 60 or F5 is greater than 124000, return 0%.
I also need a an "on/off" switch so cell F7 as a "Y" that would allow the above to work or a "N" that would always return 0% irrespective of values in F3 and F5.

I have spent hours on this one and I think I have got close but best was "value" ! Someone tell me its possible purleeeese.

This is a nice piece of VBA code which adds seperate worksheets onto the bottom of each other as long as they have the same field structure. I have tested this and it works fine in Excel 2003. However, when you have large worksheets ie. over 65536 records then the files are naturally split into different sheets. With Excel 2007 having a record capacity of 1 million records I have been trying to adapt the VBA to allow the addition of up to 1 million records to a worksheet. Obviously I have tried changing the number of records in the code but this causes the VBA to crash as more adaptions are needed which I can't figure out as I'm very new to VBA. Can anyone help??


	VB:
	
 
Sub CopyFromWorksheets() 
    Dim wrk As Workbook 'Workbook object - Always good to work with object variables
    Dim sht As Worksheet 'Object for handling worksheets in loop
    Dim trg As Worksheet 'Master Worksheet
    Dim rng As Range 'Range object
    Dim colCount As Integer 'Column count in tables in the worksheets
     
    Set wrk = ActiveWorkbook 'Working in active workbook
     
    For Each sht In wrk.Worksheets 
        If sht.Name = "Master" Then 
            MsgBox "There is a worksheet called as 'Master'." & vbCrLf & _ 
            "Please remove or rename this worksheet since 'Master' would be" & _ 
            "the name of the result worksheet of this process.", vbOKOnly + vbExclamation, "Error" 
            Exit Sub 
        End If 
    Next sht 
     
     'We don't want screen updating
    Application.ScreenUpdating = False 
     
     'Add new worksheet as the last worksheet
    Set trg = wrk.Worksheets.Add(After:=wrk.Worksheets(wrk.Worksheets.Count)) 
     'Rename the new worksheet
    trg.Name = "Master" 
     'Get column headers from the first worksheet
     'Column count first
    Set sht = wrk.Worksheets(1) 
    colCount = sht.Cells(1, 255).End(xlToLeft).Column 
     'Now retrieve headers, no copy&paste needed
    With trg.Cells(1, 1).Resize(1, colCount) 
        .Value = sht.Cells(1, 1).Resize(1, colCount).Value 
         'Set font as bold
        .Font.Bold = True 
    End With 
     
     'We can start loop
    For Each sht In wrk.Worksheets 
         'If worksheet in loop is the last one, stop execution (it is Master worksheet)
        If sht.Index = wrk.Worksheets.Count Then 
            Exit For 
        End If 
         'Data range in worksheet - starts from second row as first rows are the header rows in all worksheets
        Set rng = sht.Range(sht.Cells(2, 1), sht.Cells(65536, 1).End(xlUp).Resize(, colCount)) 
         'Put data into the Master worksheet
        trg.Cells(65536, 1).End(xlUp).Offset(1).Resize(rng.Rows.Count, rng.Columns.Count).Value = rng.Value 
    Next sht 
     'Fit the columns in Master worksheet
    trg.Columns.AutoFit 
     
     'Screen updating should be activated
    Application.ScreenUpdating = True 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


Also found at this link http://www.vbaexpress.com/kb/getarticle.php?kb_id=773

I got XL 2007 installed at work today by our tech guys, and I only see the 65K rows usually found in previous versions. Is there a way of setting up XL 2007 to show 1-million rows? or is that feature disabled based on the installed base within the company? Thx.

I recently had Excel 2007 rolled out to me at work as an early adopter, and to avoid compatability issues they defaulted the worksheets to Excel 2003 format. I changed the default, but my default worksheets still always come up with 65k rows rather than the new 1 million rows. How do I change the default to the new Excel 2007 XLSX format?

Any help would be appreciated.

Thanks,
Eugene

How can I import Access data that exceeds 65 rows? I understand that Excel
can now handle 1 million rows - but I cannot figure out how.

Just looking for more feedback on a very forward looking OPEN SOURCE
data model. XL traders could really help us out here!!!

(see below for the general dialogue going on)

http://www.itsdoc.org/tiki/tiki-inde...20Requirements
(see the discussion section)

(main site is www.ITSdoc.org)

Thanks!

Rick

From Garth
Hi folks, couple of thoughts.
1. I think that the choice of development lanaguage has already been
made for us. Since we all want to go the open source route the only
sensible option would be JAVA. My rationale for this is:
a. Cross platform (runs nice on linux)
b. Volume of Developers
c. Libraries, middleware, etc.
2. I agree that we need the realtime AND end of day system.
3. The scope of the project will depend alot on the type of user we
are targeting. My beef with alot of investment software is that there
is an arbitrary divide between "consumer" and "institutional"
investor. To be fair, the institutional investor does have greater
needs (corporate compliance and integrating (with other systems))
HOWEVER all the needs of the corporate user i.e, risk management,
portfolio management are just as CRITICAL to us as "consumer"
investors if not more so.

----
More from Garth

Another thing that I would like to add to our functional requirements
is a module that can calculate yield given commissions, leverage,
interest rates etc. A combination risk managemnt and portfolio
managemnt. I have already done some work on this and it's not as
daunting as it first appears.

----
Rick to Garth

Java is a great choice. Still may have to deal with some mixed code
in various parts of the system. Hopefully the messaging system will
accommodate bridging some applications in different languages.

Major role for Excel as a programmable user interface, data entry,
reporting, charting, etc.

Real-time and end of day data systems don't have to be concurrently
developed. Still, its a great idea to allow the design for both to
work together in the future. Especially combining time buckets into
days so the real time system will mesh with the end of day/week/month
stuff.

Target user (proposed for discussion): One person, managing 100
separate accounts, with securities in 100 different countries,
average account size 1 million dollars U.S., for total assets managed
100 million dollars. Also fully usable by a mutual fund that manages
ONE account, of 100 million dollars, across 100 different countries.
Also fully usable by a hedge fund that manages 100 million for three
investors, long short, with derivatives, 100 different types of odd
fixed income paper, lots of FX and all types of exchange traded
commodities.

The above is to set the design direction that this ultimately is "a
single person aircraft." No need for co pilot, radio man, navigation
officer, several stewardesses, full ground crew, etc. Push off from
the gate and fly this thing well all by yourself.

On the other hand, it is a VERY capable system. Designed from the
ground up to be a turret of action whenever the market becomes
exceedingly tumultuous. It has the capability of dealing very well
with 5 million dollar transactions (5% of a $100 million portfolio)
in a single ticker without the investor getting screwed.

---

Rick Replys to Garth
-------------
>Hi folks, I am really enjoying this discourse. It is good to have
like minded individuals to bounce things off. I agree with everything
Christian said. The Data model is crucial. I have been thinking
through the data model and here are some of my thoughts. Feedback
appreciated.

>Have a planet class, then country class, then exchange class, then
financial instrument class, then data point classes (for intraday
data points and end of day). Obviously, we will have to fill out the
attributes and create other classes via inheritance. I think that we
could use Hibernate to manage the object-relational mapping to mysql.
This could be done fairly quickly. Just some thoughts to get things
rolling. An all open source data layer !!!

Planet Class
------------
One of the best ideas yet! Not because we intend to trade with
extraterrestrials but to illustrate to everyone we want some "room"
designed into the system to possibly use later. We are going for 20
year forward foundation code, so lets leave room "on both ends of the
string" for expansion. Remember when Bell made telephones, they put
in 4 wires when they only really needed two? When you wanted the
Princess Light those two wires came in handy!

Country Class
-------------
Would prefer this to be a "geodemographic" class with latitude,
longitude and boundary vectors. Remember, in the United States you
have States, Cities, Towns, Counties, Municipalities, Zip Codes,
Census Tracts, Sales Tax Jurisdictions, Private Toll Roads, ect all
which overlap and follow no rules. Why is geography important?
Commodities are delivered, unloaded to a specific port, firm names
can be duplicated (same name but different firms in two countries,
etc.) Also emerging countries boarders can change. Hell, large
established countries boundaries change. Debt can be issued by a firm
or municipality, or project. Things like SEC fees may be due on U.S.
transactions in listed securities, even if they are exchanged across
just a bulliten board communication network. Etc.

Plus, in doing research you might want to know "odd things" involving
geodemography. For instance which insurance company (or reinsurance
company) will be hit hardest after the hurricane. (Requiring you to
be able to search company records as to who they insured, map that to
geodemograpic coordinates, establish the likely geographic track of
the hurricane, estimate damage, etc. Also, similar, estimate the
damage to oil refining capacity in the U.S. using same technique,
find oil facilites by zip code, translate to zip code centroids (or
better yet map facility by satellite photo to lat/long coordiantes),
plot the hurricane probability paths, estimate the capacity
reduction. Another key data point to have for each facility would be
the VERY CRITICAL "feet above sea level" statistic, building
earthquake rating, etc. All this just illustrates the need for a good
geodemographic data structure.

See also:
ISO 3166 Domicile codes codes for countries and
subdivisions
ISO 4217 Currency codes Currency codes

Exchange class
--------------

Not only physical, organized exchanges but also Electronic
Communications Networks (ECN), Auctions and other markets. Some of
these do NOT map to a geographic point.

http://www.itsdoc.org/tiki/tiki-inde...xchange%20and%
20Market%20List
ISO 10383 Codes for exchanges and market identification (MIC)
http://www.iso15022.org/MIC/homepageMIC.htm Codes for
exchanges and market identification (MIC) wiki page excellent

Financial instrument class
--------------------------
We don't need to do too much orginal thinking here...."except" ...

http://www.fpml.org/
ISO 6166 International securities identification numbering
system (ISIN)
ISO 10962 Classification of Financial Instruments (CFI code)
http://en.wikipedia.org/wiki/ISO_10962

The design should allow the derivatives and underlyings to be
built "like tinker toys" - snapped together and taken apart. The VaR
module and portfolio must be able to "see" what the combinatorial
possiblities are. For example the data structure must support the
ability to see all "Synthetics" you have created in the test
portfolio or the impact of adding a certain derivative:

Some Synthetic Examples
-----------------------
Long Call - long put and a long stock or future
Long Put - long call and a short stock or future
Long Stock - short put and a long call
Short Call- short put and a short stock or future
Short Put - short call and a long stock or future
Short Stock - short call and a long put
Straddle - Futures and options combined to create a delta neutral
trade
Underlying - long (short) call together with a short (long) put. Both
options have the same underlying, the same strike price and the same
expiration date

ISO 19312 Financial Instrument Attributes and other Market Data
Model (Extended with 20022)
ISO 20022-1 UNIversal Financial Industry message scheme - Part 1:
Overall methodology and format specifications for inputs to and
outputs from the ISO 20022 Repository Repository where processes,
messages and the data dictionary are modelled together using the
Unified Modelling Language (UML)
ISO 20022-2 UNIversal Financial Industry message scheme - Part 2:
Roles and responsibilities of the registration bodies
ISO 20022-3 UNIversal Financial Industry message scheme - Part 3:
ISO 20022 modelling guidelines
ISO 20022-4 UNIversal Financial Industry message scheme - Part 4:
ISO 20022 XML design rules
ISO 20022-5 UNIversal Financial Industry message scheme - Part 5:
ISO 20022 reverse engineering

data point classes (for intraday data points and end of day)
-------------------------------------------------------------

Need a Time Class
Note at its most detailed level we probably need 1/100's of a second
or more to properly sequence bids/offers/transaction in a very highly
traded security during a hugh volume day. Our system needs to be MUCH
better than typical exchanges (which report only Seconds Since
Midnight and use a propiretary sequence number that is never made
public, as a result only THEY and a court order can see who exactly
had priority.)

Need to be able to store "tick by tick" data, timestamp, change in
any of the following: bid, bid volume, offer, offer volume,
executions, execution size, limit orders, special order instructions
(fill or kill, all or none, etc) plus others.

Need a way to consolidate tick-by-tick data into "bars" or time
buckets. E.g. Hi/Low/Last for 5 minutes, 10 minutes, hour, day, week,
month, etc.

Obviously, we will have to fill out the attributes and create other
classes via inheritance.
----------------------------------------------------------------------
---------------------

Need an Entity class for financial reporting

XBRL eXtensible Business Reporting Language (Corporate business
reporting) http://www.xbrl.org/
SWIFT ? Tends to deal mostly with settlement, ISO authorized for
Bank Identifier Code see ISO 9362, 15022? http://www.swift.com/

Need a map from Reporting Entity to Financal Instruments issued
and/or traded (derivatives)

Need a messaging class?
See ISO 20022

I think that we could use Hibernate to manage the object-relational
mapping to mysql.

I'm don't have a great background here but was thinking we should
have an "Industrial Strength" messaging layer in the architecture
between application modules and persistent storage.

Other thoughts:

MySql - nice stable db but how about a "connector" so multiple
databases can be easily hooked up to. For example
http://adodb.sourceforge.net/ Must be something very similar for Java?

This could be done fairly quickly.
-----------------------------------

I'm hoping we move a bit more slowly, especially when laying in
cornerstones of the artecture. If people are really just itching to
run forward they should take just a small section and run (for
example - arbitrage commodity to underlying stock using end of day
data. Just go for it as a separate project and try to make some $$$,
hell that's what this is all about!!!) Keep the eye on both balls 1>
the current "make a quick buck" stuff (which by the way will be very
helpful testing out some of the longer term areceture stuff) and 2>
the longer term 20 year project.

Just some thoughts to get things rolling. An all open source data
layer !!!
----------------------------------------------------------------------
-------------

Excelent thoughts! Open discussion of the issues is the only way we
will ever get close to getting this right.

Rick

More ...

http://www.itsdoc.org/tiki/tiki-inde...20Requirements
(see the discussion section)

Hey together,
Greets from Germany, please don´t expect perfect English (:

My Problem:
I got an excel sheed where Row 1 - 13 and Column A - AFG is full with normal Numbers, Letters and Standard formations. - Nothing Special.
Column A is frozen and on the top of the Column A is a Makro Button.
By clicking on this Button a Window appears where i have to put in some information and that Information will be added to a specified text box with Framework. This works perfectly so far.
But: The Sheed has over 1 Million Rows and i don´t know why. If i try to delete from Row 100 - 1 Million blabla (max amount of Rows via Google) it says a Warning that this Process will take very long time and i shouldn´t do that. Is there any Trick or a "Standardsetting" i have to set?

Please help me

Greets Ruben

I have a chart based on a worksheet with values both above and below 1,000,000. The chart labels show values above 1 million correctly (e.g., 2,500,000 is represented as 2.5 M) but for values under 1 million, it puts the decimal point after the "M" rather than befor the number (e.g., 520,000 should be represented as .52 M, but instead looks like "52M."

Anyone know how to correct this?

Thanks!

Can anyone tell me which financial functions to use to solve this/methods I can use to set this up in Excel?

I have an initial deposit of 1k, bank pays 5% annual interest compounded monthly. I want to leave it in there for 30 years. How do I know how much I should deposit to make one million dollars in 30 years?

I'm having issues with the dollar sign format in excel. I currently use eBay's File exchange format (FEF) and I have a template in excel for my inventory. Under the price column, I need to enter several different prices to look like this $1.00-Basically a dollar sign followed by a decimal point and two places to the right of it.

Because this info is being converted into an html format, this format cannot use text to make it look like the above example. In fact, when I formatted it to text, my html came back with =inventory!RC[-4] under the price header. Also, I used custom, and currency formats, but when it is exported to html, I get results such as 1 (no dollar sign or decimal) So, the formatting inside the cells are useless in this situation. I was only successful once, with the help of a friend to convert this. He basically cut and paste onto notepad and inserted a space, then pasted back into excel. In excel he removed the space, and it worked. Unfortunately, I am not able to replicate this. I have excel 2003, if it matters. I also included an example of what he did, in column D. My prices (the unformatted ones) are in column C. I'm sure that there is an easier way to accomplish this. Thanks in advance!

I'm looking for a VBA code that would either:

1. Merge multiple .csv files (comma delimited) into a single .csv file, which will always have over 20 million rows. The output file must also have a new column (called "NAMES"), where it keeps the source CSV file names without the .csv extension string. Basically, file names in this added column would be an index variable for differentiating merged data. All input .csv files have a varying number of rows and row 1 contains column names (this header is comma delimited). This code should be able to process source files without running into trouble with Microsoft's Excel worksheet row limit.

2. Or, alliteratively, a VBA code that can loop through all original .csv files in a folder and copy/repeat just the name of the file for every row of data(preferably without the ".csv" extension), save the file, proceed to the next file. Once all the original files have been modified and have a new file name column, I will be able to merge them through the command prompt.

Although this last feature is not super necessary, it would be nice if this code could process all files in excel's background, i.e. without having to open each .csv file, modify in worksheet and then save, as this may cause the screen to flash.

I have a spreadsheet that includes a column for year, a column for amount
deposited in a 401(k), a column for growth amount, etc. The last column is
the ending balance for that year. This spreadsheet is used to project the
balance in an account for the future. The problem is that it shows the
actual expected balance in the account for each year. Twenty years from
now, these numbers look quite impressive, but when I take $1,000 and add 3%
to it for twenty years, I find that the numbers are not very large in
today's dollars.

My spreadsheet also has a field where I entered the "assumed rate of
inflation". I currently have 3% in that field.

Is there a way to perform a calculation using the balance, then year, and
the rate of inflation that will show me the balance in "today's dollars"?

Or, even better, if I know the number of years from now (year minus current
year), the amount, and the inflation rate, can I calculate a number in
today's dollars? This would allow me to plug in those three variables and
see what a dollar value is worth.

Amount to evaluate: $2,000,000.00
Number of years from now: 20
Rate of annual inflation: 3.00%
Value in current dollars: _________ ?

The answer should be right around one million dollars. A million dollars
that increases 3% a year for the next twenty years would be 2.5 million at
that time. I can't figure out how to back into that though.

It seems like this should be relatively easy, but searching the previous
posts did not lead me to the answer I needed. Using Excel help pointed me
to the "NPV" function, but I don't think that is exactly what I want here.

Thanks for your help!

--
Rick B

I have number in millions like 2,098,009 and I want them to change to 2 (in
millions)

I need to assess data that I cut & paste from another format. To do so, I
must make cells in my own worksheets equal the cells that C&P items happen to
inhabit in Excel. I know how to make 1 cell equal another in a different
worksheet, but I have several adjoining cells(both in rows and columns) that
I would like to make equal to several adjoining cells in my own separate
worksheet so I can group and add formulas at my preference, from my own
worksheets. I could enter the simple "=Sheet2!B2" formula, but I have
potentially many hundreds of these cells to add them to.

How can I group certain cells to equal a group of similar cells in another
worksheet?

Hello all,

I am trying to do the following. I have a large string of data which I want to split based on vbCrLf. I can do this fine - simply using

Now, I would also like to be able to spit out ArrayName to column A without having to do a loop, as I have a lot of data to
do this for and it takes a considerable amount of time to do it in loop format.  Unfortunately I need to make the above array
(ArrayName) into a multidimensional array to do this.

I cannot seem to find a way to do it. Even using something like

it does not like it, and I do not know a different way to do it.  It gives a "Subscript out of range" error,
presumably because I am trying to change the first array dimension as well and with preserve it needs to only modify the last
dimension.

If there is a way to do this - essentially take a 1-D array created via the split function and create it in the form that can be quickly output into a worksheet - please let me know as it would be greatly appreciated.

Thanks in advance,
GoogleBot

I have a spreadsheet that includes a column for year, a column for amount
deposited in a 401(k), a column for growth amount, etc. The last column is
the ending balance for that year. This spreadsheet is used to project the
balance in an account for the future. The problem is that it shows the
actual expected balance in the account for each year. Twenty years from
now, these numbers look quite impressive, but when I take $1,000 and add 3%
to it for twenty years, I find that the numbers are not very large in
today's dollars.

My spreadsheet also has a field where I entered the "assumed rate of
inflation". I currently have 3% in that field.

Is there a way to perform a calculation using the balance, then year, and
the rate of inflation that will show me the balance in "today's dollars"?

Or, even better, if I know the number of years from now (year minus current
year), the amount, and the inflation rate, can I calculate a number in
today's dollars? This would allow me to plug in those three variables and
see what a dollar value is worth.

Amount to evaluate: $2,000,000.00
Number of years from now: 20
Rate of annual inflation: 3.00%
Value in current dollars: _________ ?

The answer should be right around one million dollars. A million dollars
that increases 3% a year for the next twenty years would be 2.5 million at
that time. I can't figure out how to back into that though.

It seems like this should be relatively easy, but searching the previous
posts did not lead me to the answer I needed. Using Excel help pointed me
to the "NPV" function, but I don't think that is exactly what I want here.

Thanks for your help!

--
Rick B

I'm making a ranking list in excel and now i want all numbers to be alligned when I copy them to a forum. In order to do that I need excel to make every number 3 figures, so for instance 1 becomes 001 and 85 becomes 085. There must be a way to do this automatically in excel, but how? Does anyone know?

Thanks in advance,

Cervantes

I need to create a formula to determine the share of costs between two people. One person needs to pay 67% of every dollar and the other person 33% of that same dollar.

So I want to plug into column C the total dollar amount. I want column D to show 2/3 of that same dollar amount and column E to show 1/3 of that same dollar amount.

So, how do I do that?

I need to assess data that I cut & paste from another format. To do so, I
must make cells in my own worksheets equal the cells that C&P items happen to
inhabit in Excel. I know how to make 1 cell equal another in a different
worksheet, but I have several adjoining cells(both in rows and columns) that
I would like to make equal to several adjoining cells in my own separate
worksheet so I can group and add formulas at my preference, from my own
worksheets. I could enter the simple "=Sheet2!B2" formula, but I have
potentially many hundreds of these cells to add them to.

How can I group certain cells to equal a group of similar cells in another
worksheet?

I have a tricky situation whereby I need to be able to allow two price
fields for the user to enter and the user will not always put in both
values:

Field 1
- US Dollars

Field 2
- Euro

Somehow need to show what the price will be in for either currency without
making too many calculation columns....

Is there a way to do this?

Thanks
Jason

How would you take 1 cell with a first name and last name and make them 2 separate cells?


No luck finding an answer? You could always try Google.