Find Missing value in colom

Microsoft Excel 2002 (full product)
March 30, 2010 at 01:11:25
Specs: Vista, Office 2002
Hi there
I am trying to find the missing value in a range.
If I have values of sort:
$00124
$00126
$00128
$0012A

In colom A and I have value $00127 in colom
B, how do I find the missing value in colom A,
create a new row and paste vlaue $00127 in
new row.

Cheers for the help


See More: Find Missing value in colom

Report •


#1
March 30, 2010 at 03:38:19
I assuming there is more to this question than you have told us.

I say this because the easy answer is to simply enter the value from Column B at the bottom of Column A and then Sort.

Before we spend time coming up with a solution that doesn't fit your final needs, why don't you give us the rest of the story?

Thanks!


Report •

#2
March 30, 2010 at 04:55:15
thanks for the quick answer..;)

however I have data in the next five coloms as well , so if I sort
the first colom then the other data wont match the data in
colom A...?

$00124 K_PWG1_MAX 1x1 VALUE
$00126 K_PWG1_A0_MIN 1x1 VALUE
$00128 K_PWG1_A0_MAX 1x1 VALUE
$0012A K_PWG_TAU_NORM_UP 1x1 VALUE

basically I have another list of addresses like in colom A but
the other list contains more addresses than the list above, so
I want to search which addresses are missing and then enter
a row for the missing addresses but in the correct place.
Hope this make sense
Cheers


Report •

#3
March 30, 2010 at 05:12:02
re: if I sort the first colom then the other data wont match the data in colom A...?

Just to address this point, you can Sort an entire range (e.g A1:H6) by Column A which will keep all of the other columns matched up with the correct values in Column A.

As to your question, if you have other columns associated with data in Column A, do you also have other columns associated with the values in the "other list"? In other words, do you need to insert entire rows?

If a Macro was written to place entire rows from the "other list" at the bottom of Column A and then Sort all of the data by Column A, would that get you what you want?

e.g. Start with:

$00124  K_PWG1_MAX         1x1 VALUE
$00126  K_PWG1_A0_MIN      1x1 VALUE 
$00128  K_PWG1_A0_MAX      1x1 VALUE 
$0012A  K_PWG_TAU_NORM_UP  1x1 VALUE 

Then put the missing lines at the bottom

$00124  K_PWG1_MAX         1x1 VALUE
$00126  K_PWG1_A0_MIN      1x1 VALUE 
$00128  K_PWG1_A0_MAX      1x1 VALUE 
$0012A  K_PWG_TAU_NORM_UP  1x1 VALUE 
$00127  K_PWG1_A0_MAX      1x1 VALUE 
$00125  K_PWG_TAU_MAX      1x1 VALUE

Then Sort by Column A

$00124  K_PWG1_MAX         1x1 VALUE
$00125  K_PWG_TAU_MAX      1x1 VALUE
$00126  K_PWG1_A0_MIN      1x1 VALUE 
$00127  K_PWG1_A0_MAX      1x1 VALUE 
$00128  K_PWG1_A0_MAX      1x1 VALUE 
$0012A  K_PWG_TAU_NORM_UP  1x1 VALUE 


Report •

Related Solutions

#4
March 30, 2010 at 05:19:52
perfect answer thank you very much, I never knew it was this
easy, I was on my way to write one long makro to do this and
decided to ask for help first..;)
cheers

Report •

#5
March 30, 2010 at 06:11:46
Do you need any more help or can you handle the code on your own?

Report •

#6
March 30, 2010 at 07:53:58
Hi Derbydad, I have followed your advise and it took me less than
one minute to add the missing data and to sort the colom by A,
again thank you very much for your help...;)
Cheers

Report •

#7
March 30, 2010 at 09:25:29
Glad I could help.

Report •


Ask Question