Forum Discussion

Mullikee's avatar
Mullikee
Copper Contributor
May 04, 2021
Solved

Checking Serial Number, VBA or Function help

I have a workbook that contains the issued serial numbers for components. Column A has the serial number and Column B has the part number. I want to have a verification in column C if the serial numb...
excel
Formulas and Functions
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    May 04, 2021

    Mullikee 

    =IF(COUNTIFS($B$2:$B$100,B2,$A$2:$A$100,A2)>1,"Used","Open")

    Fill down.

HansVogelaar's avatar
HansVogelaar
MVP
May 04, 2021

Mullikee 

=IF(COUNTIFS($B$2:$B$100,B2,$A$2:$A$100,A2)>1,"Used","Open")

Fill down.

Resources