Brian_Masters - profile

Brian_Masters · Mar 22, 2019

Trying to write a formula that will recognise a word value in one field then if one or more word values are meet in the second field then it returns a value in a third field. This needs to be able to meet several values in both the first and second f...

Brian_Masters · Mar 25, 2019

Thank you Jonathan, I used a formula for what I needed and it is working for me at the moment. My fields are in the middle of the table so a little more difficult to work with. Appreciate your time and suggestion will keep this in mine for few other ...

Brian_Masters · Mar 25, 2019

Thank you for the information on the formula, it works well with what I was trying to accomplish. Regards, Brian Masters Managing director Muddle’s Place P: 03 6705 7070 M: 0447359 335 E: brian@muddlesplace.com

Brian_Masters · Mar 24, 2019

There are 5 option in both 1 and 2 fields giving 25 possible outcomes, however some of the outcomes are the same for each combination option of field 1 and 2. I will give it a go and see if it works. I have tried to us a nested IF statement however i...

Brian_Masters · Mar 23, 2019

Yes please would love to be able to get this sorted if it is possible

User Statistics

User Activity

Multiple values or several fields

Re: Multiple values or several fields

Re: Multiple values or several fields

Re: Multiple values or several fields

Re: Multiple values or several fields