R3 US TREASURY Sherman Raw Material Taxes R2 THE SHERWIN WILL Hellenbrands Shop Supplies Raw Material Sort by date low to high Sort A to Z Literal match to Col B Calculated If the columns need to be rearranged or if any of the columns need to be resorted, please let me know.
If there is a formula which can do what I require, please point me to it. I have played with vloopkup, match, and index but have not succeeded yet. I want to query by array to circumvent this limitation. Row 3 Withdrawal Transfer to Loan 0004 Loan Paymentĭ3 formula: limited to 64 query values per cell =IF(ISNUMBER(SEARCH("loan",B3)),"Loan Payment","*") Row 2 Date Description Check # Tax Category Identified The following formula works but is limited to querying 64 values in a single cell.
0 kommentar(er)
