Results 1 to 4 of 4

Thread: Need a formula that only show the set cost figure once for each unique User Id
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2016
    Location
    Leicester England
    Posts
    50
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Need a formula that only show the set cost figure once for each unique User Id

    Hi There

    Good Morning

    Need a formula that only show the set cost figure once for eachunique User Id


    I am looking for a formula that give me the result in ColumnC, The formula needs to only count the set cost figure that doesn’t change (ColumnB) for the user ID (Column A) just once .

    A
    B
    C
    User ID
    Set Cost
    Result Want
    A123
    £5.00
    £5.00
    A123
    £5.00
    B234
    £5.00
    B234
    £10.50
    £10.50
    B234
    £10.50
    C245
    £8.24
    £8.24

    If anybody got any ideas of simply formula that can do this,please let me know?
    Many Thanks
    Leicester Fox


  2. #2
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    41,404
    Post Thanks / Like
    Mentioned
    100 Post(s)
    Tagged
    21 Thread(s)

    Default Re: Need a formula that only show the set cost figure once for each unique User Id

    Try something like this.

    Set Cost

    ABC
    1User IDSet CostResult Want
    2A12355
    3A1235
    4B2345
    5B23410.510.5
    6B23410.5
    7C2458.248.24
    8

    Spreadsheet Formulas
    CellFormula
    C2=IF(AND(COUNTIFS(A2:A$10,A2,B2:B$10,B2)=COUNTIF(A2:A$10,A2),COUNTIFS(A$1:A2,A2,B$1:B2,B2)=1),B2,"")


    Excel tables to the web >> Excel Jeanie HTML 4
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  3. #3
    New Member
    Join Date
    Oct 2016
    Location
    Leicester England
    Posts
    50
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need a formula that only show the set cost figure once for each unique User Id

    Hi Peter

    That formula works treat

    Thank You Vey Much.

    The Leicester Fox

  4. #4
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    41,404
    Post Thanks / Like
    Mentioned
    100 Post(s)
    Tagged
    21 Thread(s)

    Default Re: Need a formula that only show the set cost figure once for each unique User Id

    Cheers. Thanks for the follow-up.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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