Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto Inserting numbers
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 |
#2
|
|||
|
|||
Auto Inserting numbers
Assuming you want the results for the data as shown
ListAN ListAL ListBN ListBL ResultBN ResultBL 1 L 1 D 1 D 2 M 2 E 2 E 3 N 3 F 3 F 4 O 5 G 5 P 6 H 5 G 6 Q 7 I 6 H 7 R 8 J 7 I 8 S 10 K 8 J 9 T 11 L 10 U 12 M 10 K 11 V 13 N 11 L 12 W 14 O 12 M 14 X 15 P 14 O 15 Y 17 Q 15 P 16 Z 20 R 17 A 21 S 17 Q 18 B 22 T 19 C 23 U 20 D 24 V 20 R 21 E 25 W 21 S Name the columns as shown. Enter these formulas into ResultBN and ResultBL respectively =IF(COUNTIF(ListBN,ListAN)=0,"",ListAN) =IF(ISNUMBER(ResultBN),LOOKUP(ResultBN,ListBN,List BL),"") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |