# 129|EXCEL – Passion for Payables **URL:** \ **Category:** Challenges\ **Tags:** excel, beginner, xlookup, megaformula, countif\ **Created:** [June 13, 2023, 6:58pm UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754 "2023-06-13T18:58:53Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Audrey\_Vengesai](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/audrey_vengesai/32/7419_2.png) [@Audrey\_Vengesai](https://www.techhub.training/u/Audrey_Vengesai)\ **Post date:** [March 11, 2025, 8:18am UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/21 "2025-03-11T08:18:29Z")
Time to complete: 60 minutes It was an interesting challenge [Challenge129\_Dat.xlsx](https://www.techhub.training/uploads/short-url/nQmqcZ4kPzw27tgd4o6GsFgmTRV.xlsx) (34.2 KB) ---
**Author:** ![Braden\_Kofford](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/braden_kofford/32/7621_2.png) [@Braden\_Kofford](https://www.techhub.training/u/Braden_Kofford)\ **Post date:** [March 11, 2025, 4:35pm UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/22 "2025-03-11T16:35:36Z")
[BKofford-Challenge129Solution.xlsx](https://www.techhub.training/uploads/short-url/yvNEEsmUqNiSYTgAFysY5OCpkwZ.xlsx) (25.6 KB) 30 Minutes Rating Intermediate ---
**Author:** ![Noah\_Bluth](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/noah_bluth/32/7564_2.png) [@Noah\_Bluth](https://www.techhub.training/u/Noah_Bluth)\ **Post date:** [March 11, 2025, 4:54pm UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/23 "2025-03-11T16:54:21Z")
[Challenge129\_Data.xlsx](https://www.techhub.training/uploads/short-url/vuRc3ZmYbciXZPggNcvGmeTNK7I.xlsx) (28.2 KB) 45 Min Rating Intermediate ---
**Author:** ![Miles\_Maynes](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/miles_maynes/32/7377_2.png) [@Miles\_Maynes](https://www.techhub.training/u/Miles_Maynes)\ **Post date:** [March 11, 2025, 5:55pm UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/24 "2025-03-11T17:55:45Z")
Time to Complete: 1 hour Difficulty: Intermediate The megafunction took me a lot of time to understand and comprehend what it was doing. ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/2/230355b0acd162afa72e4c1248245651f7794b0e.png) ---
**Author:** ![Anna\_Montgomery](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/anna_montgomery/32/7416_2.png) [@Anna\_Montgomery](https://www.techhub.training/u/Anna_Montgomery)\ **Post date:** [March 11, 2025, 7:14pm UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/25 "2025-03-11T19:14:29Z")
Time to complete: 30 min. Difficulty: intermediate [Challenge129\_Data.xlsx](https://www.techhub.training/uploads/short-url/eujh65i06hUuCauDznuFn0ywifr.xlsx) (33.3 KB) ---
**Author:** ![Claire\_Walters](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/claire_walters/32/7452_2.png) [@Claire\_Walters](https://www.techhub.training/u/Claire_Walters)\ **Post date:** [March 11, 2025, 7:15pm UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/26 "2025-03-11T19:15:12Z")
[Challenge129Completed](https://byu-my.sharepoint.com/:x:/g/personal/lolaw2_byu_edu/EcwqUB1H3EJLiDX5tREmgs0B4F77O8T1CcgcqQBD888lEA?e=lTR7AE) ---
**Author:** ![Jane\_Cai](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/jane_cai/32/7278_2.png) [@Jane\_Cai](https://www.techhub.training/u/Jane_Cai)\ **Post date:** [March 11, 2025, 9:12pm UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/27 "2025-03-11T21:12:15Z")
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. ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/3/3f868f89f174ddf1dbd82772f106bc22b9935112.png) ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/e/ef7609efe5c752520437423d6dca0127497ffa3f.png) ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/0/0eb17f74ccc4df5944b0c84cd8c945a9e39151b8.png) [Challenge129\_Data.xlsx](https://www.techhub.training/uploads/short-url/nslU8bgALcpjSxIkcbc3Amwq237.xlsx) (26.3 KB) ---
**Author:** ![Elizabeth\_Bisel](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/elizabeth_bisel/32/7449_2.png) [@Elizabeth\_Bisel](https://www.techhub.training/u/Elizabeth_Bisel)\ **Post date:** [March 12, 2025, 12:49am UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/28 "2025-03-12T00:49:05Z")
Time to complete: 50 Intermediate ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/8d79148302b9334f6bf966c71460b660f666f189.png) ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/c/c3029c5ad965ac4df6d5f3695e014ceb5b8368f3.png) ---
**Author:** ![Connor\_Larson](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/connor_larson/32/7446_2.png) [@Connor\_Larson](https://www.techhub.training/u/Connor_Larson)\ **Post date:** [March 12, 2025, 2:33am UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/29 "2025-03-12T02:33:01Z")
Time to Complete: 50 mins Difficulty: Intermediate Solution: ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/6/61209603aa316d9148acffee4f377ec341e5ce5c.png) ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/2/23e4bdae99a6930ef46e126df087027384e7f4d0.png) ---
**Author:** ![Kathryn\_Thompson\_Whi](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/kathryn_thompson_whi/32/7373_2.png) [@Kathryn\_Thompson\_Whi](https://www.techhub.training/u/Kathryn_Thompson_Whi)\ **Post date:** [March 12, 2025, 5:01pm UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/30 "2025-03-12T17:01:35Z")
[129.xlsx](https://www.techhub.training/uploads/short-url/yXqm83Br6n7SYQ2A8vgbkYIa7RC.xlsx) (28.0 KB) ---
**Author:** ![Zachary\_Miner](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/zachary_miner/32/7480_2.png) [@Zachary\_Miner](https://www.techhub.training/u/Zachary_Miner)\ **Post date:** [March 12, 2025, 5:15pm UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/31 "2025-03-12T17:15:35Z")
Time to complete: 20 minutes Rating: Beginner Solution: ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/5/56de4b0ec0e2499fb8243f037badd44b549697b6.png) ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/a/afe32b83f3a140bae771c3e883e49408e2b0b732.png) ---
**Author:** ![Jared\_Divelbiss](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/jared_divelbiss/32/7002_2.png) [@Jared\_Divelbiss](https://www.techhub.training/u/Jared_Divelbiss)\ **Post date:** [March 12, 2025, 8:41pm UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/32 "2025-03-12T20:41:08Z")
TIME 50 [Challenge129\_Data- SOLUTION.xlsx](https://www.techhub.training/uploads/short-url/n1wjbf3KistvhaQPumLNbtZAYaM.xlsx) (27.7 KB) ---
**Author:** ![Kailani\_Schulthies](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/kailani_schulthies/32/7554_2.png) [@Kailani\_Schulthies](https://www.techhub.training/u/Kailani_Schulthies)\ **Post date:** [March 12, 2025, 9:21pm UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/33 "2025-03-12T21:21:02Z")
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. ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/9/9d83abebeafd4bfb778a47d3470de5345af75fb2.png) ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/b/be5b50614a0f0fb82833a4bea29aa4c8d6519c41.png) ---
**Author:** ![Caden\_Anderson](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/caden_anderson/32/7526_2.png) [@Caden\_Anderson](https://www.techhub.training/u/Caden_Anderson)\ **Post date:** [March 12, 2025, 11:18pm UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/34 "2025-03-12T23:18:05Z")
time to complete 45 min intermediate diff ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/f/f0fdae810c02999e6870dd31af4169f6343a77f7.png) ---
**Author:** ![Alejandro\_Sanchez](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/alejandro_sanchez/32/7426_2.png) [@Alejandro\_Sanchez](https://www.techhub.training/u/Alejandro_Sanchez)\ **Post date:** [March 12, 2025, 11:32pm UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/35 "2025-03-12T23:32:03Z")
Time to complete: 45 Minutes Difficulty: Advanced [Challenge129\_Data5.xlsx](https://www.techhub.training/uploads/short-url/cVlEhXqJDfZA5vIdBBe18jy6ikc.xlsx) (28.1 KB) ---
**Author:** ![Rachel\_Hale](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/rachel_hale/32/7503_2.png) [@Rachel\_Hale](https://www.techhub.training/u/Rachel_Hale)\ **Post date:** [March 13, 2025, 12:08am UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/36 "2025-03-13T00:08:12Z")
Time to complete: 50 minutes Difficulty: Hard [Challenge129\_Data.xlsx](https://byu-my.sharepoint.com/:x:/g/personal/rsclark1_byu_edu/Edyxvj07NyNHgykzNoRkAd0B2fw2wfCcTVAu2A21oaqMmw?e=bh53BG) ---
**Author:** ![Knox\_Stokes](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/knox_stokes/32/7534_2.png) [@Knox\_Stokes](https://www.techhub.training/u/Knox_Stokes)\ **Post date:** [March 13, 2025, 12:58am UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/37 "2025-03-13T00:58:18Z")
Time to complete: 25mins Rating: decent [Challenge129\_Data.xlsx](https://byu-my.sharepoint.com/:x:/g/personal/ks957_byu_edu/EZnrutIUBsBLpAUiJLnfMH0BwK2_7xyiobZymRGPbkIAeg?email=knoxstokes1%40gmail.com&e=agziAI) ---
**Author:** ![Kambrie\_Earl](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/kambrie_earl/32/7506_2.png) [@Kambrie\_Earl](https://www.techhub.training/u/Kambrie_Earl)\ **Post date:** [March 13, 2025, 3:58am UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/38 "2025-03-13T03:58:27Z")
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](https://www.techhub.training/uploads/short-url/sRe1uHBbXCjqkidadqyavZxCIW8.xlsx) (24.6 KB) ---
**Author:** ![Jacob\_Critchfield](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/jacob_critchfield/32/7561_2.png) [@Jacob\_Critchfield](https://www.techhub.training/u/Jacob_Critchfield)\ **Post date:** [March 13, 2025, 4:57am UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/39 "2025-03-13T04:57:15Z")
Time to Complete: 30 minutes Difficulty: Intermediate [Challenge129\_Data.xlsx](https://www.techhub.training/uploads/short-url/1Z5QhZu6TVgB1Y1DlPwzfgxWFxi.xlsx) (28.1 KB) ---
**Author:** ![Grace\_Bennett](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/grace_bennett/32/6969_2.png) [@Grace\_Bennett](https://www.techhub.training/u/Grace_Bennett)\ **Post date:** [March 13, 2025, 5:21am UTC](https://www.techhub.training/t/129-excel-passion-for-payables/754/40 "2025-03-13T05:21:29Z")
Time to Complete: 1 hour Difficulty: Intermediate Solution: [Challenge129\_Data.xlsx](https://www.techhub.training/uploads/short-url/vl4zoRBW9piRW9XJUwWY29OFstp.xlsx) (36.0 KB) [Previous page](https://www.techhub.training/t/129-excel-passion-for-payables/754.md?page=1) [Next page](https://www.techhub.training/t/129-excel-passion-for-payables/754.md?page=3)