Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Help on this one would really make my day - I am a total novice on
macros / programming but I have this monster of a data in my hands that needs to be clarified.. so please - the simpler the solution the better. Ok, here is the scenario: Column A has a list of numeric values. The list is very long and the values are on every row ie there is a value on every row way down the sheet. On column B I need to select the biggest value from every set of three values on the column A. In other words, in cell B1 I need the biggest value of A1:A3, in B4 the biggest value of A4:A6 etc. Now, this could simply be done by copying the formula MAX in the proper cells in column B, but the list of values is too long, so a macro is probably needed. THANK YOU! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with Looping Macros | Excel Worksheet Functions | |||
Looping Macros that change | Excel Discussion (Misc queries) | |||
Event Macros Help Needed | Excel Discussion (Misc queries) | |||
looping formulas | Excel Worksheet Functions | |||
Looping macros using VB code | Excel Discussion (Misc queries) |