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

1 post • Page:**1** of **1**