Which formula should i use to display duplicates in another row?

oqs

New member
Joined
Aug 14, 2013
Messages
1
Reaction score
0
Points
0
Hello everybody,

I received an excel test from a possible employer but i can't figure out this one problem. I would appreciate any help or suggestions. I am a novice user of excel.

Thank you!\View attachment problema.xlsx
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Hint: use a counting formula that uses criteria to determine number of matches, range starts from beginning to current row...
 
Top