Home

I need my formula to not skip cells.

%3CLINGO-SUB%20id%3D%22lingo-sub-684780%22%20slang%3D%22en-US%22%3EI%20need%20my%20formula%20to%20not%20skip%20cells.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-684780%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20my%20results%20to%20populate%20one%20after%20the%20other.%20No%20blank%20cells%20between%20each%20result.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-684780%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-684848%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20my%20formula%20to%20not%20skip%20cells.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-684848%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F358460%22%20target%3D%22_blank%22%3E%40littlebitbent96%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3DIFERROR(INDEX(Table1%5BOrder%20Id%5D%2CAGGREGATE(15%2C6%2C1%2F(Table1%5BAFID%5D%3D%24F%244)%2F(Table1%5BIs%20Refund%5D%3D%24G%244)*(ROW(Table1%5BAFID%5D)-ROW(Table1%5B%5B%23Headers%5D%2C%5BAFID%5D%5D))%2C(ROW()-ROW(Table3%5B%5B%23Headers%5D%2C%5BAFID%5D%5D))))%2C%22%22)%3C%2FPRE%3E%0A%3CP%3EPlease%20see%20the%20table%20on%20the%20right%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-686837%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20my%20formula%20to%20not%20skip%20cells.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-686837%22%20slang%3D%22en-US%22%3EThank%20you!%20I%20am%20gonna%20test%20this%20out%20today.%3C%2FLINGO-BODY%3E
littlebitbent96
New Contributor

I would like my results to populate one after the other. No blank cells between each result.

2 Replies

@littlebitbent96 

 

That could be

=IFERROR(INDEX(Table1[Order Id],AGGREGATE(15,6,1/(Table1[AFID]=$F$4)/(Table1[Is Refund]=$G$4)*(ROW(Table1[AFID])-ROW(Table1[[#Headers],[AFID]])),(ROW()-ROW(Table3[[#Headers],[AFID]])))),"")

Please see the table on the right attached

Thank you! I am gonna test this out today.
Related Conversations