remaining quantity bar (related to total quantity)

Originally Posted by vermaccio

leelnich:... the formula recall cell L4:

what is value in the cell L4? shouldn't i use only cell K6 and M6 (Q.ty total and remaining q.ty)?...

maybe is have to use
=LEFT(REPT("|",K6),M6) ?

Not sure what you're referring to. I might have missed some worksheet "cleanup" after de-bugging. Sorry if that caused confusion.

Referencing THIS formula: =LEFT(REPT("|",23),23*M6/K6) , which appears in L6 and is copied down, by trial and error I found it took 23 pipes to stretch all the way across the cell. You may need to adjust that; use whatever fits. The important part is the ratio defined by M6/K6; it determines how many pipes (out of 23) are displayed.

I could have written it like this: =REPT("|",23*M6/K6), but that would return too many pipes for the cell if M6 inadvertently exceeds K6, which would alter your row height if you have selected Wrap Text for that cell.