Nanogirl21
Active Member
- Joined
- Nov 19, 2013
- Messages
- 330
- Office Version
- 365
- Platform
- Windows
I am trying to number each time a matching search item appears in a list. I am using the below formula and it is not working. If the search term appears 4 times then results says 4 for each item instead of being numbered as 1, 2, 3, 4. How can I number each occurance? Can someone please help. Thank you.
=COUNTIF($D$3:D100,D3),"")
=COUNTIF($D$3:D100,D3),"")