| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
writing the columns a number is listed in
Thinking wise I could even create a formula to show what row the number was
found. ie. Row Number ----- --------- 100 1 101 2 102 3 103 2 104 3 105 1 Having the results show: 1: 100, 105 2: 101, 103 3: 102, 104 Either have it be Column A has the 1, 2,3 and Column B has 100, 101, 102 and Column C has 105, 103, 104.... or the 100, 105 can be in the same column if possible. Does anyone know the formula to make this? Any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| putting a number equal to writing commands | Excel Worksheet Functions | |||
| identify numbers which are listed in two columns. | Excel Worksheet Functions | |||
| Is there a maximum number of non-contiguous columns that can be h. | Excel Discussion (Misc queries) | |||
| how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
| Change number of columns mid page? | Excel Worksheet Functions | |||
Threaded Mode
