hi,
i have a sheet in which one colum have name of cities & other have diffrent category of cities. i want that every city have count of every category in front of every category without pivot table use. which formula can be used. please help me