Who to identify least one in excel
Closed
kathapr
Posts
1
Registration date
Thursday July 17, 2014
Status
Member
Last seen
July 17, 2014
-
Jul 17, 2014 at 10:58 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 17, 2014 at 11:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 17, 2014 at 11:38 AM
Related:
- Who to identify least one in excel
- Number to words in excel - Guide
- The system could not identify your location viber - Guide
- How to take screenshot in excel - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Marksheet in excel - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 17, 2014 at 11:31 AM
Jul 17, 2014 at 11:31 AM
kathapr, Good morning.
Suppose you have the range E2:E10 filled with theses texts.
Try to use it:
ARRAY FORMULA
G2 --> =SMALL(VALUE(RIGHT(E2:E10,LEN(E2:E10)-1)),1)
Don't type enter at the end of formula.
Use CTRL + SHIFT + ENTER
If things are ok will appears { and } at the formula.
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose you have the range E2:E10 filled with theses texts.
Try to use it:
ARRAY FORMULA
G2 --> =SMALL(VALUE(RIGHT(E2:E10,LEN(E2:E10)-1)),1)
Don't type enter at the end of formula.
Use CTRL + SHIFT + ENTER
If things are ok will appears { and } at the formula.
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jul 17, 2014 at 11:38 AM
Jul 17, 2014 at 11:38 AM
Hi Kathapr,
You can use the following formula to extract the number from your string:
=SUM(RIGHT(A1,LEN(A1)-1)+0)
NOTE that I use SUM(value+0) to convert the cell property to number (couldn't do it manually for some reason).
Once you extracted your numbers you can use the MIN function to determine the lowest value.
You can also nest the first formula's in the second to use only one cell. Like:
=MIN(SUM(RIGHT(A1,LEN(A1)-1)+0),SUM(RIGHT(A2,LEN(A2)-1)+0),SUM(RIGHT(A3,LEN(A3)-1)+0))
Best regards,
Trowa
You can use the following formula to extract the number from your string:
=SUM(RIGHT(A1,LEN(A1)-1)+0)
NOTE that I use SUM(value+0) to convert the cell property to number (couldn't do it manually for some reason).
Once you extracted your numbers you can use the MIN function to determine the lowest value.
You can also nest the first formula's in the second to use only one cell. Like:
=MIN(SUM(RIGHT(A1,LEN(A1)-1)+0),SUM(RIGHT(A2,LEN(A2)-1)+0),SUM(RIGHT(A3,LEN(A3)-1)+0))
Best regards,
Trowa