Here is my situation:
I have a spreadsheet that contains almost 5,000 rows and need a formula or someway fo make it easier to format. I am currently working in excel 2007 but do have access to 2010.
Column A: Dates
Column B: Dollar Amount
Column C: Name
Column F: Number
I want to total the values in column F based on if the Column A values are the same AND if the values in Column B are the same AND if the values in Column C are the same.
It would also be great if I could automatically get excel to insert a blank row in between each total so that the spreadsheet is easier to view.
Any help would be greatly appreciated. I don't know where to start.
Thanks,
I have a spreadsheet that contains almost 5,000 rows and need a formula or someway fo make it easier to format. I am currently working in excel 2007 but do have access to 2010.
Column A: Dates
Column B: Dollar Amount
Column C: Name
Column F: Number
I want to total the values in column F based on if the Column A values are the same AND if the values in Column B are the same AND if the values in Column C are the same.
It would also be great if I could automatically get excel to insert a blank row in between each total so that the spreadsheet is easier to view.
Any help would be greatly appreciated. I don't know where to start.
Thanks,