comparison of values

Hi All I am a newbie here :warning: so please bare with me. I am trying to recon two sets of data both of which has two columns of info. I need excel/access to find the exact matches of the two sets of columns and to remove them leaving me with unique info for both the data sets as seen below...

Hi Chandooers, My worksheet does this; I have a workbook which simulates the temperatures and displacements across hundreds of test points within a 2D model of an aircraft engine, at discrete time increments from the start of a flight cycle to the end. It's used for analysis and engineering...

Hello All, I am new to the forum and have been using VBA in a limited fashion for about half a year. However, it is my goal to get a lot better at it so here I am. My first question involves comparing values between two different workbooks using a macro. Specifically I would like to: Look in...

I could use some help validating weekly system analysis. Every week I receive a network report of all devices in my IS. Sometimes the scan doesn’t report all of them and I need to know which ones are missing from the report. I need the VBA script because the report runs weekly. Column B in...

Hi all, first timer here. I am running some hockey pools and I was wondering if there was some sort of formula where I can find out quickly how many points 2nd place is behind first, how many points 3rd place is behind second place... Here is the table I have been filling in for our hockey...

I have 2 sheets named orange book data alerts and total orange book data alerts , both sheets have data from A to M, unique value is in Column A in both the sheets. here I compare orange book data alerts with total orange book data alerts. When there is a match, compare its row cell values for...

Hello all, I have a list of 100 company names (List A), and I have a second, longer list of company names (List B). There are several company names that these two lists have in common, but the actual text differs slightly. I am trying to see if there is a way to see what names in List A appear...

I have a sheet with two columns "type", "code" with some values. The "type" column contains unique values. But the "code" contains values which categorize the values in "type" column. <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> type code 1 a 2...