Results 1 to 8 of 8

Update line if a cell has specific value

Threaded View

  1. #1
    Registered User
    Join Date
    03-14-2017
    Location
    Iceland
    MS-Off Ver
    2016
    Posts
    16

    Update line if a cell has specific value

    Hi
    I have a large sheet of data and some of the lines are corrupted, that is some of them are the right values multiplied by x2,x3 and so on.

    Like you can see on the picture, lines 4 and 5 are just right but lines 3 and 7 are the original values multiplied by *2 and line 6 multiplied by *4.
    What i want to do is to update lines 3 and 7 by divideing them by /2 and line 6 by /4
    Best regards
    HlynurCapture1.PNG
    Last edited by hlynur11; 03-18-2017 at 04:25 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Update line if a cell has specific value
    By hlynur11 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-16-2017, 08:32 AM
  2. Replies: 3
    Last Post: 03-12-2017, 03:39 PM
  3. Update date Specific cell by use Specific Month
    By Nisar.mohammed in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2014, 11:26 AM
  4. Cell update at a specific time
    By Lipocky in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-01-2013, 03:19 PM
  5. Macro to copy specific line from text file and paste into specific cell in excel
    By keeneye in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 10:35 AM
  6. Replies: 2
    Last Post: 02-01-2013, 02:53 AM
  7. Update cell at specific day
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-09-2010, 03:54 PM

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