Microsoft Excel 2002 (full product)

Hi there

I am trying to find the missing value in a range.

If I have values of sort:

$00124

$00126

$00128

$0012AIn 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

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!

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 VALUEbasically 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

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)

byColumn 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 VALUEThen 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 VALUEThen 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

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

Do you need any more help or can you handle the code on your own?

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

Glad I could help.

Ask Your Question

Weekly Poll

Do you think Amazon can bring Internet access to less-developed regions?

Discuss in The Lounge

Poll History