-I have two excel sheets.
-sheet1 contains 6 rows and sheet2 50 rows.
- sheet 1 contain some empty cells in each row
-so ihave to find the percentage of empty cells.
-in sheet1 and sheet 2 there are “employee name” rows. sheet2 contains “location” row by that we have to find sheet1 employee belongs to which location and write in the sheet3 percentage of empty cells for each location