If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

A VBA or Function That Could Separate a list of numbers to two different groups with close averages

Thread starter jondavis1987
Start date Mar 2, 2023

jondavis1987

Active Member

Mar 2, 2023

Below is a spreadsheet that I have. Specimen is A1. Density B1. The next specimen is D1. Density E1. Specimen G1. Density H1. So the specimen numbers will always stay the same in the same spot in column A. The density numbers in column B will change. The specimens get organized into two different groups that are supposed to average as close to each other as they can. So E7 averages E2:E4 and H7 averages H2:H4. Is there a way to use vba or a function to take the specimens and in A:B and sort them automatically into two different groups in E and H that would average as close as possible? I ask because the numbers in density are not always this close and it can take a while to find the right groupings.