How to lookup and select top 4 data and put with details into another sheet

afmrubayat

New Member
Joined
Nov 29, 2009
Messages
27
Hi Good Day!
How to use HLookup by date and combined use of large to find top 5 or N number with related data to another sheet.
or any other solution for following:
I want to retrieve Following Data from Sheet 1 to Sheet 2 based on date to be lookup, with top 20 with respective data.
When another date inserted in cell A1 of sheet 2 date will collect form Sheet 1 and Sheet 2 will be updated.
Sheet 1 will be like this with huge raw data:

ABCDEFGHIJKLMNOPQRST
1BOIDBO Short Name
2CreditsDebitsMovementCreditsDebitsMovementCreditsDebitsMovementCreditsDebitsMovementCreditsDebitsMovementCreditsDebitsMovement
31201950000015747EBL Securities Limited18041800649100010020022002001800100018005000500100021001000
41205720053777844NLI Securities Limited04020000200020050020010000100056650726502000210002100
51203490006793073Shanta Securities Limited1000010001600193251757510000100022201002220100001000100100100
61204220018014574International Leasing Sec. Ltd80008005005050000500030003002000050002000100
71204480020376044IIDFC Securities Limited100010050003005000050001600063800160000205010925200015403040
81205660050208183Trust Bank Securities Limited01001000700000200000170180170182300290060010000500
91204490020697475Bank Asia Securities Limited0398059200003975030000300003000020000200010925010925
101205050043090289A. K. Khan Securities Limited3802302185007000030001100011005400116755400200100100600756500

<tbody>
[TD="colspan: 3"] 26-Aug-16 [/TD]
[TD="colspan: 3"] 27-Aug-16 [/TD]
[TD="colspan: 3"] 28-Aug-16 [/TD]
[TD="colspan: 3"] 29-Aug-16 [/TD]
[TD="colspan: 3"] 30-Aug-16 [/TD]
[TD="colspan: 3"] 31-Aug-16 [/TD]

</tbody>

Sheet 2 will be like this
Based Sheet 1 data cell C1 date to be lookup, with top 3 with respective data in A2:E5
ABCDEFGHI
131-Aug-16
2Sl. No.BO IDBO NameNo. of shares
311204490020697470Bank Asia Securities Limited10925
421205720053777840NLI Securities Limited2100
531204480020376040IIDFC Securities Limited2000

<tbody>
</tbody>

Thanks in advance for your kind support.

Regards,
Rubayat
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Forum statistics

Threads
1,223,098
Messages
6,170,099
Members
452,301
Latest member
QualityAssurance

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
Back
Top