Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() I have two large lists of numbers with corresponding data in the cell adjacent to them. I would like the list of numbers to match (inserting cells where there are gaps). Is there any way to quickly and easily do this? For Example: 1 a 1 2 b 2 3 c 4 4 d 5 5 e 6 6 f 7 I would like it to automaticalls insert a space where the "3" should be in the 3rd collumn. Thanks. -- Buildscharacter ------------------------------------------------------------------------ Buildscharacter's Profile: http://www.excelforum.com/member.php...o&userid=28783 View this thread: http://www.excelforum.com/showthread...hreadid=484720 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inserting page numbers in a cell | Excel Discussion (Misc queries) | |||
Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
Auto Update upon shifting, inserting or deleting | Excel Worksheet Functions | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
how do i set up to auto detect duplicated numbers in an excel fiel | Excel Discussion (Misc queries) |