Hi to all,
I have data like thia,
Name Rank
pietro 30
fabri 35
mauri 60
andrea 45
luigi 50
anna 90
federica 100
julia 120
now I want to pick names from column A with rank difference between name should equal to 30.
Expected result
Name Rank
pietro 30
mauri 60
anna 90
julia 120
Can any one help me in this issue and any help would be highly appreciated.
Thanks and Regards
If your data is in A1:B9, try this, copied down...
=INDEX($A$2:$A$9,MATCH(30*ROWS($A$1:A1),$B$2:$B$9,0))
for the values, you can just type in 30, 60 etc
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you very much FDibbins for your help,
your formula is working fine and i want to know is there any possibility to get rank also along with names like this
Name Rank
pietro 30
mauri 60
anna 90
julia 120
Thanks
What do you mean by rank? can you show me an example?
Rank is just like value nothing more than that but i want to pick names from column A with their ranks and who have difference in rank equal to 30. I want like this
Name Rank
pietro 30
mauri 60
anna 90
julia 120
and your formula giving me like this
Name
pietro
mauri
anna
julia
Hope i explained you well
Thanks
Perhaps you missed this part in post # 2?
for the values, you can just type in 30, 60 etc
Dear FDibbins,
Thank you very much for your help and i think yes i missed
Happy to help and thanks for the feedback
I will mark this thread SOLVED for you, for future reference, you can do this by clicking on the THREAD TOOLS button near the top of the gape
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks