function help

Hi guys, Needing some help with creating the functions for this google sheets below. https://docs.google.com/spreadsheets/d/1FNtXK7l_qcNwKQBVAyHHGwbPNDvrfc-qQrNbfwCf5vA/edit?usp=sharing Basically, I would like to be able to select from the drop down the place that the student got for each...

Hi, I am having trouble deciding what formula to use in Excel for task I have below. In the original spread sheets there are approximately 580 individuals records that need to be worked on. Therefore, I do not want to do this manually. I need to get data from spread sheet A to populate into...

Hello. Thank you in advance for any help/guidance you all can provide. My issue is as follows: I have standardized report I use on a daily basis, this report contains social security numbers(SSN) without the leading zeros. I need to add the leading zeros to be able to use the correct SSN for...

I'm helping someone on a series of spreadsheets she does every month/quarter for dozens of different groups. Each group is slightly different, so it's not as easy to standardize. I'm trying to help her consolidate her efforts where possible, so I'm hoping to avoid manual manipulation x's 75...

I have a list that was previously fully filled in, but I had to go through and insert many rows. Now with those inserted rows I want to insert the same text that is in the cell above. BQ5 - Anderson BQ6 - Anderson BQ7 - Anderson BQ8 - BQ9 - Anderson BQ10 - Anderson BQ11 - BQ12 - Rochester...