LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumif Cells Are Not Blank Powlaz Excel Worksheet Functions 12 March 15th 06 04:40 PM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
Order of selecting unprotected cells sp2 tester Excel Discussion (Misc queries) 2 August 15th 05 04:07 PM
locking cells based on results at runtime aken Excel Worksheet Functions 3 June 22nd 05 02:01 PM
can excel draw a shape based on values entered in cells Milo Excel Worksheet Functions 1 April 6th 05 01:36 AM


All times are GMT +1. The time now is 01:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"