# EXCEL Market Import not sorted after price

**URL:** <https://forums.eveonline.com/t/excel-market-import-not-sorted-after-price/455144>\
**Category:** EVE x Microsoft Excel Add-in\
**Created:** [July 6, 2024, 3:48pm UTC](https://forums.eveonline.com/t/excel-market-import-not-sorted-after-price/455144 "2024-07-06T15:48:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lee\_Simmens](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/lee_simmens/32/426638_2.png) [@Lee\_Simmens](https://forums.eveonline.com/u/Lee_Simmens)\
**Post date:** [July 6, 2024, 3:48pm UTC](https://forums.eveonline.com/t/excel-market-import-not-sorted-after-price/455144/1 "2024-07-06T15:48:54Z")

</div>

Hello Everyone,

I got a little Problem. Im importing for Example the market sell order in Jita 4-4 for Compressed Brilliant Gneiss.  
=EVEONLINE.MARKET\_ORDERS\_STREAMING(H1;F1;0;J1)

I get the sell Orders, but they are not sorted after Price. How can i get them sorted after Price.

This would help a lot. Thanks for your help!

![image](https://global.discourse-cdn.com/eveonline/original/4X/4/4/a/44ab58b24a6426b12d13ebb6fccea8f6b66ccd20.png)

---

<div class="post-metadata">

**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\
**Post date:** [July 8, 2024, 1:16pm UTC](https://forums.eveonline.com/t/excel-market-import-not-sorted-after-price/455144/2 "2024-07-08T13:16:27Z")

</div>

You can use the SORTBY function, and wrap it around the function to get the list sorted by your criteria.

=SORTBY(EVEONLINE.MARKET\_ORDERS\_STREAMING(10000002, 999, FALSE),EVEONLINE.MARKET\_ORDERS\_STREAMING(10000002, 999, FALSE).price)

You can have it be more efficient by having the \_STREAMING function in a helper cell, and reference it via =SORTBY(C12#,C12#.price)

Since every time you do a function and directly type in the function like in my first example it requires excel to “run” the function twice, even if it’s going to return cached data, which might lead to scaling issues for performance

---

<div class="post-metadata">

**Author:** ![Lee\_Simmens](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/lee_simmens/32/426638_2.png) [@Lee\_Simmens](https://forums.eveonline.com/u/Lee_Simmens)\
**Post date:** [July 8, 2024, 9:33pm UTC](https://forums.eveonline.com/t/excel-market-import-not-sorted-after-price/455144/3 "2024-07-08T21:33:37Z")

</div>

Thank you for your reply, i will try this out.

This is a very good idea.

Cya

---

<div class="post-metadata">

**Author:** ![Lee\_Simmens](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/lee_simmens/32/426638_2.png) [@Lee\_Simmens](https://forums.eveonline.com/u/Lee_Simmens)\
**Post date:** [July 10, 2024, 5:28pm UTC](https://forums.eveonline.com/t/excel-market-import-not-sorted-after-price/455144/4 "2024-07-10T17:28:05Z")

</div>

It does work like a charm. Thank you very much !