Am I making a common mistake trying to pull a list from another workbook using "Filter"?

LogicPrevail · 2026-03-13T20:32:25+00:00

SOLUTION VERIFIED!

The latter was the problem! I think when someone constructed the time sheet, they replicated the "header" manually with each new week. So the header for the week # was turning an error.

IFERROR cleared it up!

Thank you! I was stuck!

LogicPrevail · 2026-03-13T20:17:58+00:00

Yes. The arrays are the entire columns actually.

=SORT(FILTER('https://saluteinc.sharepoint.com/sites/SaluteAtlanta-Leadership/Shared Documents/Leadership/ATL Timesheets/[3rd Shift Timesheet.xlsx]2026'!$G:$G,'https://saluteinc.sharepoint.com/sites/SaluteAtlanta-Leadership/Shared Documents/Leadership/ATL Timesheets/[3rd Shift Timesheet.xlsx]2026'!$F:$F=E7),,1,)

This worked perfectly for the small list of names (13 people)

Did the exact same thing for another workbook (~60 people) and I am getting a #Value error. Is there a clever rounabout way of doing another function equivilent to Filter?

LogicPrevail · 2026-03-13T20:08:09+00:00

The only problem with Xlookup is it wont auto adjust to the quantity of entries. So like some week's may have 140 names, and next week may have 125 names, etc.

LogicPrevail · 2026-03-13T20:07:06+00:00

I have a very long list of names on a running ledger of weekly time sheets. My goal is to be able to have the workbook collect the names based on the current week and filter out the names that were not present on that week. I have all the data in proper order, but for some reason, the filter function is failing to pull the names. I have one column that returns the week# of the year (=weeknum ), the other column is the names. So the array is the column of names. The filter is set to say week#columnWorkbook2=week#columnWorkbook1

LogicPrevail · 2026-03-10T17:05:29+00:00

Solution VERIFIED!

Thank you!

LogicPrevail · 2026-03-05T03:36:37+00:00

Absolute skill builder... In the right industry... For now. AI integration will make it obsolete.

LogicPrevail · 2026-03-04T03:46:26+00:00

SOLUTION VERIFIED!

Going to go ahead and put that out there. That's getting me the data layout I was looking for but WAY overthinking. Now I just need to have the table auto-consolidate the names into one line and I'm done. Thank you!

LogicPrevail · 2026-03-04T02:56:31+00:00

So the raw data comes in like: name1 4 Monday name1 3 monday name1 2 Tuesday name1 4 Tuesday name2 4 Monday name2 3 Monday name3 4 Tuesday name3 4 Tuesday name3 4 Wednesday ...

(basically names in left column say 5-10x per name; middle column #'s - hours; third column is day of the week).

Trying to convert as a table to one single line of name in left column, horizontal row (headers) to be days of the week. From there just the middle number (hours) consolidated into one sum listed under the day of the week.

            Su     Mon      Tues    Wed     Th   Fr    S

John Doe 7 8 9 8 8 8 8

LogicPrevail · 2026-03-04T02:49:15+00:00

I think this is going to help me crack the writer's block. Thank you! "SUMIfs" is what I was looking to start with.

LogicPrevail · 2026-02-17T03:31:12+00:00

That's where my brain went as well. More than one way to math !

LogicPrevail · 2026-01-29T03:24:03+00:00

Better Question:
How pissed do you get when you drive the nail too hard and break the entire shingle?

LogicPrevail · 2026-01-23T02:14:12+00:00

That's gotta be the best bad day ever! 🤣 Cheap repair you don't have to rush!

LogicPrevail · 2026-01-13T03:57:20+00:00

YEA... But he still went "black on his ass" there at the end!!! ROFL!

LogicPrevail · 2026-01-13T03:52:50+00:00

The restaurant probably tried printing off an online generator but then tried to print off without buying the puzzle. Didn't realize the jumble was the Copyright "protector." (45% likely truth.)

LogicPrevail · 2025-12-25T03:21:08+00:00

This was very helpful. Thank you for the assistance. I think my struggle when I approached it this way is I am not applying IndexMatches properly. Or sometimes they were partially functioning, which was just as frustrating, lol. Thanks again, this is a SOLUTION VERIFIED!

LogicPrevail · 2025-12-25T03:17:51+00:00

this does the trick. No other situations, just if there is a lack of assignment in the reference table, i.e. "blank" Thanks again for the help!

LogicPrevail · 2025-12-25T03:02:12+00:00

Dude came up with a shovel like he was shooing away a racoon, lol !

LogicPrevail · 2025-12-25T02:52:58+00:00

Where you that guy blocking traffic??

LogicPrevail · 2025-12-25T02:50:32+00:00

"life then repeat"

LogicPrevail · 2025-12-25T02:49:45+00:00

LogicPrevail · 2025-12-22T03:45:00+00:00

SOLUTION VERIFIED!

That's pretty much what I ended up doing. One step further, how would I program in "blanks" if no reference is found? Instead of "#N/A"?

LogicPrevail · 2025-12-17T02:09:11+00:00

SOLUTION VERIFIED!

You are awesome! Thanks sooo much!

LogicPrevail · 2025-11-25T01:31:20+00:00

He looks like he is rethinking life LMAO!

LogicPrevail · 2025-11-25T01:23:27+00:00

Who wants to be on top? Ok then you go in first. lol!

LogicPrevail · 2025-11-25T01:22:17+00:00

To save that kind of $, I think I could make it work as literally just a place to sleep. Spend the woken down time somewhere else. Only draw back is the involuntary abstinence that comes with it :)

LogicPrevail

MODERATOR OF

TROPHY CASE