Forum Discussion

Copper Contributor

Apr 26, 2023

If Statement, But Only Wanting Result If Not Already Shown Above in Table

I have a few tables pulling information about boat parts. The table I'm currently working in has columns for order number [ON], boat number [B], customer part number [CPN], mark [M], our part number...

excel

Formulas and Functions

office 365

HansVogelaar

MVP

Apr 26, 2023

and_rogynous

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

and_rogynous
Copper Contributor
Apr 28, 2023
HansVogelaar
Example.xlsx17 KB
- HansVogelaar
  MVP
  Apr 28, 2023
  and_rogynous
  
  Thanks! Use this formula in the N column:
  
  =IF(AND(COUNTIFS(OPN[ON],[@ON],OPN[CPN],[@CPN])>0,MINIFS([B],[ON],[@ON],[CPN],[@CPN])=[@B]),"X","")
  - and_rogynous
    Copper Contributor
    Apr 28, 2023
    This is very helpful, thank you! The only other question I have is - this makes the "X" that SHOULD be in this column for any order with "?" under the boat number (an older order that we don't have record of boat number) now return blank. Is there a way to adjust for that situation? "?" is the only non-number in the boat number column.