Results 1 to 4 of 4

Simplify formula

Threaded View

  1. #1
    Registered User
    Join Date
    04-30-2008
    Posts
    14

    Simplify formula

    Any help would be appreciated.

    This seems like a simple enough concept to me. I want to compare two values, A8 & C8 to all preceeding sets of values in the given column. If they match any other set, I'd like one value and if they do not I'd like another. In other words, I'd like to identify the first instance of sets within identified columns.

    I can make it work but it seems dirty and instead of 8 test lines I would be looking to extend it down the entire column. Can you help me clean it up?

    =IF(OR(AND(A8=A1,C8=C1),AND(A8=A2,C8=C2),AND(A8=A3,C8=C3),AND(A8=A4,C8=C4),AND(A8=A5,C8=C5,AND(A8=A6,C8=C6),AND(A8=A7,C8=C7))),0,1)

    Thanks for your help.
    Last edited by ShockG; 04-30-2008 at 07:12 PM.

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