If a combination extract a group of numbers

You will need to explain the logic of the expected results you have listed - where do those numbers come from?

Will you please attach a sample Excel workbook? Nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

2. Make sure that your desired results are also shown (mock up the results manually).

And when you have done this, please explain those results - where do the numbers come from? I can see no logic in your first post at all.

This tells us nothing helpful at all:

Excel 2016 (Windows) 32 bit

	A	B	C
1	1	2	=
2	2	1
3	1	2
4	1	1
5	2	2

Sheet: Sheet1

if the next combination is 1 at cell A and 2 at cell B show on C1 the numbers:2,1,3,6,5

Why?

if the next combination is 2 at cell A and 1 at cell B show on C1 thenumbers:1,3,7,10,11

Why?

if the next combination is 1 at cell A and 1 at cell B show on C1 the numbers:36,3,6,5

Why?

if the next combination is 2 at cell A and 2 at cell B show on C1 the numbers:17,9,6,

Why?

I need an updated sample workbook and answers to my questions, please.

Well, I do NOT understand the logic, but as you are not going to explain any further it seems, try this:

=IF(AND(A1=1,B1=2),"2,1,3,6,5",IF(AND(A2=1,B1=1),"1,3,7,10,11",IF(AND(A1=1,B1=1),"36,3,6,5","17,9,6")))

Dear ali, the results on a and b cell will be put manually and the same time at a and b. Just a formula at cell c which shows the specific numbers after those 4 combinations. Thanks!

See post #7.

Try changing this:

=IF(AND(A1=1,B1=2),"2,1,3,6,5",IF(AND(A2=1,B1=1),"1,3,7,10,11",IF(AND(A1=1,B1=1),"36,3,6,5","17,9,6")))

to this:

=IF(AND(A1=1;B1=2);"2,1,3,6,5";IF(AND(A2=1;B1=1);"1,3,7,10,11";IF(AND(A1=1;B1=1);"36,3,6,5";"17,9,6")))

Your locale requires ; as a separator rather than , .

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Originally Posted by louis128

Thank you! BUT I STILL GET THE ERROR MESSAGE

Don't SHOUT at me!!! I am not an idiot.

Open the attachment to post #11.

Do mainland European array constants need a \ ??

=IF(AND(A1=1;B1=2);"2\1\3\6\5";IF(AND(A2=1;B1=1);"1\3\7\10\11";IF(AND(A1=1;B1=1);"36\3\6\5";"17\9\6")))

Good.

Please mark the thread as solved.

Originally Posted by Glenn Kennedy

Do mainland European array constants need a \ ??

=IF(AND(A1=1;B1=2);"2\1\3\6\5";IF(AND(A2=1;B1=1);"1\3\7\10\11";IF(AND(A1=1;B1=1);"36\3\6\5";"17\9\6")))

Text within speech marks ought to be immune from regional variations.

STOP SHOUTING!!!!!

Your latest request does not match the workbook you first attached, and seems different, so please attach a new workbook with your expected results entered manually.

PS Have you tried to adapt the solution I gave you for the new scenario? If not, then you really should try to do so, otherwise, you will learn nothing from this process and remain dependent on your helpers - we want to help you to become independent.