MAX formula?

  • Thread starter Thread starter jane
  • Start date Start date
J

jane

I have to produce a recap that shows any store that is producing >=5%.

For the recap, I need to return the store #, store name, actual % achieved
that is 5% or greater.

The recap is referencing another tab that has the store # in col A, store
nmae in column B, and performance data in column I.

thank you in advance! jane
 
Assuming you have a column that indicates the qualification of >=5%, I would
just do Data > Filter > AutoFilter , and filter on that column, then Copy >
Paste the data to wherever you want.........

Vaya con Dios,
Chuck, CABGx3
 
The user did that but their manager prefers a formula because many users will
be accessing this report on a regular basis but thank you for the suggestion.
 
How many rows of data need to be searched and approximately how many stores
will meet this condition?

If there are 1000's of rows of data and 100's of srores that will meet the
condition then filtering is by far your best solution.

If there are only a few hundred (or less) rows of data and maybe 10's of
stores that will meet the condition then a formula *may* be acceptable.
 
In the case of dealing with inexperienced users, the entire sequence could
be set up to run by macro(s), thereby insuring that the steps taken would be
the same each time, and in accordance with protocol.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top