I want an Excel Sheet which can analyze my data through Python and give results for me.
I will give 43 fields, it needs to analyze the data like it should check the data mentioned in a certain cell is valid or not. If dates are having double slash then it should mention to me as invalid with the field name.
Then In certain fields only numeric values and N.A. are valid then it should mention as that field is filled with wrong Identity.
Then in Certain fields it should have only cost value or N.A. in that costing after decimal point it should have two zeros in it.
One field in the excel should depends on all the 43 fields with certain conditions.
2 to 3 fields should have only certain values other than those then it will be highlighted as an invalid.
Some Cost fields should be the sum value of other costing fields.
This all those things I need it in a single excel macro sheet.
Thanks and Regards