I'm tracking the percent complete (PPC) for individuals and their assigned tasks. I have a problem where index/match returns a "0%" complete if the cell is blank in between cells that have a value. 0 implies that this person failed alView attachment PPC Progress Data Organization.xlsl of their tasks, when in truth, they just weren't assigned any new tasks. Since I use this data in a graph it would be very miss interpretive if the "0%" exists in the data. however, when there is no data in the cell to the right of it "" will show up. I guess a blank and a 0% show up the same in a graph, but if one is looking at the raw data a 0% is misleading compared to an empty cell.
Attached is the spreadsheet im refering to, can someone please help me out??
Attached is the spreadsheet im refering to, can someone please help me out??