Finding data points in a row based on condition & then pasting it

Naveen Gaur

New Member
Joined
Oct 10, 2021
Messages
2
Office Version
  1. 2019
Platform
  1. Windows
Hello Everyone,
I need help in selecting particular row based on below logic & then pasting data points of that row.
I need to do this for 2000 rows.

Thank You in advance,
Naveen

Logic for Column H

Find out row having minimum value in Column A under condition that value in Column D is less than Column D value of that row

Example

Row 21, D71 value is 429, Now find out row having minimum in Column A given Column D value is less than D21 =429 Answer is A6, value 18

Now Put Row 6 Column A-F values in Column I-N in row 21


Macro Help.xlsx
ABCDEFGHIJKLMN
1Rank based on Total marksRank based on Mains marksRoll No.Mains MarksInterview MarksTotalMost advantageous Rankholder with lesser marks in Mains but better RankRank based on Total marksRank based on Mains marksRoll No.Mains MarksInterview MarksTotal
21112345644977526
324123457442.2580522.25
433123458445.7575520.75
542123459448.567515.5
655123460441.7570511.75
7613123461427.2582509.25
878123462433.7575508.75
9811123463428.580508.5
109712346444068508
1191412346542682508
12119123466431.7575506.75
13121712346742182503
141318123468420.7582502.75
15146123469441.560501.5
161515123470423.2577500.25
171611123471428.571499.5
18171612347242375498
191819123473414.582496.5
201920123474413.581494.56613123461427.2582509.25
21201012347542964493
RAS 2018 Exam rank
Cell Formulas
RangeFormula
I20,A2:A21A2=RANK(F2,$F$2:$F$21)
J20,B2:B21B2=RANK(D2,$D$2:$D$21)
N20,F2:F21N20=M20+L20
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,147,821
Messages
5,743,393
Members
423,792
Latest member
travisds

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top