Excel Junkies

[pickax]

You need to use the large function. The lines are split below for readability.

=SUM(LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),1),
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),2),
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),3),
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),4),
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),5),
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),6),
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),7)
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),8),
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),9),
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),10))

[tacimala]

Well a question came up at work today regarding Excel and I told them I knew of the perfect place to get the answer! I'm using Excel 2007 now at work and it's fairly tough to navigate once you are used to the old versions. Anyways, we use Excel to keep long lists of URL's and information about these URL's. What we want to do is go through and delete any row that has a duplicate URL so that the same URL is only in our list one time. Anyone (Mike) know a way to get that to work? Thanks!

[stpitner]

if you're using Excel 2007 there's a pretty easy way to do it.  Select all the rows that you want it to compare.  Then go to the Data menu.  There should be a "Data Tools" area in the (what are they called now, ribbons?) toolbar?  Inside there, you should hopefully find a "remove Duplicates" button.  Click that, and it will ask you what column you want to check.  You click ok, and it will tell you how many duplicates it found and removed as well as how many total unique there were.

[SERG]

You need to use the large function. The lines are split below for readability.

=SUM(LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),1),
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),2),
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),3),
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),4),
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),5),
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),6),
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),7)
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),8),
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),9),
LARGE((C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7),10))

Thank you.

[WkeBrd3]

Here's one:
Say I have a pivot table summarizing the total of weekly production. On the pivot table graph, it shows, by week, what the sum of the production was. What I want it to also show is the average. Any idea how to add an average line to a pivot table graph?