Forum Discussion

BlueCollarVending's avatar
BlueCollarVending
Copper Contributor
Oct 12, 2023

[SOLVED] Expense Report

So i have a expense report im working on and i need help with some formulas. The report is multiple sheets,  1 sheet is an overview 1 is the main receipt entry  2 are for more detailed entries (ba...
excel
Formulas and Functions
BlueCollarVending's avatar
BlueCollarVending
Copper Contributor
Oct 15, 2023

I tried the formula you posted and it worked but only for a specific cell. And it doesnt allow me to filter the Main PURCHASE REPORT by category and input all the essential data with the choose function. Also what would a formula be to make it autoskip a row?

 

I asked ChatGPT and this is what it sent. Took a bit to get there but....

 

=IFERROR(CHOOSE({1,2},INDEX('Purchase Report'!A:A,SMALL(IF('Purchase Report'!D:D="Your_Category",ROW('Purchase Report'!D:D)-ROW('Purchase Report'!D1)+1),ROW(INDIRECT("1:"&ROWS('Purchase Report'!D:D))))),INDEX('Purchase Report'!C:C,SMALL(IF('Purchase Report'!D:D="Your_Category",ROW('Purchase Report'!D:D)-ROW('Purchase Report'!D1)+1),ROW(INDIRECT("1:"&ROWS('Purchase Report'!D:D))))))), "")

The problem is, is it keeps causing my excel to crash. Plus i dont really understand any of this. I would like to understand some of the code so i could figure out how to make it work properly. 

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Oct 16, 2023
=IFERROR(INDEX('Purchase Report'!A:A, MATCH(1, ('Purchase Report'!D:D="Your_Category")*('Purchase Report'!A:A<>""), 0)), "")

Resources