+ Reply to Thread
Results 1 to 3 of 3

COMPLEX FORMULA PLEASE ? :s

Hybrid View

joelabar COMPLEX FORMULA PLEASE ? :s 05-19-2017, 02:30 PM
sandy666 Re: COMPLEX FORMULA PLEASE ?... 05-19-2017, 02:36 PM
shg Re: COMPLEX FORMULA PLEASE ?... 05-19-2017, 02:48 PM
  1. #1
    Registered User
    Join Date
    05-19-2017
    Location
    Malta
    MS-Off Ver
    2013
    Posts
    1

    COMPLEX FORMULA PLEASE ? :s

    excel test.PNG

    Hi,

    I would like to automate something but no clue how

    I need to compare cells to other cells and if there is a mismatch, then the mismatching value has to be pasted.
    concretely, if Tip Bet is not in B2, it need to be pasted in C2. AND if EGB is not in B2, it needs to be pasted in C2 as well. Same thing for all B cells with all D cells.

    Is it even possible?

    Thanks

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: COMPLEX FORMULA PLEASE ? :s

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.
    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
    Include in the attachment any code you're currently using (whether it works or not) and an After of what you wish the output to be.

    To attach a file to your post,
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply


    After that you should see attachment in your post

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: COMPLEX FORMULA PLEASE ? :s

    Welcome to the board.

    Please take a few minutes to read the Forum Rules about thread titles, and then amend yours accordingly.

    Thanks.
    Last edited by shg; 05-22-2017 at 10:47 AM.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Complex formula getting moer complex
    By Trebor777 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-02-2017, 01:39 PM
  2. [SOLVED] Use an existing cell formula for creating a new more complex formula
    By dubcap01 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2014, 07:41 AM
  3. complex AVG formula
    By koosh1986 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-22-2014, 06:46 PM
  4. Complex formula using IF THEN ELSE
    By daymaker in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-05-2011, 10:05 AM
  5. Complex Formula using IF THEN ELSE!
    By daymaker in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-05-2011, 01:10 AM
  6. [SOLVED] Complex formula
    By Marc in forum Excel General
    Replies: 8
    Last Post: 10-19-2005, 10:05 PM
  7. Help with a complex formula
    By frank.freeman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-03-2005, 02:05 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1