Results 1 to 8 of 8

Formula auto fill for sequence problem

Threaded View

  1. #1
    Registered User
    Join Date
    09-21-2018
    Location
    Poland
    MS-Off Ver
    2017
    Posts
    18

    Formula auto fill for sequence problem

    Hello guys,

    Having problem for solving formula problem for AF row with - OK
    If "TAK" appears in one number order - mark everything in this order as "OK"
    If "NIE" appears in whole number order - mark everything in this order as "-"

    For now I came with =IF(OR(AND(W1+1=W2;AF2="OK");(S1="TAK"));"OK";"-") but this doesn't mark as OK numbers below in the same order.

    I have something like this:

    (S) (W) (AF)
    NIE 1 OK
    NIE 2 OK
    TAK 3 OK
    NIE 4 -
    NIE 5 -
    NIE 1 -
    NIE 2 -
    TAK 1 OK
    NIE 2 -
    NIE 1 OK
    TAK 2 OK
    NIE 1 -
    TAK 1 OK

    I need something like this:

    (S) (W) (AF)
    NIE 1 OK
    NIE 2 OK
    TAK 3 OK
    NIE 4 OK
    NIE 5 OK
    NIE 1 -
    NIE 2 -
    TAK 1 OK
    NIE 2 OK
    NIE 1 OK
    TAK 2 OK
    NIE 1 -
    TAK 1 OK

    Can anyone help me with this case?
    Thank you!
    Last edited by Calios; 09-27-2018 at 06:37 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data Capturing
    By zas9313 in forum Excel General
    Replies: 1
    Last Post: 11-21-2014, 03:22 AM
  2. Replies: 1
    Last Post: 01-06-2014, 03:54 AM
  3. Replies: 7
    Last Post: 02-03-2013, 06:25 PM
  4. Replies: 2
    Last Post: 01-22-2013, 07:09 AM
  5. Problem reading formula with ActiveCell.Formula
    By Matija in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2011, 06:10 AM
  6. Formula Problem
    By superkopite in forum Excel General
    Replies: 5
    Last Post: 02-21-2006, 09:05 AM
  7. [SOLVED] Formula problem
    By Mike in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM

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