Results 1 to 5 of 5

VBA Needed for all possible two-pair combination of cells

Threaded View

mailsodia VBA Needed for all possible... 10-29-2012, 05:18 AM
zbor Re: VBA Needed for all... 10-29-2012, 05:37 AM
mailsodia Re: VBA Needed for all... 10-29-2012, 05:45 AM
RHCPgergo Re: VBA Needed for all... 10-29-2012, 05:51 AM
mailsodia Re: VBA Needed for all... 10-29-2012, 06:04 AM
  1. #1
    Registered User
    Join Date
    10-28-2012
    Location
    trenton
    MS-Off Ver
    Excel 2011
    Posts
    3

    VBA Needed for all possible two-pair combination of cells

    I have a large dataset that I need a macro/vba to compute a two-pair combination of all cells into an index in the form (a1-a2)/(a1+a2). I want to take cell a1 and apply the calculation to all cells i.e. a1....an, and then move to cell a2 and so on till all cells are covered.

    I am attaching a sample of my dataset

    Thank you in advance for your help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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