+ Reply to Thread
Results 1 to 8 of 8

Find or highlight approximate positive value in column for a negative appearing in another

  1. #1
    Registered User
    Join Date
    05-23-2015
    Posts
    6

    Find or highlight approximate positive value in column for a negative appearing in another

    Hyy Excel Experts,
    I have one column in which there is list of positive value for which there exists corresponding negative value in another column, so i want to highlight and find the values which approximate set off with each other...how can i do this, please provide me a solution for this.

    Thanks...

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,676

    Re: Find or highlight approximate positive value in column for a negative appearing in ano

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    05-23-2015
    Posts
    6

    Re: Find or highlight approximate positive value in column for a negative appearing in ano

    How to attach file???

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,337

    Re: Find or highlight approximate positive value in column for a negative appearing in ano

    To attach a file for the members to work with:

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Regards and welcome to the forum.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  5. #5
    Registered User
    Join Date
    05-23-2015
    Posts
    6

    Re: Find or highlight approximate positive value in column for a negative appearing in ano

    HI,
    I tried a lot to attach "BEFORE" and "AFTER" excel file but after a long processing time also it didn't got uploaded,
    Please provide me any other way or please provide me any of your mail ID and I will just mail it to you an you please upload it.
    Please help me out.

    Thanks a lot.

  6. #6
    Registered User
    Join Date
    05-23-2015
    Posts
    6

    Post Re: Find or highlight approximate positive value in column for a negative appearing in ano

    HI Excel Experts,
    I have uploaded Before and After Sheet.I only wants to highlight and find the positive and negative values.
    I don't mind if the sheet 1 and 2 data are brought on the same new sheet say sheet 3 for making the purpose solve.
    There are many positive/negative values on sheet 1 whose corresponding negative/positive value are appearing on sheet 2.

    Thanks a lot.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    05-23-2015
    Posts
    6

    Re: Find or highlight approximate positive value in column for a negative appearing in ano

    HI Excel Experts,
    I haven't got any response yet relating to my query.Please help on my query.

    Thanks and Regards,
    Rabi Kumar

  8. #8
    Registered User
    Join Date
    05-23-2015
    Posts
    6

    Re: Find or highlight approximate positive value in column for a negative appearing in ano

    HI Excel Experts,
    I haven't got any response yet relating to my query.Please help on my query.

    Thanks and Regards,
    Rabi Kumar

+ 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. Replies: 2
    Last Post: 08-04-2014, 08:57 AM
  2. [SOLVED] Find consecutive 15 positive or negative numbers in a column
    By Sarangsood in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-19-2013, 05:26 AM
  3. Replies: 2
    Last Post: 11-21-2012, 07:27 AM
  4. Convert negative to positive in sheet containing both positive/negative numbers
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2010, 07:52 PM
  5. Find negative value and apply to next positive value
    By jamphan in forum Excel General
    Replies: 5
    Last Post: 07-16-2008, 04:52 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