I have an excel sheet, it has multiple rows and columns. I have a date column ‘J’. In that I want to identify the yesterday’s date column value. I am unable to get the last column value range in J.
Here there are multiple DateTime values on the same day(07/10/2020 HH:MM:ss) with different timestamp.
Now I want to get the cell value range of the last column**(7/10/2020 19:19)** which is J6555 .
PLease suggest me how to get the cell range of that particular value. in the belowscreenshot ,i want to get the range value of J column which is J6555
Thanks in advance!