Forum Discussion
Solved
Need to further automate an Excel formula
Hello and thank you in advance. I am using Office 365 and here is the formula which needs more work. I need two things added to it. If you click on the image it will grow larger. 1. I need to wrap i...
The formula in C7 can be changed to
=IFERROR(CHOOSECOLS(FILTER(Data!B5:T144,(Data!D5:D144=1)*(Data!I5:I144<40000)*(Data!J5:J144<40000)*(Data!K5:K144<40000)*(Data!L5:L144<40000),""),1,4,5,8,9,10,11),"")
@HansVogelaar
I didn't know I could do that. My Excel has only first names, revenue numbers, and number of shipments. There is no sensitive data otherwise. Can I attach it here and then delete it later?
I didn't know I could do that. My Excel has only first names, revenue numbers, and number of shipments. There is no sensitive data otherwise. Can I attach it here and then delete it later?
The formula in C7 can be changed to
=IFERROR(CHOOSECOLS(FILTER(Data!B5:T144,(Data!D5:D144=1)*(Data!I5:I144<40000)*(Data!J5:J144<40000)*(Data!K5:K144<40000)*(Data!L5:L144<40000),""),1,4,5,8,9,10,11),"")
- Thank you Hans, I am going to mark this as solved as your IFERROR formula worked great!
Thank you