How do I get Vlookup to return multiple matches?
i hv sample.xlsx
Symbol Time Price Quantity
GREG.W0006`N 14:59:59 2.1 1,000
CLPL.W0014`N 14:59:59 3.1 902
CLPL.W0014`N 14:59:59 3.1 1,000
YORK.N0000`N 14:59:56 17.6 1,900
DIAL.N0000`N 14:59:56 9.3 1,000
BIL.N0000`N 14:59:56 3.3 3,000
MBSL.N0000`N 14:59:55 19.3 500
MBSL.N0000`N 14:59:55 19.3 200
MBSL.N0000`N 14:59:55 19.3 100
MBSL.N0000`N 14:59:55 19.3 1,000
I Want lyk this
time price volume
MBSL.N0000`N 14:59:55 19.3 500
14:59:55 19.3 200
14:59:55 19.3 100
14:59:55 19.3 1,000
14:59:55 19.3 10,000
14:59:55 19.4 500
14:59:55 19.4 2,000
14:59:55 19.4 100
14:59:55 19.4 1,500
14:59:55 19.4 2,000
pls download nd solve thise sample.xlsx
Bookmarks