Matching one column against another column of data to show the same amount of data.

Matching one column against another column of data to show the same amount of data.

Post by doda » Sun, 01 Jan 2006 03:19:47


For example. Column A has 100 values and column B has 50 values. Is there
a function that is able to return Column A and B to show 50 values in order
for me to run a specific function (Linest)with out manually truncating
Column A to have 50 values.

Thanks!
 
 
 

1. Convert One Column Data to Multiple Columns Data

2. Checking data in 2 columns against a further 2 columns....

I need to check the values of two columns agains another two colums (with
same data) and if they are both in the sheet return a positive result, or if
wrong return a "Missing Order".

Example:
A B C D
E
SENT Received CHECK
Account Order Date Account Order Date
123 01/12/2009 314 05/12/2009
231 02/12/2009 142 04/12/2009
314 03/12/2009 123 01/12/2009
142 04/12/2009


So I need to take the info from Colum A and B (account and order date) and
see if the same info resides in Column C and D, and if so put a check mark in
Column E.

So in this case I would get an 'OK' for account '123' and '142' but not for
'314' because the date is different and not for 231 because it is missing.

I'm sure its simple enough, I have tried combining and checking, but with
dates it goes wrong....

If you can help I woudl be SO grateful!

Thanks,
Tony

3. Count cells w/values in column if the data in column a matches

4. splitting single column data to multiple column with matching some

5. Matching Data from 1 column across many columns

6. Adding column data based on match in 2nd column - Help

7. Count cells w/values in column if the data in column a matches cri

8. Sorting Data into columns without replacing the columns with data

9. Macro to paste data to a new column if previous column has data

10. How do I sort data in column B to align with data in column A?

11. How to specify 2nd column data depending on 1st column's data?

12. macro to compare data in column A of sheet 1 with data in column A

13. Splitting a Column of Data into Two Columns of Data

14. Matching a column of new data to existing larger data set.

15. Activa or not activate a button column depending if another data column has data or not