Hi.
I have a formula.Towards the end of this formula, where it says "= 11 by Col7" .... How do I write it so it grabs/equals to number 11 and also number 12?HTML Code:
Many thanks as always
Hi.
I have a formula.Towards the end of this formula, where it says "= 11 by Col7" .... How do I write it so it grabs/equals to number 11 and also number 12?HTML Code:
Many thanks as always
Last edited by sirdon; 03-13-2018 at 10:33 PM.
Hi,
Bit of a punt but perhaps
and (Col7 = 11 or Col7 = 12)
Don
Please remember to mark your thread 'Solved' when appropriate.
It is very close. It is grabbing the number 11 items, but from all different sports. I only want the one that grabs 11 that is equal to 'Football'
What was the revised formula that you tried?
HTML Code:
You didn't put in the brackets
WHERE Col21 CONTAINS 'Football' and (Col7 = 11 or Col7 = 12)
worked a charm...Many thanks.
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks