PDA

View Full Version : Work on table while filtering



christchaaya
04-09-2013, 06:53 AM
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 :D

Aflatoon
04-09-2013, 07:28 AM
Apply the filter. Select the data cells in column P and press Alt+; then type an X and press Ctrl+Enter.

christchaaya
04-09-2013, 07:45 AM
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. :D