• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
find unique values as highest values
#1
Please use this data range and give me all (1st,2nd,3rd,4th,5th..............last) highest values using single formula only one time. and plz take care all same duplicate values.

98
98
89
75
65
71
70
75
65
50
55
59
98
89
45
40
41
25
50
  Reply
#2
please find attachment Smile


Attached Files
.xlsx   attachment.xlsx (Size: 8.96 KB / Downloads: 29)
  Reply
#3
sourabh sharma:- plz use only single formula not first max then large this is not a correct solution for this question because when i want direct 2nd,3rd heightest then this solution is not helpful so plz do not use any base as first use max then you use large formula.
  Reply
#4
Sourabh sharma:- plz see this is the better and complite solution of this find unique values as heighest values in this solution we will find any randomly heightest values between (1st,2nd,3rd,4th,5th..................last). when every we face these type of problems when we find randomly heightest values between (1st,2nd,3rd,4th,5th..................last) at this time this solution is very helpful for us.


Attached Files
.xlsx   Solution of find unique values as heightest values.xlsx (Size: 9.16 KB / Downloads: 20)
  Reply
#5
(24-Jun-2018, 04:53 PM)sourabh sharma Wrote: Sourabh sharma:- plz see this is the better and complite solution of this find unique values as heighest values in this solution we will find any randomly heightest values between (1st,2nd,3rd,4th,5th..................last). when every we face these type of problems when we find randomly heightest values between (1st,2nd,3rd,4th,5th..................last) at this time this solution is very helpful for us.

Super bro ur genius
  Reply


Related Topics
Topic Author Replies Views Last Post
  Formula Create numbers 1 to 10 in a range of cells so that individual values cannot be delete prashantbverma7@gmail.com 1 1,391 24-Apr-2019, 02:50 PM
Last Post: prashantbverma7@gmail.com
  Formula Populate corresponding values basis of Title name and Code Lovedeep sharma 5 2,783 04-Jun-2018, 05:53 PM
Last Post: Lovedeep sharma
  Formula Find the Unique data devendra_dev20 3 2,405 31-May-2018, 11:53 AM
Last Post: Subhash Kumar

Forum Jump:


Users browsing this topic: 1 Guest(s)