Forum Discussion
Need to further automate an Excel formula
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),"")
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
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?
As for the date problem, if would be better if you used dates in the headers, formatted with the custom number format mmm. That would make it easier to use them in dynamic formulas.
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
If you can attach a workbook to a reply, you can edit the reply later and delete the file.
Alternatively, you can attach it to a private message to me (click on my avatar).