Hello everyone.
I have to filter column E to get only cells with "Special permit" and sign the relative cells with x in column P. How do I do it ?
The headers are in row 11 but the first filtered value is in row 8592.
Thank you in advance
Hello everyone.
I have to filter column E to get only cells with "Special permit" and sign the relative cells with x in column P. How do I do it ?
The headers are in row 11 but the first filtered value is in row 8592.
Thank you in advance
Apply the filter. Select the data cells in column P and press Alt+; then type an X and press Ctrl+Enter.
Be as you wish to seem
Sorry but I forgot to tell that i need to write the code :S because it's in the middle of a structured code and I'd like to automatize all the process.
In case I won't find other solution I'll make and IF formula so I won't need to filter the table but I'd like to avoid it because the worksheet is about 20k of rows and putting and IF formula would take a lot of time to charge.