User Profile
Analytic_JCPS
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Array formula SUMIF no responding
Hello! I insert an array formula in cell x40 down to x47 (sets as general format) looking for a specific word from a table m38 to t57, in order from number12 down to 6. Columns M, O Q, and S are numerical, and the text or words searched are in columns N, P, R, and T. I'm taking data from a dynamic table, but in the other table just I need results in a column (x) bringing the highest first seven words in ascending order.Solved1.5KViews1like2Comments
Recent Blog Articles
No content to show