Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm building a spreadsheet to track Certificate of Deposit (CD) rates from various banks. CD rates can be vastly different per bank: term length (3 months, 6 months, 60 months, etc.), and number of different rates (a rate for 3 month CDs and 6 month CDs for one bank, where another bank offers different rates for 1, 3, 6, 11, 16, and 60 months). My question is, how can I track this information in Excel?

Preferably, I'd like to have a row for each bank, as the sheet will need to track other bank information (bank name, URL, etc.). I figured that I'd need one cell to hold multiple values (an array), or an id to another table (such as a relational database).


migration rejected from Nov 21 '15 at 6:59

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as too broad by agtoever, Excellll, bwDraco, Ramhound, Breakthrough Nov 21 '15 at 6:59

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.

Do you need to track historical data (e.g. bank X had a rate of Y for a 1 month CD on July 1st 2011) or do you only want to store the current rate for each bank/term length combination? – barrowc Aug 10 '11 at 0:12
I'm not looking to track any on-going data, just the most up-to-date. Although, being able to see how the rates change over time would be nice. Perhaps I'll tackle that next. – Akaishen Aug 10 '11 at 1:21

This is like trying to draw with ASCII art when Microsoft Word has a draw tool. Do yourself a favor and break down the problem into layers.

For one, I have no idea why you need everything on one row?? Excel formulas can reference whole spreadsheets at a time and calculate all that data into a single cell.

Two, you need to sit down and figure out exactly what you want. If all you need is to track CDs from different banks, there already are templates out there you can download that not only track CDs and their rates, but will also do fancy graphs and cook your breakfast. . .

You should probably sit down and write specifically what you want. It will make writing formulas and macros much much easier, rather than trying to plug in functionality piecemeal (the bane of all developers!! ie the ever changing specs).

Thanks for your reply Surfasb. I suppose the reason I was looking for a one-row solution is due to my lack of experience. From your reply, I gather that I can setup something akin to a relational database (holding the data in various places and gluing together the parts I want, when I want them). I'll start learning more about formulas and macros. I'll also see if I can find a template to cook my breakfast; that seems awesome. ;) – Akaishen Aug 10 '11 at 6:28
Yeah, Excel can pretty much do anything you throw at it. A good place to browse for templates is the Microsoft Office website. – surfasb Aug 10 '11 at 6:30

Not the answer you're looking for? Browse other questions tagged .