I have an output excel which will generate after running the macro.
In a column “Credit/Debit” contains the value “C”(credit) and “D”(Debit).
the “C” and “D” should be same.
But in my case “C” contains for 20 times and "D"19 times.
I need a condition to write the “D” for one time to match the 20 records with “C” and i need to assign value “0” in credit amount column and “0” in debit account column(this condition only if there is difference between “C” and “D”)
Someone please guide me on this.
i.e if “C” presents for 20 times “D” also presents for 20times.
Hi @Palaniyappan,
What if both “credit” and “debit” values columns are in same column at that time how could we put the condition for the same(you have done for two separate individual column), sometime data will be in single column rather than separate.
Please guide me in this.