+ Reply to Thread
Results 1 to 2 of 2

Get Array Value and then subtracting array value in 2 column , multiple array value.

  1. #1
    Registered User
    Join Date
    06-12-2017
    Location
    SINGAPORE
    MS-Off Ver
    WINDOWS 7
    Posts
    14

    Get Array Value and then subtracting array value in 2 column , multiple array value.

    Is there someone can help me on how to get array value ? I need to subtract 2 cell and put the result in the cell also.
    Same with multiplication procedure. I did try searching but because I am new in using array I have a hard time to settle the issue in my code urgently.

    Kindly see attached file. sheet1 is the preliminary format while sheet2 will be the correct result once code was executed. Below is my code also. Thank you for your help.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Yajson; 01-02-2018 at 11:52 AM.

  2. #2
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Get Array Value and then subtracting array value in 2 column , multiple array value.

    Hello Yajson,

    I do not understand what it is that you want
    Do you understand what it is that you want?

    Please take a look at the File that you have given us.
    Please try to understand yourself what it is that you want.
    Then, pleas try again to tell us what you want.

    I do not understand what it is that you want
    I do not think anyone can understand what it is that you want, based on your explanations.

    Alan
    Last edited by Doc.AElstein; 01-06-2018 at 08:16 AM.
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

+ 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. [SOLVED] how can i make this array change the cell in a column based on a text array
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-25-2016, 09:44 AM
  2. [SOLVED] Find cell in 2nd array using row and column from the first array Excel 2010 VBA
    By crywolf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2015, 02:12 PM
  3. Replies: 6
    Last Post: 09-25-2013, 10:08 PM
  4. [SOLVED] Quick Array question - Copy array to another array then resize?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-02-2013, 01:17 AM
  5. Single Conditional Array x two Multi-Column Array - Approach needed
    By David Brown in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-28-2010, 11:41 AM

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