Hi,
Have just started a new role and am looking for some help with what you wizards will probably consider very basic level stuff..
I basically need to be able to correlate data from two columns that are set up like this:
<tbody>
</tbody>
And for example, I need to find all Work order reference numbers which include both schedule rate items rec12 and rec15.
Also, will be dealing with huge volumes of data so unsure if a pivot table will be more efficient or if I should be using a function.
Thanks in advance, forgive my ignorance!
Have just started a new role and am looking for some help with what you wizards will probably consider very basic level stuff..
I basically need to be able to correlate data from two columns that are set up like this:
Work Order Reference | Schedule Rate Item |
1001 | car11 |
1001 | rec12 |
1001 | rec15 |
2001 | star11 |
2001 | rec12 |
3001 | car11 |
3001 | rec12 |
3001 | rec15 |
3001 | rec20 |
<tbody>
</tbody>
And for example, I need to find all Work order reference numbers which include both schedule rate items rec12 and rec15.
Also, will be dealing with huge volumes of data so unsure if a pivot table will be more efficient or if I should be using a function.
Thanks in advance, forgive my ignorance!