+ Reply to Thread
Results 1 to 2 of 2

Subtract all numbers of a column by another column, return a matrix of subtracted values

  1. #1
    Registered User
    Join Date
    09-09-2010
    Location
    greece, athens
    MS-Off Ver
    Excel 2003
    Posts
    1

    Subtract all numbers of a column by another column, return a matrix of subtracted values

    Subtract all numbers of a column by another column, return a matrix of subtracted values

    Two tasks:
    I) Subtract all the numbers of A column from the numbers of another column B e.g. a1-b1, a1-b2 etc and then a2-b1, a2-b2 and Return a matrix of results of size "A*B" e.g. a1:a10 =10 b1:b20=20 --> 10*20 matrix
    --Columns may are not of same lenght, they may have different lenghts!

    II) Using the above results, return in a column, the smallest different EACH time!
    For example

    A = 1,2,3,
    b = 2,3,4

    A1-b= -1,-2,-3
    a2-b=0,-1,-2
    a3-b=-3,-2,-1

    Therefore, the final result will be in d column: -1,0, -1

    Is that possible?

    sincerely,
    Elias "Estatistics" Tsolis
    For excel 2003 version

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Subtract all numbers of a column by another column, return a matrix of subtracted valu

    attach a sample excel file
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Subtract the value in column A if between two numbers
    By xenoran in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-01-2014, 07:43 PM
  2. Formula to subtract 7th column values from the column before the 1st (loop)
    By saya_26 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2014, 09:13 AM
  3. VBA code to Subtract values in Column F with Column E if found non-blank
    By hydz1213 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2013, 04:34 AM
  4. [SOLVED] VBA: Loop through cells in matrix and return column- and row headers
    By Søren Larsen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2012, 08:43 AM
  5. Select a Date between Two Date Rows, then the Column State and return Table Matrix Values
    By InNeedofHelpASAP in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 11:03 AM
  6. Return column numbers based on values
    By mkvassh in forum Excel General
    Replies: 5
    Last Post: 09-21-2011, 06:19 AM
  7. Replies: 3
    Last Post: 01-10-2006, 06:10 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1