# Highest and lowest value in field

**URL:** <https://community.automationedge.com/t/highest-and-lowest-value-in-field/7989>\
**Category:** Process Studio\
**Tags:** rpa, process-studio\
**Created:** [April 4, 2023, 11:19am UTC](https://community.automationedge.com/t/highest-and-lowest-value-in-field/7989 "2023-04-04T11:19:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![amavadut](https://avatars.discourse-cdn.com/v4/letter/a/34f0e0/32.png) [@amavadut](https://community.automationedge.com/u/amavadut)\
**Post date:** [April 4, 2023, 11:19am UTC](https://community.automationedge.com/t/highest-and-lowest-value-in-field/7989/1 "2023-04-04T11:19:57Z")

</div>

Hi all,  
I want to fetch highest and lowest value in a field.  
How to get it?  
Plz hlp

---

<div class="post-metadata">

**Author:** ![viniciusfbs](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.automationedge.com/viniciusfbs/32/1388_2.png) [@viniciusfbs](https://community.automationedge.com/u/viniciusfbs)\
**Post date:** [April 4, 2023, 12:26pm UTC](https://community.automationedge.com/t/highest-and-lowest-value-in-field/7989/2 "2023-04-04T12:26:35Z")

</div>

Amavadut,  
Do you want get the max/min value from multiple columns of a single row or a single column from multiple rows? try the “group by” step.