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.
Bookmarks