Adding a sequence number to a row

morinia
morinia used Ask the Experts™
on
I would like a formula to compute the sequence number is  red (Column A) on attached spreadsheet when columns "D" and "F" are equal.
Count-IDS.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Anuradha GoliSystems Development / Support Specialist

Commented:
If Cells(i, "D") = Cells(i, "G") Then
  Cells(i, "A").Select
    With Selection.Font
        .Color = -16776961
        .TintAndShade = 0
    End With
 ' Else
  
 ' With Selection.Font
 '       .ThemeColor = xlThemeColorLight2
 '       .TintAndShade = 0.799981688894314
 '   End With
  End If

Open in new window

Hi, morinia.

Is this what you're looking for in A2 (copy and paste to remaining rows)...
=IF(OR(D2<>D1,F2<>F1),1,A1+1)

Regards,
Brian.
Thanks, morinia.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial