+ Reply to Thread
Results 1 to 6 of 6

verfiying with text

  1. 05-05-2016, 08:43 AM #1
    murray83
    murray83 is offline
    Forum Contributor murray83's Avatar
    Join Date
    05-05-2016
    Location
    Daventry
    MS-Off Ver
    365
    Posts
    146

    verfiying with text

    hi need some help please

    have a formula and think i have worked it, but the output is not what i wanted

    the trailer in column should be the same as the trailer column when it is live

    thanks for the help and info
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-05-2016, 08:48 AM #2
    tentson
    tentson is offline
    Registered User
    Join Date
    09-27-2012
    Location
    saudi
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: verfiying with text

    try this formula

    =IF(A3="live",A3,"")
    Reply With QuoteRegister To Reply
  3. 05-05-2016, 08:49 AM #3
    murray83
    murray83 is offline
    Forum Contributor murray83's Avatar
    Join Date
    05-05-2016
    Location
    Daventry
    MS-Off Ver
    365
    Posts
    146

    Re: verfiying with text

    not quite i want it to pull the number from the trailer column

    cheers
    Reply With QuoteRegister To Reply
  4. 05-05-2016, 09:05 AM #4
    tentson
    tentson is offline
    Registered User
    Join Date
    09-27-2012
    Location
    saudi
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: verfiying with text

    Quote Originally Posted by murray83 View Post
    not quite i want it to pull the number from the trailer column

    cheers
    try this formula,

    =IF(A3="live",B3,"")
    Reply With QuoteRegister To Reply
  5. 05-05-2016, 09:06 AM #5
    murray83
    murray83 is offline
    Forum Contributor murray83's Avatar
    Join Date
    05-05-2016
    Location
    Daventry
    MS-Off Ver
    365
    Posts
    146

    Re: verfiying with text

    DUDE !!

    may thanks
    Reply With QuoteRegister To Reply
  6. 05-05-2016, 09:09 AM #6
    tentson
    tentson is offline
    Registered User
    Join Date
    09-27-2012
    Location
    saudi
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: verfiying with text

    welcome. . .
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Based off of text change, text will import into cells, breaks if text is cleared/deleted
    By Butcher1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-17-2015, 03:35 AM
  2. [SOLVED] How to match a cell with text with a range of text and return own text
    By ec4excel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2014, 11:07 AM
  3. [SOLVED] Need to Mod Code on red text, I have VBA to distinguish Paid(Black Text) Unpaid(Red Text)
    By Garbology in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-11-2014, 07:55 PM
  4. [SOLVED] function IF to return text based if text contains exact text
    By in nomine noctis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-05-2013, 06:25 AM
  5. macro that copies text from Excel to Word adds ruby text toggles field codes finds text
    By bkwins in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2013, 12:13 PM
  6. Macro to Parse Text - Import text to Excel from Multiple Text Files & Folders
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2012, 01:05 AM
  7. [SOLVED] Use .text from previous text box in form to prefill text in second text box
    By chromachem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2012, 10:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1