Jun-10-2019, 01:19 PM
I have a list of data in .xlsx The data is in column W
the data includes 1. ACCEPTABLE 2. UNACCEPTABLE
I want to count the number of ACCEPTABLE and total of both ( ACC and UNACC ) and the formula would be
ACCEPTABLE divide by number of ACCEPTABLE + UNACCEPTABLE * 100
I want the data to be shown at the last row of COLUMN W
The data layout would be same in every workbook only the number of ACC and UNACC would change
HOW WOULD I ACHIEVE THIS IN OPENPYXL?
Thanks in advance!
the data includes 1. ACCEPTABLE 2. UNACCEPTABLE
I want to count the number of ACCEPTABLE and total of both ( ACC and UNACC ) and the formula would be
ACCEPTABLE divide by number of ACCEPTABLE + UNACCEPTABLE * 100
I want the data to be shown at the last row of COLUMN W
The data layout would be same in every workbook only the number of ACC and UNACC would change
HOW WOULD I ACHIEVE THIS IN OPENPYXL?
Thanks in advance!