Matching the same amount of records in one value to another column
 

For example, i have column A with 100 records and Column B with 50 records.
How can i show Column A to show 50 records to match column B in order to run
a function (LINEST). Or How can i force Linest to pick up the column with
the least amount of records to match with the column that has more records.
Currently, its a manual process and is very tedious. Thanks in advance.

Matching the same amount of records in one value to another column
 

Insert a Column Between A and B. Then in you new column B add the
following text "Col A" or Just "A" for each record in column A. Then in
column D
us something like the following "Column C" or just "C" for each record
in column C. At this point Save your File. Now copy column C and D and
paste into column A and B. At this point you still know what was
originally in your column's A and B by the Identifier's.
Now Sort Column A. Your records should start at A2, if not then insert
a blank line at the top of column A or add a column header at row A1.
Then enter the following formula in a "Blank Column" and copy down to
the last row of Column A.
The formula is; =IF(A2=A1,"Dup","Not Dup"). This will give you a
listing of "Duplicate" and "Not Dup" records. You can use any
designator you want for the "True" and "False" part of the statement.
Now you should be able to accomplish you "LINEST" based upon the
"original column" and then using the "Dup" and "Not Dup" values.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=497000