stations

  1. Phil Smith

    Compare range to named range for ANY match

    Hi all. I have a named range "Stations". I wish to compare the range (B14:B & final row with any data in) on each of more than 100 worksheets with "Stations" to see if there is ANY match. If there is >=1 match then .... ... Else ... End If I dont know whether the best way to do this is...
  2. R

    Questions with regards with average

    Hello fellow members, I have a question with regards to average that need your kind assistance. If average for 3 stations in first 9 months is $ 980,000 and average for 4 stations in last 3 months is $ 1,020,000. What is the average sales per station in current year ? Thanks.
  3. B

    Finding the right Rank

    Hi, i have a table of locations against each location there are four columns which each have a average and each column has been ranked using the following formula =IFERROR(RANK.EQ(B4,$B$4:$B$135),""). to complicate things not every cell in the columns have an average. <b></b><table...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top