# Get all combinations

#### in2ition

##### New Member
Hello everyone,

I have the following table:

 A B C D E 26007201 01 039 116 2102 26007201 01 039 119 2101 26007202 01 039 116 2202 26007202 01 039 119 2201 26007202 02 039 116 2204 26007202 02 039 119 2203 26007203 01 039 116 2302 26007203 01 039 119 2301 26007203 02 039 116 2304 26007203 02 039 119 2303 26007204 01 039 116 2402 26007204 01 039 119 2401 26007204 02 039 116 2404 26007204 02 039 119 2403 26007205 01 039 116 2502 26007205 01 039 119 2501 26007205 02 039 116 2504 26007205 02 039 119 2503 26007206 01 039 116 2601 26007206 01 039 119 2601 26007206 02 039 116 2601 26007206 02 039 119 2601

<tbody>
</tbody>

Is there a way to automatically generate a * like in the below example ?

I will take only the first two combinations:
 A B C D E 26007201 01 039 116 2102 26007201 01 039 116 * 26007201 01 039 119 2101 26007201 01 039 119 * 26007201 01 039 * 2101 26007201 01 039 * 2102 26007201 01 * 116 2102 26007201 01 * 119 2101 26007201 01 * * * 26007201 * 039 116 2102 26007201 * 039 116 * 26007201 * 039 119 2101 26007201 * 039 119 * 26007201 * 039 * * 26007201 * * 116 * 26007201 * * 119 * 26007201 * * * 2101 26007201 * * * 2102 26007201 * * * *

<tbody>
</tbody>

Thank you.

### Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the \$ sign).

Replies
5
Views
126
Replies
3
Views
685
Replies
6
Views
491
Replies
2
Views
466
Replies
3
Views
489

1,203,236
Messages
6,054,297
Members
444,715
Latest member
GlitchHawk

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back