Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
If no match leave blank
Im using this formula in excel spreadsheets. =INDEX(Sheet3!B:B,(MATCH(Sheet2!A2,Sheet3!A:A,0))) If I do not get a match: I would like this formula to leave the cell blank instead of #N/A. How can I fix the formula?- puup
- Thread
- Replies: 6
- Forum: Microsoft: Office
-
Group and sum past due columns in a Crosstab query
I Love the PastDue column....but since this will not keep those ugly past due date columns from creating their own identity box, I guess the Access crosstab is not the way to go. It must be simple for Manufacturing supervisors.:) They just want to see qty PastDue and qty per week for 18-20...- puup
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Group and sum past due columns in a Crosstab query
I have Access Crosstab query that Sum's units per week(Monday Dates) by Planner ID. Displays 18 to 20 weeks of data. It looks like: Planner ID 7/7/03 8/4/03 9/2/03 9/8/03(current wk) C 8 D 1 E 4...- puup
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
