Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Way to Concatonate cells in a row based on the order they were entered?
I created a keypad (similar to a phone or ATM numbers 0-9). When you
click on a number key, that key populates a matrix (via macro) similar to: All Numbers Numbers Clicked 0 1 2 1 3 1 4 1 5 1 6 7 8 9 In the example above, the keys 4,3,2,5 were entered and a 1 was entered in the row next to the key number. I then was able to get the data into a table similar to: 0 1 2 3 4 5 6 7 8 9 2 3 5 8 The top row is all of the numbers and the bottom row is the numbers that were clicked. I was going to just concatonate the bottom row 2,3,5,8 but the numbers were not entered in that order; instead, the pin they entered was 4,3,2,5 I am stumped! Any help would be greatly appreciated as I have been working on this for days. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif Cells Are Not Blank | Excel Worksheet Functions | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Order of selecting unprotected cells | Excel Discussion (Misc queries) | |||
locking cells based on results at runtime | Excel Worksheet Functions | |||
can excel draw a shape based on values entered in cells | Excel Worksheet Functions |