khandelwal
New Member
- Joined
- Dec 19, 2018
- Messages
- 4
Hi,
I want to count a specific text in a column and also want to do this for multiple columns (6 columns in a single table). Need help. I am only able to do it one column at a time.
Sample Table:
<tbody>
</tbody>
I was not able to format it here.
Now I want to count e.g. "*OPQ*" in the table from column 1, parallelly I want to count "*UVW*" from column 4 grouped by either month or Week ending.
I hope I have explained my requirement.
I want to count a specific text in a column and also want to do this for multiple columns (6 columns in a single table). Need help. I am only able to do it one column at a time.
Sample Table:
Month Text | Week Ending | Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 |
Dec'18 | 19-Dec | ABC, DEF, GHIJK, LMN | OPQ, RST, UVW | ABC, DEF, GHIJK, LMN | OPQ, RST, UVW | ABC, DEF, GHIJK, LMN | OPQ, RST, UVW |
Nov'18 | 02-Nov | ABC, DEF, GHIJK, LMN | OPQ, RST, UVW | ABC, DEF, GHIJK, LMN | OPQ, RST, UVW | ABC, DEF, GHIJK, LMN | OPQ, RST, UVW |
Oct'18 | 06-Oct | ABC, GHIJK, LMN | OPQ, RST, UVW | ABC, GHIJK, LMN | OPQ, RST, UVW | ABC, GHIJK, LMN | OPQ, RST, UVW |
Dec'18 | 19-Dec | ABC, DEF, GHIJK, LMN | OPQ, RST | ABC, DEF, GHIJK, LMN | OPQ, RST | ABC, DEF, GHIJK, LMN | OPQ, RST |
Nov'18 | 02-Nov | ABC, DEF, GHIJK | UVW | ABC, DEF, GHIJK | UVW | ABC, DEF, GHIJK | UVW |
Oct'18 | 06-Oct | ABC, DEF, LMN | OPQ | ABC, DEF, LMN | OPQ | ABC, DEF, LMN | OPQ |
Dec'18 | 19-Dec | GHIJK | OPQ, UVW | GHIJK | OPQ, UVW | GHIJK | OPQ, UVW |
Nov'18 | 02-Nov | DEF, GHIJK, LMN | RST, UVW | DEF, GHIJK, LMN | RST, UVW | DEF, GHIJK, LMN | RST, UVW |
Oct'18 | 06-Oct | LMN | UVW | LMN | UVW | LMN | UVW |
<tbody>
</tbody>
I was not able to format it here.
Now I want to count e.g. "*OPQ*" in the table from column 1, parallelly I want to count "*UVW*" from column 4 grouped by either month or Week ending.
I hope I have explained my requirement.