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.