jerry

I have a table of courses with the name of the student. Then I have another table that I am trying to get a Yes or No value based on if they took the class. I believe I need a vlookup function, but I am missing how to get that data. Student Course Tom Smith Math 101 Jerry...

I have the following data which i need to process: - A B C Tom 39.57 Tom 117.73 Red Tom 195.89 Red Tom 195.89 Amber Tom 352.21 Red Jerry 508.53 Jerry 586.69 Red Jerry 264.85 Green Jerry 343.01 Red When the values in A1 and A2 are the same I want...

Hi there! I would like to post a "thank you" but can't figure out how to do it. Many thanks, Jerry

Is it possible at all to cut the first top 5 lines in a Word Document and have them send over to an Excel table? Word Data: ALL100 ALL RECREATION 1111 LAYES DRIVE BURNSVILLE...

Hi There, Hope this is in the right place. Im trying to make an audit of data quick and easy to do in excel. I have a list of reference numbers in a column, the reference number could be in the column twice or three times. Depending on whether its in twice or three times I then want to check the...

I would really appreciate some help!! I am trying to figure out how I can accomplish the following logic: I have files that are assigned to one person, and can switch assignments. I need to locate these switches for specific people. My sheet will look something like what is shown below. The...