Filter function with Formula

DNA133

New Member
Joined
Oct 16, 2006
Messages
1
Hi,

I have a very large database and i am using a filter to help me look at specific data. Is there a way where i can get a calucation for each category i look at even when i filter the data.
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
you can copy the filterd data to another location and do the calculaltions.
this is one way. you can get the unieue values by advance filter and then
create a macro for filtering and copying filtered data.and even doing the calcualtions.
these are some ideas on which you may work.
 

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,372
Have a look at the SUBTOTAL function...

=SUBTOTAL(Fun_Num,Range)

Hope this helps!
 

Watch MrExcel Video

Forum statistics

Threads
1,113,847
Messages
5,544,637
Members
410,627
Latest member
georgealice
Top