juliemaenhout
New Member
- Joined
- Oct 7, 2014
- Messages
- 5
Hi!
I have no experience whatsoever with macros and I only need them for preprocessing data for my master thesis. It would be great if any of you could give me a hand.
I have a data set of 150 000 rows in an Excel sheet. I'd like to remove all the rows where
1. the first character is non-numeric
2. the last character isn't the letter "N"
Could you help me out please?
Thanks in advance,
Julie
I have no experience whatsoever with macros and I only need them for preprocessing data for my master thesis. It would be great if any of you could give me a hand.
I have a data set of 150 000 rows in an Excel sheet. I'd like to remove all the rows where
1. the first character is non-numeric
2. the last character isn't the letter "N"
Could you help me out please?
Thanks in advance,
Julie