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

#### Naveen Gaur

##### New Member
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.

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

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

Replies
0
Views
44
Replies
11
Views
334
Replies
1
Views
59
Replies
1
Views
243
Replies
8
Views
163

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.

### Which adblocker are you using?

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

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