comparing text

  1. S

    IF statement is not working while comparing Text

    Hi, here is the problem. In following table at the place of "Angle" I fetch data using following formula. =IF(A2 = "<<<","Ingress",LEFT(A2, SEARCH(" ",A2,1))) <tbody> Description Angle Aspect Dg <<< Ingress Trine Venus Trine </tbody> Now at "Aspect Dg" I tried using following formula...
  2. R

    Comparing Textual Data producing numerical information

    Hi all OK I am tracking Students BTEC grades (a UK course) and am going round and round in circles The Data Range is the same in both columns A&B. This is arrayed order below Dist* Dist Merit Pass Fail Column A is students Targeted Grade and column B is Students current Progress I want to...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top