| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
One column to another
I am looking to make a number equal from one cell to another number. EX:
43=1, 42=2, 41=3, etc. going 43 to 1. here is how i have done it so far: =IF(C13=43,"1",IF(C13=42,"2", IF(C13=41,"3",IF(C13=40,"4",IF(C13=39,"5",IF(C13=3 8,"6", IF(C13=37,"7",IF(C13=36,"8")))))))) I have used 6 cells to complete it and I know that is not the best way to do it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
| Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
| Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| Divide Column A by Column B multiply Column C | Excel Worksheet Functions | |||
Threaded Mode
