tba

  1. T

    VBA to clear duplicate dates in column but keep row

    Good morning, Please help me out with macros that would cleared out duplicate dates on column A but keep all rows. For example clear out the one I have it in red. <tbody> A B C D 1 10/15/2019 lesson plans TBA TBA 2 10/15/2019 homework TBA TBA 3 10/15/2019 extra credit TBA TBA 4...
  2. R

    Trim Function

    Hi, Could someone help me or point me in the right direction, I have this formula =LEFT(MID(A1,FIND("/",A1)+1,LEN(A1)),FIND("/",MID(A1("/",A1)+1,LEN(A1)))-1) It extracts the middle part of: 1113987 / TBA / Apples So the result will be TBA However I have a number of these which sometimes...
  3. K

    can data validation have both a formula and a second choice?

    ....something like this: =INDIRECT(SUBSTITUTE(E14&S14," ","")) plus the second choice, in this case "TBA" so maybe =OR(INDIRECT(SUBSTITUTE(E14&S14," ","")),TBA)

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
Back
Top