brianclay111
New Member
- Joined
- Sep 6, 2020
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
Hi! so here I took the first column and took out the letters at the beginning and the numbers at the end. On column F the multiples were taken out. Now I have 2 different values for each row in column G and H. AAU for example has 169.84 in G and -168.3321 in H. I would like to compare the list in F to list C. For example AAU comparing it to list C, there are 4 AAU's in list C. I would like to compare the first number of AAU which is 169.84 to all the numbers in the D column that matches with the AAU's. 2.5, 2.5, 5, 5. and It would match to the closest number which is 5 and it would write the 5 in column I. The same needs to be done for column H, which would be written in column J.
-Thank You!-