formula to lookup multiple fields with multiple matches. convert index match formula to potential vba code
Solved by C. L. in 12 mins
I want to count the colour in a range of cells and have it update count as colour changes occur Have tried this VBA but it does not update unless cell is changed from count-the-number-of-cells-with-specific-cell-color-by-using-vba
Solved by E. Y. in 22 mins
I need a VBA Code that sorts a table by 2 conditions. The first being G3:G252 by a single cell color at the top, the second being an ascending numerical value in the rang A3:A252. I want a VBA code, because this is dynamic data that will be altered.