Hopefully I can explain what I am trying to do without sounding like a melon.
I export data from a company created file into excel containing various, ever changing information. What I would like to do is automatically calculate the average "Plate Thk" dependant on the "Program No".
For Example, for rows containing "1" in column "Program No" calculate the average "Plate Thk", and so on for all the other programs.
I would be able to do this if the imported data stayed the same size using data validation and Vlookup, however, my problem is the amount of data and range of different program numbers means data validation with name tables will not work.
I must admit I am a novice at Excel, I've only just managed to figure out how to actually use Vlookup!
I have attached a copy of an example of the data imported. Any help would be appreciated.
Thanks In Advance
Bookmarks