View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DavidH56 DavidH56 is offline
external usenet poster
 
Posts: 82
Default Find difference in min and max value

Hi,

I have a spreadsheet which has 17 columns of data with anywhere from 3,000
to 12,000 rows. I have a header with the autofilter on and sorted by column
F ascendingly. I would appreciate if someone could please create a macro
for me which would evaluate duplicates in column F and for each group of
these duplicates calculate the difference in the minimum and maximum values
which are located in column L and create a new column beside column L (which
would now be column M) to place the results to be located beside the last
similiar item of duplicates. There will be anywhere from 2 to 5 like items
from column F on each report.

Thank you in advance for your assistance.
--
By persisting in your path, though you forfeit the little, you gain the
great.