Forum Discussion
Best way to use maxifs combined with replacing values in "lookup array"
Hi, I am trying to find the best way to create a simple yet interesting formula in excel I have 4 arrays of values all the same size. The lookup array, a "replacement value array" and 2 arrays...
Can you please attach a sample file or share via google-drive or OneDrive so that we can have a look? Show your input data and desired output manually and we will try to automate that output by formula.