Can anyone help me? I have this information with worker IDs and errors they have along with their managers name. The excel made uses =LARGE to find the top values of errors, but formula made to get the worker ID to match acts weird when there is more than one error exactly the same. So if there is 3 workers and all have 4 errors it will repeat 1 workers ID rather than displaying all 3 individually. Anyway to solve this issue?
Hi guy i want use formula summary 4 cell to be 1 cell like Title TOP F M L become the result OK CO X NA= X OK OK X CO= X OK OK OK CO=CO OK OK OK OK= OK OK OK OK NA= OK so how i can get auto with formula without typing
My xlookup only returns the first matching value. How did I fix this?
Misses one point
I want to vlookup argument "a" and i have two rows with "a", and i want to sum both corresponding results of the a's.
your explanation is good
Thank you. I was using index and match trying to sum duplicate column criterias
Hey
Can I do the same at Libre Office Calc?
Did it works in excel 2016?
Can I use it to sum from multiple sheets?? Trying to use it on attendance tracking.
Nice video! Is it possible to sum both Betty and Ben in one cell?
Can you lookup value in different sheet?
just curious why i dont that =XLOOKUP. Can you lookup value in different sheet?.
HeyCan I do the same at Libre Office Calc?
Can anyone help me? I have this information with worker IDs and errors they have along with their managers name. The excel made uses =LARGE to find the top values of errors, but formula made to get the worker ID to match acts weird when there is more than one error exactly the same. So if there is 3 workers and all have 4 errors it will repeat 1 workers ID rather than displaying all 3 individually. Anyway to solve this issue?
just curious why i dont that =XLOOKUP
Hi guy i want use formula summary 4 cell to be 1 cell like Title TOP F M L become the result
OK CO X NA= X
OK OK X CO= X
OK OK OK CO=CO
OK OK OK OK= OK
OK OK OK NA= OK
so how i can get auto with formula without typing
how to add all the same numbers in one column?
e.g in one column
12
11
12
21
32
12
23
12
65
12
how to sum up all 12?
Search for info on the SUMIFS function.