Previous Topic Next Topic

Excel formula needed

Closed
Ray - Dec 1, 2015 at 09:43 PM
rizvisa1 Posts 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses