So my problem is that I cannot figure out how to use VLOOKUP to get data under today's month and year. So as seen in the pic, I have data under every month of multiple years and I need to look up the...

The following code is not matching on a partial right side match (ie. matching 483 to 483yy): $sdkNum -match '^(\d{3})' #first 3 digits of sdknum $sdkNum_tmp = $Matches[1] $deviceErrDescRow = $device...

I have a dataset like this: structure(list(year = c(2019, 2019, 2019, 2019, 2019, 2019), venue = c("Z", "Z", "Z", "Z", "O", "D"), HO = ...

I have several years of data with unique reference codes, what I'm looking to do is track how the reference codes appear in the data over time, does anyone have a method to do this? I'll give an examp...