I am trying to get a list of Assembly Parent items that were sold for a specific date. I have attached my file. When I run the report I get 80 duplicate rows. What am I doing wrong.
thanks,
Amy Becker
Marshall Wolf Automation
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Amy -
Your functions in columns H, J, and K all use absolute references (dollar signs on both the row and column).
e.g., =NF($E$6,"3 Document No.")
This means the only cell E6 will ever be used by any of those functions.
Try: =NF(E6,"3 Document No.")
Please sign in to leave a comment.