Forum

I took the liberty to add some more helper columns (shaded orange) to make it easier to follow (mostly for myself). and I also changed the logic of de...

Working on it. I'll be back!

Please clarify why, for instance, the three transactions for Customer AA, Product P1 with amounts (I believe you mean quantities) of 10, 20 and 30 (to...

The formula in F seems to return Yes for the smallest value in each group of visible line numbers where certain other cells are not empty. The formula...

Thanks for the file. As Velouria suggested, why don't you remover the cells where you already entered the LEFT, MID and RIGHT formulas (although your ...

Glad I could held. Happy Holidays!!

Can't you move the cells that TEXTSPLIT want to spill into? Or put the formula somewhere else? If not, can you upload a file please? Then we don't hav...

That's a brand question. Would you mind uploading a file with an example data table, pivot table and the expected results?

I believe that would be: =COUNTIFS(Personnel Names Column,Individuals Name Cell, Dates Column, ">="&EDATE(TODAY(),-12)) You'll find a wor...

Thanks! I see what you are doing and understand that you don't want this custom column referencing each and every column. The solution would be to unp...

Okay, now it's fixed but it aint pretty. You need to add some checks to see if the event spans less then a and doesn't include a the Monday of the wee...

It's difficult to follow what the code does without seeing the underlying data. Could you share a workbook with some example data (non confidential bu...

OK, clearer now. The MEDIAN function was designed to see iff the date in row 2 on the EXTRACT sheet would fall between the Start and End dates. in the...

Glad I could help!!

Try this one: =SCAN(0,BYCOL(B1#,LAMBDA(x, SUM(x))),LAMBDA(a,v,a+v)) Broken down is two steps: BYCOL( B1#,LAMBDA( x, SUM(x) ) ) this w...