+ Reply to Thread
Results 1 to 2 of 2

Data bars with fractions

  1. #1
    Registered User
    Join Date
    07-20-2011
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    15

    Data bars with fractions

    I am logging how many files I have of a certain type out of how many are available on a central server. I my table looks like

    Have Available Fraction
    1 3 1/3
    15 37 15/37
    16 16 16/16

    Except that column C is (and must be for later calculations) calculated with formula =TEXT(A1,"0")&"/"&TEXT(B1,"0"), and A and BHowever, I need to be able to use a data bar conditional formatting on column C to visually check the progress. How can I extract the numerator and denominator values from the text in C (without using helper columns or columns A or B) in order to use the data bar? I use Excel 2007.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Data bars with fractions

    How about..

    =A1/B1

    and cell format as # ??/??
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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