Jump to content
MSFN is made available via donations, subscriptions and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. ×

Excel If help


Recommended Posts

Hi All

I need help with a excel if statement please what i have is a list containing machine ids





all the above are what we call FM only the first to chars should be used as there are over 2000 ids

the second digit is a zero





these are called SF

there for if C1 = T0 then print FM or c1=nr print SF

i have this so far


and the error i get is

#NAME? TT90185
NONE T003478
#NAME? NR02297
NONE TX00024

hope this make sence




I have got it to work if i only put 2 char in c1 useing this


how do i no only pick first 2 chars

also i need altogether 10 if statement i think excel only does 7 is that right



Edited by smartie91
Link to comment
Share on other sites

Thanks IcemanND

I have this now


which works fine But the problem is now i cant search from this column

A ..... B .......C.........D.......... E......... F

SF 753651 Address Name 2A TX00085

FM 787621 Address Name 2B NR03955

CCM 792373 Address Name 2C NR03024

SF 794187 Address Name 3B NR00127

Column A is the result of above

I need to display how many SF,FM,CCM, there are in 2A,2B.2C.

thanks for your help


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...