+ Reply to Thread
Results 1 to 1 of 1

Use row number as factor in calculation, replace original values

  1. #1
    Registered User
    Join Date
    08-23-2012
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2010
    Posts
    1

    Use row number as factor in calculation, replace original values



    I'm trying to determine the VB for a macro that will replace the values in a column by the the results of the calculation of that same value + (row number/ 100000). At the present, I am creating an additional column and using the following formula:

    IF(E2>=1, (E2+(ROW(E2)/10000000000)), "")

    What I need is for the resulting value to replace the original value in E2. Sorry for the redundancy. This is needed so that vlookups can be preformed on the actual values as attained through a combination of Rankings and MIN/ MAX value determinations on multiple worksheets within the same workbook. I only want to alter the original values slightly, so that the data set will contain all unique values. I need this calculation to be done to three growing columns of data.

    I plan to attach this macro to a form button on the sheet where the data is located.

    Thanks in advance.
    Attached Files Attached Files

+ Reply to Thread

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