Summary: @ DerbyDad03 "Even assuming that the 2 columns are sorted in the same order, as soon as Dx doesn't match it's corresponding AKx - meaning a part # is ...
Summary: We have a bill that is sent to us every month and it has an invoice number and a total. I then have to run a sql query to give me a range of invoice ...
Summary: Hi new to this I have a spreadsheet with 2 columns of alpha/numetic numbers. I need to identify which numbers are in both columns and what cell they a...
Summary: Hi, I have got two columns in excel table. Both columns contain names of companies in Croatia. My task is to compare those columns to see if there are...
Summary: Thanks mike, I tried that and nothing happened, that i think was for numbers. What i am looking for is like the post "compare two columns in excel" h...
Summary: I would like some help with a lookup table. I would like to create an excel spreadsheet to help with my vehicle logbook. What i want to achieve is on ...
Summary: This question has been answered before. Try This: 1. Insert a column between Column A & Column B 2. Type the following formula in cell B1: =IF(ISER...
Summary: thx M for your reply and pardon me for not asking my question probably. but what i actually need to do is 1) to compare two columns of data in two di...
Summary: I need to divide dollars and cents into two columns and then add the cents column into a total cents column and the dollar columns into a total dollar...
Summary: If you want the values to start in C1 "automatically" i.e. without multiple steps, you'll need to use the VBA code, modified to match your ranges: Sub...
Summary: OK, your last post doesn't make sense. If we go back to the beginning of this thread, I read it to mean this: - You have a list data in Sheet1!A:A. - ...
Summary: I have a problem, I need to compare data for two columns and a unique value is required. The Problem which I am getting is that I have to compare the ...
Summary: Hello, In advance thank you! I have a long contact list with different columns and I have a seperated "First Name" & "Last name" column. But my "first...
Summary: I have two Access 2002 databases. One is called Reservations and has the following fields: Name, Lastcontact (=date of last contact), road, town, tele...
Summary: I'm sure this can be done with some VBA code, but we're gonna need some more specifics. If I were going to write the code to do this, I would start by...
Summary: In WORD I can write a paper that has 2 columns and insert a line between the columns. Is there a way to put a line between columns as well as a vertic...
Summary: I was bored... This code will automate the placement of the formulae in Sheet1 Columns G & H and Sheet2 Columns C & D. It will also hide the columns w...
Summary: I have 4 columns of data. I need to take column B, row 1 and search column A (all rows) for a matching value, if a match is found, then I need to cop...
Summary: Hello, I have 1 row in worksheet1 and 2 rows in worksheet2. I want to comapre 1 row of sheet 1 with first row of 2nd sheet. If match found then need t...
Summary: I have an running spreadsheet with 2 columns I would like it to read. Column A are dates: 8/1, 9/1, 10/1. Column F are results: Enrolled, N/I, N/E I ...
Summary: Hi, Need script to compare 2 table content, and display me whether its same or not. The script need to identify the diffence betwwen two tables ...
Summary: i mean, if u don't want anybody write in this special row, protect it (select all sheet, go in format/rows/protection disable protect) next select ur ...
Summary: Excel, Help, Contents and Index, vlookup provides a good explanation and provides examples of how the formula is used. Another short method is to clic...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
