Categories
Mastering Development

Excel get last data in column and return value from different column

I have a table that I’ve created in excel that dynamically inputs data from a stock so my column A is growing every day. I’m looking for a formula that will search column A for the last data available then return back that row’s column H. So based on the photo, it would return the […]

Categories
Mastering Development

Excel get last data in column and return value from different column

I have a table that I’ve created in excel that dynamically inputs data from a stock so my column A is growing every day. I’m looking for a formula that will search column A for the last data available then return back that row’s column H. So based on the photo, it would return the […]

Categories
User Help Web Apps

Arrayformula to Query Sum

Good day, I am trying to run a query that returns the sum of a column based on the query key and have it displayed as an array so that each sum is visible. With my below formula, I am successful. “`=ARRAYFORMULA(query (I27:AN," select COUNT(J), COUNT(K), COUNT(L), COUNT(M), COUNT(N), COUNT(O), COUNT(P), COUNT(Q), COUNT(R), COUNT(S), COUNT(T), […]