Hi,
I have excel sheet with 5 sheet i want count of one of my column by comparing with all 5 sheets
Status ->sheet1 Status ->sheet2 Status->sheet3 Status->sheet4 Status->sheet5
123 123 456 344 123
456 234 234 234 456
789 789 123 123 789
output
123 ->count=5
456->count=3
789->count=3
234->count=3
344->count=1
Thanks in advance