Forum

OK but can you share a file? I find it hard to visualize what exactly you are doing.

Cahnge the formula to: =FILTER($C$2:$C$181,($A$2:$A$181=B184)*BYROW(SEARCH({"Assistant","Supervisor","Floor"},$B$2:$B$181),LAMBDA(a,COUNT(a)))) an...

You asked the same (or at least a very similar) question before and you mentioned that you had resolved the problem "in another way". What has changed...

GETPIVOTDATA works with items you placed in the Values area. Perhaps the attached file helps you on your way.

Perhaps the attached file helps you on your way. If not, please come back here.

That's a monster of a formula! As far as I can see, the fourth nested IF has no 'if_false' defined. For row 13 the value returned is FALSE (i.e. 0). A...

I used your question to learn something new myself, so thank you! You would really need to use Power Pivot and the Data Model for this. Inspired by...

The article you refer to is from 2013 and works only when you want to search and return one word. In your example in A2 you have both the 5th and 6th ...

I doubt that PQ is the correct tool for what you are describing. The report is formatted as a 'finished product' with sub-totals (formulas I presume),...

Provided your Excel version supports the rather new VSTACK and TAKE functions, you could have a look at the example in the attached file and see if it...

Please see attached. Is that what you need?

Criteria entered in AVERAGEIFS work like an AND function. Only items for which all criteria are met will be included in the average calculation. Ob...

Alternatively, in B6 enter: =FILTER(VSTACK(F5,F6#),VSTACK(F5,F6#))

I believe you are over-complicating the matter. The formula in I4 can be as simple as: =IF((G4-H4)*24>=36,"Yes","No") No need to use MOD in t...

Perhaps like in the attached. I removed the automatic grouping and then manually grouped the Completion Time in Years, Qtr, Mth. That kept the individ...