**Question description:**

*This user has given permission to use the problem statement for this blog.*

If I have names of some persons that are repeated often in an excel file. Which function in excel will give me the nth row when I use argument like persons name and nth integer which reflect nth time repetition of that name?

Solved by I. U. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
07/05/2018 - 07:11

Hello

User
07/05/2018 - 07:11

hi

Excelchat Expert
07/05/2018 - 07:11

can you share the sample data for this problem?

User
07/05/2018 - 07:12

it is this much only

Excelchat Expert
07/05/2018 - 07:12

let me build a sample..

User
07/05/2018 - 07:12

oky

Excelchat Expert
07/05/2018 - 07:15

please stay here while I work on the problem

User
07/05/2018 - 07:15

oky

User
07/05/2018 - 07:17

4

Excelchat Expert
07/05/2018 - 07:18

dan 2nd instance you need

User
07/05/2018 - 07:19

yes

Excelchat Expert
07/05/2018 - 07:19

or every repete of Dan needs to be highlighted?

Excelchat Expert
07/05/2018 - 07:19

repeat

User
07/05/2018 - 07:19

just second one if put n=2 in argument

User
07/05/2018 - 07:19

function

Excelchat Expert
07/05/2018 - 07:19

ok got it give me few min as it is a bit complex formula

User
07/05/2018 - 07:19

oky

User
07/05/2018 - 07:21

i want to use both name and n= no of times it is repeated to give me a row like if n=2 and name is dan it should be give me the row where dan comes second time

User
07/05/2018 - 07:21

clear

Excelchat Expert
07/05/2018 - 07:21

got you just a few min bare with me :)

User
07/05/2018 - 07:21

oky

User
07/05/2018 - 07:25

r u there

Excelchat Expert
07/05/2018 - 07:26

yes

Excelchat Expert
07/05/2018 - 07:26

still here

User
07/05/2018 - 07:26

done?

Excelchat Expert
07/05/2018 - 07:26

just few more min

User
07/05/2018 - 07:27

4 min remaining

Excelchat Expert
07/05/2018 - 07:27

it will get extended.. at 2 min remaining you would see a promt

User
07/05/2018 - 07:28

i know

User
07/05/2018 - 07:28

i got it

Excelchat Expert
07/05/2018 - 07:28

:)

User
07/05/2018 - 07:29

i am logging out

User
07/05/2018 - 07:29

sry

Excelchat Expert
07/05/2018 - 07:29

2 more min

Excelchat Expert
07/05/2018 - 07:30

[Uploaded an Excel file]

Excelchat Expert
07/05/2018 - 07:30

here

Excelchat Expert
07/05/2018 - 07:30

you please verify

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*