Hi all.
I have an interesting task that I do not know the solution for. I have a range of data from C72:C101 that contains expenses. The data only goes on this sheet because the data comes from somewhere else, so it is copy and pasted into this sheet and there are formulas on another sheet that organize and calculate the data.
This range of expenses contains big ticket and small ticket line items and I'd like to create a formula or code that will separate the two based on the parameter: "show me every item in the range C72:C101 that exceeds 750".
EDIT: I also need the line item to match with the description in the range B72:B101. For example, my Rent expense exceeds 750 so I'd like the formula to populate the number and the line item
It sounds pretty simple but I can't figure out a workaround. In Google Sheets I could run a QUERY but that function isn't available in Excel unfortunately (I don't think). Hopefully this is possible! I appreciate any and all help
I have an interesting task that I do not know the solution for. I have a range of data from C72:C101 that contains expenses. The data only goes on this sheet because the data comes from somewhere else, so it is copy and pasted into this sheet and there are formulas on another sheet that organize and calculate the data.
This range of expenses contains big ticket and small ticket line items and I'd like to create a formula or code that will separate the two based on the parameter: "show me every item in the range C72:C101 that exceeds 750".
EDIT: I also need the line item to match with the description in the range B72:B101. For example, my Rent expense exceeds 750 so I'd like the formula to populate the number and the line item
It sounds pretty simple but I can't figure out a workaround. In Google Sheets I could run a QUERY but that function isn't available in Excel unfortunately (I don't think). Hopefully this is possible! I appreciate any and all help
Last edited: