+ Reply to Thread
Results 1 to 3 of 3

Excel newbie that needs solution for a functions or commands usage.

  1. #1
    Registered User
    Join Date
    03-01-2012
    Location
    Macedonia
    MS-Off Ver
    Excel 2010
    Posts
    9

    Excel newbie that needs solution for a functions or commands usage.

    Hi all
    In the attachment there is a document regarding on what i need.
    It's not too complicated but since i am newbie i cant handle it.
    Here is what i need. (please open the attachment in order to understand)

    Basicly i need column H and I to be equal to column E only on certain conditions.
    If column G is for example (PA, PB, PBL) then numbers from column E to be copied exactly in column H
    and If column G is (TA, TB, TC, C) then numbers from column E to be copied exactly in column I
    Please help me on this.
    Raply on this thread or send me message on mail m_poposki@yahoo.com for the solution if you can please.
    Thanks in advance to anyone that will help.
    Attached Files Attached Files
    Last edited by m_oioisju; 03-01-2012 at 09:07 AM.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,711

    Re: Excel newbie that needs solution for a functions or commands usage.

    For example, in H1: =IF(OR($G1={"PA","PB","PBL"}),$E1,"")
    The same structure for other columns with certain criteria for G1.

  3. #3
    Registered User
    Join Date
    03-01-2012
    Location
    Macedonia
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Excel newbie that needs solution for a functions or commands usage.

    Thanks very much dude. That was helpful. I owe you one!!!
    I would have bought you a beer if you were here.
    Cheers!
    Thanks again mate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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