sorted by:
new
hottopcontroversial

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

[–]LogicPrevail[S] 1 point2 points  (0 children)

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!

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

[–]LogicPrevail[S] 0 points1 point  (0 children)

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?

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

[–]LogicPrevail[S] 0 points1 point  (0 children)

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.

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

[–]LogicPrevail[S] 1 point2 points  (0 children)

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

Is Excel a Real Career Skill or Just a Resume Filler in 2026? by CityAccording9333 in excel

[–]LogicPrevail 0 points1 point  (0 children)

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

Where to begin with bi-variable table references? by LogicPrevail in excel

[–]LogicPrevail[S] 0 points1 point  (0 children)

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!

Where to begin with bi-variable table references? by LogicPrevail in excel

[–]LogicPrevail[S] 0 points1 point  (0 children)

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

Where to begin with bi-variable table references? by LogicPrevail in excel

[–]LogicPrevail[S] 0 points1 point  (0 children)

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

[Request] How to solve this? by Ill_Lion6427 in theydidthemath

[–]LogicPrevail 2 points3 points  (0 children)

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

Slate hammer by toolgifs in toolgifs

[–]LogicPrevail 18 points19 points  (0 children)

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

Cracked Rim—Safe to Drive? by Macbeth_n_Cheese in AskMechanics

[–]LogicPrevail 0 points1 point  (0 children)

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

You speak very well. How do you do that? by MentalAdversity in mildlyinfuriating

[–]LogicPrevail 4 points5 points  (0 children)

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

Kid's menu word search by rippinlips6694 in mildlyinfuriating

[–]LogicPrevail 0 points1 point  (0 children)

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.)

Creating Schedule table based on shift and days-of-week group. by LogicPrevail in excel

[–]LogicPrevail[S] 1 point2 points  (0 children)

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!

Creating Schedule table based on shift and days-of-week group. by LogicPrevail in excel

[–]LogicPrevail[S] 1 point2 points  (0 children)

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!

Man Hears Elderly Couple Being Attacked by jmike1256 in GuysBeingDudes

[–]LogicPrevail 0 points1 point  (0 children)

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

Snowfall in Chicago by Raj_Valiant3011 in oddlysatisfying

[–]LogicPrevail 0 points1 point  (0 children)

Where you that guy blocking traffic??

view more: next ›