View Full Version : collecting particular type of fileds
sureshprabhu
02-06-2007, 05:10 AM
Hi!
I want to collect some common fields in my list. In detail, Lets think that I have one list of daily expenses, from that list I want to collect a particular type of expenses. How can I do this? Help me!
Thanks in advance,
SureshP
Charlize
02-06-2007, 05:17 AM
maybe autofilter ?
Charlize
ps. a bit of data to work with would be helpfull
sureshprabhu
02-06-2007, 05:26 AM
Sorry Charlize! I didnt get you!
Norie
02-06-2007, 11:38 AM
What do you mean by 'collect'?
Perhaps SUMIF or COUNTIF?
Charlize
02-06-2007, 04:36 PM
maybe autofilter ?
Charlize
ps. a bit of data to work with would be helpfull
Which part you didn't get ?
Let's say you have several columns (date,description,categorie,amount)
For categories you have : home, car, gas, water, electricity ...
With autofilter you can filter on categorie and/or any of the 4 columns.
Charlize
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.