Glad to help!
If there is NA in the ranking variable, you will get NA in the rank order column. Is that how you want NAs to be handled?
library(tidyverse)
# with NA
mydata2 <- tribble(
~var1, ~var2,
1, 2,
3, 4,
NA, 3,
2, 5,
2, 6,
4, 5,
6, 7
)
# ties get lower number rank
mydata2 %>%
mutate(rank_order = min_rank(var1)) %>%
arrange(rank_order)
#> # A tibble: 7 x 3
#> var1 var2 rank_order
#> <dbl> <dbl> <int>
#> 1 1 2 1
#> 2 2 5 2
#> 3 2 6 2
#> 4 3 4 4
#> 5 4 5 5
#> 6 6 7 6
#> 7 NA 3 NA
Created on 2018-11-20 by the reprex package (v0.2.1)