This is probably really basic but any help would be greatly appreciated. I am trying to remove multiple rows from a dataset because of one missing piece of information. The attached picture includes the data set. I have percentile ranked each row however I now need to delete the rows that have no percentile rank and there are roughly 26,000 rows so a quick way to filter and delete would be very beneficial I have both Minitab and R so preferably a fix in there would be great as excel keeps crashing when I try it in there!
Thank you in advance :)
The comments to your question should work in R. However, for those who have a similar problem and only have Minitab (and for whatever reason don't wish to / can't simply download R), the following method should work for Minitab 19 (there may be differences in different versions of the software):
Navigate to Data > Subset Worksheet...
Select "Use rows that match a condition" and "Exclude rows that match the condition" from the first two boxes
Select the column that contains missing values (C18 in this particular case) in the Column box
Select "Equals" in the Condition box and * in the Value box
This should create a new worksheet, excluding the rows with missing values in that column.