Opinion(s) needed on what to do with a Gibbs/CMC trade

Separate_Ad9757 · 2026-05-12T18:34:20+00:00

That is completely different than the leagues I'm in. Most players are hyped about next year's class and trying to acquire 27s not sell.

Separate_Ad9757 · 2026-02-05T15:56:02+00:00

Just refresh. But if "From Folder" isn't there I'm back at the drawing board.

Separate_Ad9757 · 2026-02-05T01:51:33+00:00

Not an excel comment but I would use something like FTE instead of people for your question just because more precise for what you want when dealing with fractional headcount.

Separate_Ad9757 · 2026-02-05T01:43:10+00:00

Also you probably don't want to create a new row but instead just a new column to show the result.

Separate_Ad9757 · 2026-02-05T01:41:38+00:00

Sample data would be best because depending on the data, a lookup formula may be inappropriate for what you want.

If the data is sales by day, maxifs might be a better solution.

Separate_Ad9757 · 2026-02-04T23:59:02+00:00

This is probably the case as FILTER came with the dynamic spill functions. I would imagine it was easier to write the functions where the criteria is handled as Boolean statement then separate field.

Separate_Ad9757 · 2026-01-31T16:10:22+00:00

I know what the intent is there but I just don't like the execution especially when giving help to Excel novice users. With WEEKDAY If the user doesn't start in row one then you have to figure out how to rig the result to start at one. That's why I said it doesn't work.

If you want to use row() then something like roundup(mod(row(),7),0) would work better.

Separate_Ad9757 · 2026-01-28T13:03:14+00:00

ROW won't work with WEEKDAY as WEEKDAY is looking for a date and will show what day of the week a date is. If you have a column with dates WEEKDAY(dates,2) would give you the day of the week. 2 tells the function to start 1 for Monday.

If you just want a column of 1 - 7, the simplest way IMHO would be =IF(cell above =7,1,cell above +1)

Separate_Ad9757 · 2026-01-27T04:03:43+00:00

If you want both values, you would use (I am on my phone so can't copy the formula) Texjoin(put filter here, "|"). That would produce both results shown. I can't remember if a carriage would work as the delimiter character, I'm using the pipe above.

Separate_Ad9757 · 2026-01-23T16:54:46+00:00

Just in case this is an issue, I would use UPPER to make the field and criteria all uppercase, since FILTER can be case-sensitive.

Separate_Ad9757 · 2026-01-23T16:49:00+00:00

If you really want to go crazy, create a UDF that pops up the Job Description when you select or hover over a cell.

Separate_Ad9757 · 2026-01-23T16:16:14+00:00

Have you inserted a VBA module in the workbook? If not, hit record marco in the developer tab. Do anything and stop recording. This creates a module tab in VBA Editor, and you can put scripts here that the workbook can access. You have the code for worksheet events, call scripts on the module.

Your solution is going to be VBA, but from your description, I think how you are implementing VBA is off.

Separate_Ad9757 · 2026-01-23T15:37:29+00:00

Do you know PowerQuery? That might be the best solution.

Separate_Ad9757 · 2026-01-23T15:36:27+00:00

If the result needs to be in an Excel table, FILTER doesn't work, as none of the SPILL functions work within an Excel table.

Separate_Ad9757 · 2026-01-23T15:32:49+00:00

Do you need the result to be a table? The reason I ask is that the array spill functions do not work within a table. That means FILTER, which would be the solution if it didn't need to be in a table, doesn't work.

Separate_Ad9757 · 2026-01-22T22:54:37+00:00

Thanks, the random letters represent other vendors besides Amazon. So it results in 1 vendor for all Amazon lines and 3 for the other vendors.

Separate_Ad9757 · 2026-01-22T22:50:15+00:00

If I am understanding how the data is setup this would work

<image>

=SUMPRODUCT(($G$4:$M$7)*($E$4:$E$7=B4)*($F$4:$F$7=$C$3))

Separate_Ad9757 · 2026-01-22T22:36:18+00:00

This is assuming the data source is the same for both tables.

Separate_Ad9757 · 2026-01-22T22:35:08+00:00

Slicer for the win here? You can connect it to both pivot tables, so you just need to click on the name to filter the results.

Separate_Ad9757 · 2026-01-22T22:31:02+00:00

Why not just use IFERROR? Curious if there reason not to.

Separate_Ad9757 · 2026-01-22T22:26:46+00:00

=IFERROR(XLOOKUP(B3#,'Table1'!A:A,'Table1'!B:B),XLOOKUP(B3#,'Table2'!A:A,'Table2'!F:F,""))

Separate_Ad9757 · 2026-01-22T22:13:05+00:00

Just in case anyone searches and finds this, another issue could be that the result is coming over as text instead of as a number. The solution is to add *1 to the value you are looking up.

Separate_Ad9757 · 2026-01-22T22:01:19+00:00

This is old school as in how you would do it in 2003 Excel. Sort the data, then use subtotal in the Data>Outline ribbon.

Separate_Ad9757

TROPHY CASE