Excel help please

[InorganicMatter]

This isn't real programming, but I think you programmers could help me best.

I have got two columns: number one has stores, number two has that store's net sales. I need a way to figure out the stores with above-average sales. I can compute the average (duh!), and index the cells, but is there a way to make the index function spit out all cells in the left column where the cells in the right column are greater than the computed average? I can understand the "programming logic path" I need to take, but my understanding of Excel is very limited.

 

[Johnny Lightning]

Not sure if this will help, but if I were in your shoes I'd do a few things. One, I'd use 'Sort' in the 'Data' menu and sort the stores based on net sales, then you at least know approximately the upper or lower half of your list will be above/below average. Second, under 'Format' is 'Conditional Formatting' and you could format the net sales cells to be highlighter if they're higher than the cell where you've computed the average.

Lastly, and this is probably closests to what you're shooting for, I'd make a third column and put in this fuction:

IF(XX>$Y$Y,XX,"") where XX is the cell with the net sales for the store on that row and YY is the cell with the average net sales value. This way you should create a column that only shows the net sales for those stores achieving above average.

I hope this at least helps a bit.