I would like to know if there is any way to find if certain excel row has a specific value in any of its columns (column names and index is not constant). I have implemented using for each row. but since my excel has aroun 70k rows, this approach is very time consuming. Please find the input sheet and output that is required
Input excel sample:
Here policy is unique column. I need to find for each category (Coverages, Building, Locations etc) how many polices are failed. In some cases one policy (eg 111) might have failures for multiple columns (limit, rate, deductible). But this should be counted as one instead of 4.
|Category||Total Count||Pass count||Fail count|