Lookup and Return

[smilelock]

Hello,

New to forum stuck on an issue. Here is my sample data below, but what I need done is to check the flag status of an order, if the flag is "l" then i need to check to see if there are any other lines on that order that are not "l", in the data below, I would want only order # 6 and 20 to show as "yes" or some other description letting me know that it meets my criteria. Basically put another way theses are all open orders and the orders with all items on the order being "l" need to be deleted, but I need to know which orders have all lines on that order being "l". Hope I explained myself well enough.

Order # Flag
6 l
11 l
11 l
11 l
11
12 l
12 l
12
13
13
14
15 l
15
15
16 l
16
20 l
111
1323

[Tony Valko]

That's kind of a strange character to use as a flag.

When I copy/pasted the data into Excel I had to try to figure out exactly what character that is.

There are 2 possibilities:

| = char 108
| = char 124

Your data is using char 108. So, try this:

D2 = some order number like 6

=COUNTIF(A2:A20,D2)=COUNTIFS(A2:A20,D2,B2:B20,CHAR(108))

It might be easier to change flags to something like X.

[smilelock]

Perfect, got me where i needed. Thank you very much.

[Tony Valko]

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.