Hi,
I am in need of a VBA code where it search a column based on multiple conditions (Check condition 1, if fails go to next condition.... and so on) in other columns and returns a unique list. Below is the table which explains it better:
<tbody>
</tbody>
Now i need a list of Names who has worked on date 23/05 on task ABC in another sheet. Right now i am doing it with formula, but that is making the sheet too slow.
Thanks in advance
I am in need of a VBA code where it search a column based on multiple conditions (Check condition 1, if fails go to next condition.... and so on) in other columns and returns a unique list. Below is the table which explains it better:
Name | Emp ID | Date | Task ID | Production count | Task ID | Production Count | Task ID | Production Count |
Amit | A1620 | 23/05 | ABC | 1200 | DEF | 1400 | GHI | 1100 |
Peter | A1440 | 23/05 | DEF | 1450 | ABC | 1150 | GHI | 500 |
William | A1290 | 24/05 | GHI | 1500 | DEF | 1450 | JKL | 200 |
<tbody>
</tbody>
Now i need a list of Names who has worked on date 23/05 on task ABC in another sheet. Right now i am doing it with formula, but that is making the sheet too slow.
Thanks in advance