Excel/row based data
Hi, thanks for answering questions on Excel. My question is this - my data is row-based. That is, each row contains different bits of data on a single person. Imagine an HR database. Each column contains the same type of data. e.g., column A contains name, column B date of hire, etc. I wonder if there is a way to name a column of data, and then use that in a formula. e.g., column B is date of hire, and I've got 100 employees. So, a formula could calculate days since hired (today()-B2). However, I would like to name the column, to make it easier to read the formulas - e.g., DOH2, DOH3, DOH4, etc. So, once I create a formula, I can then copy it to the rest of the cells in the column. Hope that makes sense, thanks!
Thank you for your question.
What you are trying to accomplish can be done with Named Ranges. Here's how:
Define and use names in formulas
By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.
A name is a meaningful shorthand that makes it easier to understand the purpose of a cell reference, constant, formula, or table, each of which may be difficult to comprehend at first glance. The following information shows common examples of names and how they can improve clarity and understanding.
Formula with Named Ranges
I hope this helps you with what you are trying to do. If not, please message back and I will do my best to assist.
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here