Need auto generate using excel formula (index, match......)

[Miguelhan]

Table 1
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sunday[/TD]
[TD][/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]e[/TD]
[TD]f[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD]a[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD][/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]f[/TD]
[/TR]
[TR]
[TD]Thursday[/TD]
[TD][/TD]
[TD]b[/TD]
[TD]d[/TD]
[TD]f[/TD]
[/TR]
</tbody>[/TABLE]

Table 2
[TABLE="width: 500"]
<tbody>[TR]
[TD]a[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]f[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Table 3
[TABLE="width: 500"]
<tbody>[TR]
[TD]a[/TD]
[TD]Monday[/TD]
[TD]Tuesday[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]Monday[/TD]
[TD]Wednesday[/TD]
[TD]Thursday[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]Sunday[/TD]
[TD]Tuesday[/TD]
[TD]Wednesday[/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]Sunday[/TD]
[TD]Tuesday[/TD]
[TD]Thursday[/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD]Sunday[/TD]
[TD]Monday[/TD]
[TD]Tuesday[/TD]
[/TR]
[TR]
[TD]f[/TD]
[TD]Monday[/TD]
[TD]Wednesday[/TD]
[TD]Thursday[/TD]
[/TR]
</tbody>[/TABLE]


Hello Everybody,

I need your help, please.

I have a list of groups (a,b,c,d,e,f) combined and distributed on different days. (TABLE 1)

In Table 2, I need to generate automatically what days these groups fall.

Results should be the same in TABLE 3.

Thank you for your help.

Miguel Han

 

[Miguelhan]

anybody please?