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!

Excel formula needed
Excel grade formula - Guide
Number to words in excel formula - Guide
Date formula in excel dd/mm/yyyy - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Credit summation formula - Guide

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

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!