Thread: Matching the same amount of records in one value to another column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dodat
 
Posts: n/a
Default 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.
Reply With QuoteReply With Quote