Using Vlookup Or Match Function with the duplicated data will pick only the
first match and it wont pick the second or third occurrence of the data as
expected. In your case your data is having 4 zero values in Total and your
data needs to be get sorted by the Total Value. So we are setting the
T
One more thing, i want the data in the automated sheet to be arranged in
order of the largest amount down to the least figure
On Fri, Aug 24, 2012 at 8:35 AM, Hilary Lomotey wrote:
> Nice its working,this is a beautiful formula pal , i am learning new stuff
> everyday , but tell me what is the e
Nice its working,this is a beautiful formula pal , i am learning new stuff
everyday , but tell me what is the essence of =--(ROW()&O2) in the formula?
thanks
On Fri, Aug 24, 2012 at 4:47 AM, Ms-Exl-Learner .
wrote:
> Refer the attached excel for modified solution.
>
> Let us know in case of any
Hello Bosses,
PFA,
i am trying to sort my data(in sheet1) by the largest figures(in sheet 2),
i am getting a num error in the formular and i also realised that when two
figures have same figure it repeats the first instance all though i thought
the below formula will resolve that. kindly assist.