differentiate

Hello Team, I want to make all possible permutations of a name. I have a name like X Y Z and i have separate this name on the basis of space so now I have A1 - X B1 - Y C1 - Z In D1 I want to get all possible permutation of X Y Z for example X Y Z or Y X Z or Z X Y and so on.. or should be...

Hello, I have an issue with an IF AND function that contains similar criteria. Example: Agents have their days off and their week is formatted. IE: Tuesday/Wednesday off will look like this FYSM--R. Some agents have 3 days off, Tuesday/Wednesday/Thursday off will look like this FYSM--- I have...

I am sure I am making a very simple mistake but can't seem to find the solution. I am using this formula: =IFERROR(IF($F3="GTS",$M3,(IF(AND(H3="Manual",F3="GTS"),I3,""))),"") I need to differentiate between manual entry and formulated inputs. Column H has the option to select 'manual' for...

Hey guys, I'm having trouble with counting numbers that are similar, example 3.1 and 3.10. We have violation codes that I am trying to count, problem is that both 3.1 and 3.10 come up with the same exact value although both are different digits. codes can go from 3.1 up to 3.15. Is there away...