Jan 27th 2021 #1 pls help me to write a code to find 1st, 2nd &3rd largest value in coloumn B of sheet2 and insert it as S1,S2 And S3 in column G. The value in column b is formula derived and changes after every 5 mins.
Jan 27th 2021 #4 You need to use the LARGE Function. This explains howHow to find top or bottom N values in Excel
