Can I put the result in a new workbook?
How to add this code
Sorry but I think I explain it wrong, I need to make the result in another worksheet instead of wookbook.
and the result seems to be not correct. When I tried this code, the first column of the result turn to be numbers, but in the real data, the first column of the results should be the names not number. Because the original dataset's first column contains people's name instead of numbers.
Hello, its me agian. I am wondering how to add other countifs accourding to the results that we developed in the new worksheets from other columns in the original worksheets. Like if I have column d, e, f, g as well,
and i want to count the numbers of data in each column according to the Column A in ws2