# Excel - IF Function Problem - Expert Solution

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
Excelchat Expert 07/05/2018 - 07:30
here
Excelchat Expert 07/05/2018 - 07:30

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.