Know the fill rate of an Excel table text
wadefalcon
-
wadefalcon -
wadefalcon -
Hello,
I would like to insert a function or a macro to know the fill rate (in percentage if possible) of registered candidates in my Excel sheet. Also, add a progress bar next to it.
I must adhere to a filling of 12 candidates per sheet for it to be 100% (i.e., the maximum) and the minimum would be 60% (i.e., 7 candidates).
P.S.: There will be several sheets in the same workbook.
I remain available for any further information.
Thank you for your help, sincerely.
I would like to insert a function or a macro to know the fill rate (in percentage if possible) of registered candidates in my Excel sheet. Also, add a progress bar next to it.
I must adhere to a filling of 12 candidates per sheet for it to be 100% (i.e., the maximum) and the minimum would be 60% (i.e., 7 candidates).
P.S.: There will be several sheets in the same workbook.
I remain available for any further information.
Thank you for your help, sincerely.
