Hi Guys
from columns E till O i have some data
is thr any way via vba i can consolidate this data in the form as shown in Column Ato C
thankyou
regards
Why is the data entered like that?
Attach an example workbook.
Why is the data so disorganised?
It's a mess, can't you request a better format. If not copy and paste to one table and use COUNTIF. You n nest multiple COUNTIF functions to keep the data as is.
Pleased to help.
Post back if you need further help.
Visit my web site, http://www.excel-it.com, for more examples and some helpful articles.
Don’t have an account yet? Register yourself now and be a part of our community!
