View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] dsiedt@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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.