summing
I have a table with names and amount spent, and I am attempting to get a
total for the money spent. However, some of the names are repeated. Is there some way I can sort out the repeats? Thanks! |
summing
Data Filter Advanced Filter select Copy to another location List
range: your data range Copy to: select a blank cell tick on Unique records only "Catherine" wrote: I have a table with names and amount spent, and I am attempting to get a total for the money spent. However, some of the names are repeated. Is there some way I can sort out the repeats? Thanks! |
summing
Thanks.
"Teethless mama" wrote: Data Filter Advanced Filter select Copy to another location List range: your data range Copy to: select a blank cell tick on Unique records only "Catherine" wrote: I have a table with names and amount spent, and I am attempting to get a total for the money spent. However, some of the names are repeated. Is there some way I can sort out the repeats? Thanks! |
summing
I tried that, and it didn't work it said that "The extract range has a
missing or illegal field name." What next? "Teethless mama" wrote: Data Filter Advanced Filter select Copy to another location List range: your data range Copy to: select a blank cell tick on Unique records only "Catherine" wrote: I have a table with names and amount spent, and I am attempting to get a total for the money spent. However, some of the names are repeated. Is there some way I can sort out the repeats? Thanks! |
All times are GMT +1. The time now is 11:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com