new column? for instance:
A1---------->B1
mary.........y
bob...........b
stan .........n
lee............e
.............................
i actually have a number after each name. i would like to automatically get those numbers into the next column while keeping the order the same...
B2=531
C2=331
what do i put in D2 to get the answer .623 <---where the 3rd decimal (3) is rounded up or down
i understand how to make a quotient in D2, and how to round to said decimal place in D2 from an integral but i don't know how to combine the two all in the same cell
i tried but it only...