So I’m fairly new to using formulas in excel, and my work place has an inefficient system while trying to use excel for data review, so we use a lot of “IF(something=something, Pass, Fail)”. T... HelloMaddieL
a,SEQUENCE(,12),expanded,REDUCE(Header,a,LAMBDA(rollup,a₁,LET(hdr,Hdrsλ(a₁),tracks,Tracksλ(a₁),col,XMATCH(Header,hdr),reordered,CHOOSECOLS(tracks,col),VSTACK(rollup,reordered)));FILTER(expanded,ISTEXT(TAKE(expanded,,1))) The question then is 'Why do my formulas co...
I am a user of Excel 365 and made a decently sized Excel sheet with a lot of calculations. However, one of the people I am making this calculation for doesn't have Excel 365 but owns Excel 2019. I ha... If like this it could be =INDEX($A$2:$A$100,AGGREGATE(15,6,1/(:$A$...
The setup: You're provided with an Excel workbook with 12 sheets for 12 Beatles albums. All 12 sheets have the same fields, but the fields are not in the same order in each sheet. The goal: Roll... mtarler This is a fascinating approach! I had some fun testing this so...
I just wrote a few functions that should theoretically allow you to take an array, chunk it by rows or columns, and then stack them in the other dimensions,...
2John Smith12312312312/12/1950email address removed for privacy reasons 3John Smith12312312312/12/1950email address removed for privacy reasonsAdam Smith11122233312/12/1970email address removed for privacy reasons each row represents an account in which 1, or more owners may be listed. These ...
Hello! So I’m fairly new to using formulas in excel, and my work place has an inefficient system while trying to use excel for data review, so we use a lot of “IF(something=something, Pass, Fail)”. These formulas work great, but I wanted to see if there’s a way to stack th...
Excel Help - Stacking IF Formulas Hello! So I’m fairly new to using formulas in excel, and my work place has an inefficient system while trying to use excel for data review, so we use a lot of “IF(something=something, Pass, Fail)”. T...Show More excel Formulas and Functions Like...
Hello! So I’m fairly new to using formulas in excel, and my work place has an inefficient system while trying to use excel for data review, so we use a lot of “IF(something=something, Pass, Fail)”. T...
I am a user of Excel 365 and made a decently sized Excel sheet with a lot of calculations. However, one of the people I am making this calculation for doesn't have Excel 365 but owns Excel 2019. I ha... lanitheeater If like this ...