Results 1 to 4 of 4

Search columns with similar values

Threaded View

  1. #1
    Forum Contributor vijay2482's Avatar
    Join Date
    03-03-2009
    Location
    Paris,France
    MS-Off Ver
    Excel 2003
    Posts
    263

    Search columns with similar values

    Hi all,
    Thanks for all the previous help.
    I have a issue which has to be solved.
    If column 12 has value one(1) less than column 23 then
    check the next rows, if column 22 in next row has the same value as column 23 in previous row then
    clear the "X" in column 6 or in column 7 or in column 8 and write "?" instead of "X".
    eg:
    4296076M97 in column 12 and 4296076M98 in column 23 in a row then
    if 4296076M98 in column 22 of the next row then
    clear "X" in column 6 and write "?" in column 6.

    In need of help badly.
    Thanks in Advance.
    Attached Files Attached Files
    VIjay

    If you find any of the post useful to your question, please add to the contributor's reputation by clicking the blue scales icon in the blue bar of the post.

Thread Information

Users Browsing this Thread

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

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