Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup values and display them
I have 2 different sets of values in 2 columns that are constantly changing.
I want excel to be able to find a missing value between the 2 columns data and list the missing values in order. Which function(s) should I use. If you want me to email the worksheet to you, just email me at Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup values and display them
Assuming your lists are in columns A and B, and column a goes from row 1 (A1)
to row 1000 (A1000), and you want to find out if a value from that column also appears in (or is missing from) column B, then in a column put this formula in row 1 and fill it down to the end of the list in column A. This assumes that the list in B goes from row 1 to row 500, but it could be of any length, just change the address in the formula: =IF(COUNTIF(B$1:B$500,A1)=0,A1 & " is Missing from Second Column","") "damanwitdaplan" wrote: I have 2 different sets of values in 2 columns that are constantly changing. I want excel to be able to find a missing value between the 2 columns data and list the missing values in order. Which function(s) should I use. If you want me to email the worksheet to you, just email me at Thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup values and display them
Hi,
You will probably have to resort to a macro to do this. -- If this helps, please click the Yes button Cheers, Shane Devenshire "damanwitdaplan" wrote: I have 2 different sets of values in 2 columns that are constantly changing. I want excel to be able to find a missing value between the 2 columns data and list the missing values in order. Which function(s) should I use. If you want me to email the worksheet to you, just email me at Thanks in advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup values and display them
Yes, may have to if he wants a tighter list (no empty rows) than the
relatively simple test I put up earlier would give. Plus, as is so typical of me, I may have missed some of his real meaning in what he wants. Ddamanwitdaplan: if we haven't helped sufficiently or appear to not completely understand the problem, you can send the .xls file as an attachment to email and again explain the problem. Send to (remove spaces) Help From @ jlatham site.com "Shane Devenshire" wrote: Hi, You will probably have to resort to a macro to do this. -- If this helps, please click the Yes button Cheers, Shane Devenshire "damanwitdaplan" wrote: I have 2 different sets of values in 2 columns that are constantly changing. I want excel to be able to find a missing value between the 2 columns data and list the missing values in order. Which function(s) should I use. If you want me to email the worksheet to you, just email me at Thanks in advance |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup values and display them
Shane,
Just a follow-up. He sent the workbook to me. Based on the workbook I got, basically he was only using a single cell in column A and then about 20 values in column B. So there wasn't an incredibly huge number of combinations to deal with. I did it all with some formulas and I presume it was acceptable to him - when I sent his workbook back to him that was the last I heard from him. "Shane Devenshire" wrote: Hi, You will probably have to resort to a macro to do this. -- If this helps, please click the Yes button Cheers, Shane Devenshire "damanwitdaplan" wrote: I have 2 different sets of values in 2 columns that are constantly changing. I want excel to be able to find a missing value between the 2 columns data and list the missing values in order. Which function(s) should I use. If you want me to email the worksheet to you, just email me at Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i wish to lookup values in column A, & add adjacent values in colu | Excel Discussion (Misc queries) | |||
some cells display formulas, some display values | Excel Discussion (Misc queries) | |||
Lookup letters and display highest values in a pivot table | Excel Discussion (Misc queries) | |||
Lookup values in a column and display them in order with no gaps | Excel Worksheet Functions | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) |