Jump to content

Need help with excel trouble shooting

Guest Ron Howard1

By Guest Ron Howard1
in Operating Systems Help & Support

 Share

Recommended Posts

Guest Ron Howard1

Guest Ron Howard1

Posted
Posted

Let me say this first I tried len(clean(trim and check string using mid and and the value is correct format correct on sheet1 and sheet3 too I am using index and match ,on sheet 3 I have values in f:f from 28.0 to 22.0 and g:g almost the same but values can repeat in different cell so here’s my problem in f3 I have 27.8 and it works correctly and in f5 27.6 it works correctly but f4 has 27.7 and it returns value of n/a it does this on only anything that has .7 so I make another using column J and k and it has same problem but it is with anything with . 6. Like 27.6 I added value, trim, array

 

Continue reading...

  • Replies 0
  • Created
  • Last Reply

Popular Days

Popular Days

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...