Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
to find the difference between time | Excel Worksheet Functions | |||
Find Max Difference | Excel Worksheet Functions | |||
Find rows with a common item and find or highlight difference | Excel Programming | |||
Find the difference between the high & low value of a given set. | Excel Discussion (Misc queries) | |||
FIND DIFFERENCE BETWEEN 50 AND <60 | Excel Worksheet Functions |