Forum Discussion
Abi Black
Jun 05, 2018Copper Contributor
Excel Help
I have a row with 4 cells with text value ("L" or "H"). I want a formula that can compare the combination of letters in one row of 4 cells to a table on the 2nd tab. The table has different combinati...
Abi Black
Jun 05, 2018Copper Contributor
Thanks - just thinking the sequence of the letters will be random so I need the formula to work with any sequence. Can you help?
Wyn Hopkins
Jun 05, 2018MVP
Hi Abi
I don't really understand what you mean sorry. Can you give me an example / more explanation
I don't really understand what you mean sorry. Can you give me an example / more explanation
- Wyn HopkinsJun 06, 2018MVP
Here's another version (See attached Excel file) of the same formula but without the "Tables"