Question about Microsoft Excel for PC
I'm assuming you'd like to assign a numerical value to cardinal references (1st, 2nd, 3rd, 4th, etc.).
Best way to do this is to create a quick lookup table on a separate sheet of the same .xls document. Down at the bottom of the page, click on Sheet2 and create a quick table where column A has 1st, 2nd, 3rd, etc. and column B has your values.
Now click back to Sheet1 where your data is and in A2 put this formula:
=VLookup(A1, Sheet2!$A$1:$B$x, 2, FALSE)
Note: replace the lower case x in the formula above with the number of the last row of data in your lookup table on Sheet2.
You can copy and paste this formula down the column to calculate your other values.
Hope that helps!
Posted on Sep 11, 2008
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Dec 13, 2013 | Microsoft Excel for PC
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Jun 06, 2010 | Microsoft Excel for PC
Jul 09, 2009 | Microsoft Excel for PC
Oct 09, 2008 | Microsoft Excel for PC
Aug 25, 2008 | Microsoft Office Professional 2007:...
Jun 10, 2008 | Microsoft Excel for PC
Mar 07, 2008 | Microsoft Excel for PC
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
147 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: