Good Morning Experts,
Could i ask for some help please,
I have a range of cells from H2-H500 and L2-500,
I need a formula to tell me the Percentage of cells with a value, for example if i had 100 rows one mark on each row would = 1% no matter if their were more marks on a single row across the H-L range.
I really hope this makes sense i have attached a picture to help.
Thank You,
Could i ask for some help please,
I have a range of cells from H2-H500 and L2-500,
I need a formula to tell me the Percentage of cells with a value, for example if i had 100 rows one mark on each row would = 1% no matter if their were more marks on a single row across the H-L range.
I really hope this makes sense i have attached a picture to help.
Thank You,