Time to complete: 60 minutes
It was an interesting challenge
Challenge129_Dat.xlsx (34.2 KB)
BKofford-Challenge129Solution.xlsx (25.6 KB)
30 Minutes
Rating Intermediate
Challenge129_Data.xlsx (28.2 KB)
45 Min
Rating Intermediate
Time to Complete: 1 hour
Difficulty: Intermediate
The megafunction took me a lot of time to understand and comprehend what it was doing.
Time to complete: 30 min.
Difficulty: intermediate
Challenge129_Data.xlsx (33.3 KB)
1 Like
Time to complete: 25 minutes
Rating: Beginner
Comment:
I found the instructions for this problem to be ambiguous. I think it would be more helpful to specify the output desired for each worksheet/column before going into how to do it. I think the solution for the email list could use a little more clarifying that the approvers receiving the reminder email are everyone who has an invoice to approve. Currently, it seems to suggest that we only email approvers who have past-due invoices to approve.
I also found the FILTER and XLOOPUP functions are more helpful than indexing as I achieved the same outcome using less complicated formulas.
Challenge129_Data.xlsx (26.3 KB)
129.xlsx (28.0 KB)
TIME 50
Challenge129_Data- SOLUTION.xlsx (27.7 KB)
1 Like
Time to Complete: 30 minutes
Difficulty: Intermediate
It took a second to figure out the megaformula until I realized I could use the Filter formula. It was cool to see how Excel is improving.
1 Like
Time to complete: 45 Minutes
Difficulty: Advanced
Challenge129_Data5.xlsx (28.1 KB)
1 Like
Time to complete: 50 minutes
Difficulty: Hard
Challenge129_Data.xlsx
Time to complete: 25mins
Rating: decent
1 Like
Time to complete: 2 hours
Advanced
I couldn’t get past the second part. The email list kept showing that there weren’t any past due invoices.
Challenge129_Data.xlsx (24.6 KB)
Time to Complete: 30 minutes
Difficulty: Intermediate
Challenge129_Data.xlsx (28.1 KB)
Time to Complete: 1 hour
Difficulty: Intermediate
Solution:
Challenge129_Data.xlsx (36.0 KB)