LinkBack URL
About LinkBacks
From a range how do i find largest and smallest number that start with 688 and 670 etc.
Can anyone help me?
From a range how do i find largest and smallest number that start with 688 and 670 etc.
Can anyone help me?
Welcome to the Forum, although I can see that you joined over 4 years ago (nearly 5 years !!).
A picture of a worksheet is not much use - it would be better to attach a sample Excel workbook, and you can do this by following the instructions in the yellow banner at the top of the screen.
Hope this helps.
Pete
Let's say you put the first 3 numbers in A1 like 670
Then use this formula for the largest value
This for the smallest
Please Login or Register to view this content.
Please Login or Register to view this content.
In your version of Excel MAX-IF is an array formula. To avoid the use of array formulae, use:
=AGGREGATE(15,6,$C$1:$D$6/(LEFT($C$1:$D$6,3)="667"),1)
and
=AGGREGATE(14,6,$C$1:$D$6/(LEFT($C$1:$D$6,3)="667"),1)
for the smallest and largest, respectively.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
[QUOTE=Glenn Kennedy;5612844]
Many thanks. I got exactly what I wanted. I am grateful to you.
[QUOTE=JEC.;5612839]
Thanks a lot.
In Excel 2019 you can use MAXIFS and MINIFS, as an alternative.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks