sparklines from text, Yes/NO, Win/Lose
Results 1 to 4 of 4

Thread: sparklines from text, Yes/NO, Win/Lose
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2005
    Posts
    671
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default sparklines from text, Yes/NO, Win/Lose

    i have a column which is text, either Win or Lose. i wanted to see the streak, how can i make a spark chart based on these 2 text values? thanks

  2. #2
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,745
    Post Thanks / Like
    Mentioned
    66 Post(s)
    Tagged
    7 Thread(s)

    Default Re: sparklines from text, Yes/NO, Win/Lose

    Convert WIN to 1 and LOSE to 0

    In worksheet below sparkline range would be column B

    Excel 2016 (Windows) 32 bit
    A
    B
    C
    1
    formula in B2 copied down
    2
    win
    1
    =(A2="win")*1
    3
    lose
    0
    4
    win
    1
    5
    lose
    0
    6
    win
    1
    7
    lose
    0
    8
    lose
    0
    9
    win
    1
    10
    win
    1
    11
    win
    1
    12
    lose
    0
    13
    win
    1
    14
    lose
    0
    15
    win
    1
    16
    win
    1
    17
    win
    1
    18
    19
    Sheet: Sparky

  3. #3
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,745
    Post Thanks / Like
    Mentioned
    66 Post(s)
    Tagged
    7 Thread(s)

    Default Re: sparklines from text, Yes/NO, Win/Lose

    another formula that returns 1 or 0 is
    =COUNTIF(A2,"win")

  4. #4
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,745
    Post Thanks / Like
    Mentioned
    66 Post(s)
    Tagged
    7 Thread(s)

    Default Re: sparklines from text, Yes/NO, Win/Lose

    If you prefer sparkline created with 1(win) and -1(loss) ..

    use this formula instead
    =IF(A2="win",1,-1)

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
  •