optimise

I have a set of data with different groups ("colors"). For each group (color), there are questions that apply to "categories" ("A", "B", "C", etc.). Each has a numerical score. I need to pick the highest scoring question for each category, for each group (color). Example: Group "Blue" has 2...

Hi Peoples, I have x2 cells (user variables) - which through data processes procure a value in another cell. Please - any suggestions as to how to optimise such? Thank you.

Hello everyone. Apologies for what I am sure is a simple question but I am far from an excel guru. I am trying to create a formula that will optimise a data set I have to find the optimum place for a stop loss to maximise profit. Below are two columns showing the price difference between the...

I often create tables in Excel where some cells contain a lot of text while others just contain a single digit or some other short value. With wrap text in cells enabled and then a combination of increasing row height and autofit the width of the columns there is a lot of wasted space in my...

Currently I do this: Code: For CurrentTableRow = WallTableBeginsRow To WallTableBeginsRow + NumberOfWalls If (Cells(CurrentTableRow, BwkBlkStudCol).Value = "Bwk") And (Cells(CurrentTableRow, FloorCol).Value = "GF") Then GFBWKArrayNumber = GFBWKArrayNumber + 1...

Afternoon All, Hope all is well - I've got some code that I've made with macro recorder (still not comfortable enough to write my own) but it isn't fit for use. It clearly needs a variable but I dont know how. Range("F17").Select Selection.Copy Range("D17").Select...