Excel formula needed

Closed
Ray - Dec 1, 2015 at 09:43 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Dec 2, 2015 at 03:47 AM
Hello,

Need excel code for min(1-5), N or X

Example data:

1. 3. 5. 2 X. --> 1
X. N. X. X. N. -->N
X x x x x x x. --> x
X 3 2 N. X N. -->2
3 2 x n n 4. -->2

Thinking this is a nest IF formula?

Thanks!

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Dec 2, 2015 at 03:47 AM
if possible, your decision of x vs X is changed, to say X<x, then you can use this

https://www.exceltip.com/excel-text-formulas/find-the-alphabetically-lowest-letter-in-a-list.html
0