Forum Discussion
Update Excel Formula
Hi,
Please assist in updating the formula as explained in the attached file.
My request is to update the INDEX formula to check other criteria.
Here is a solution using array formulas; it should work in all versions of Excel. The helper columns aren't needed.
If you have Microsoft 365 or Office 2021, the formulas could be simplified using the new FILTER function.
7 Replies
Any reason why to use formulas?
Change your list into an Excel table (CTRL-T).
Use the column filters or insert slicers für "Client Name" and "Order nr." and filter on them.
- This was just a sample data and not the entire file.. The formula will help me in pulling data from the Main File into the packing List per client. Anyway, I really appreciate your feedback !
Here is a solution using array formulas; it should work in all versions of Excel. The helper columns aren't needed.
If you have Microsoft 365 or Office 2021, the formulas could be simplified using the new FILTER function.
Hi Hans,
I am trying to update the array formula to include another remark as explained in the attached sheet. I am not able to get it right. Please help.
See the attached version.
- thank you Hans.. The array formula has worked as per my expectation.
