Forum Discussion
formula & function - Need Help
I have 2 columns of data. Column A with a list of items (say computer SN) and Column B with a list of Sub items (accessories). An Item (column A) can have multiple sub items (column B) and vice versa...
Do you consider using PivotTable? Item for Row Label, SubItem for Column Label. Count of SubItem for Values. PivotTable can also give you the figure about the grand total.