“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

My question is: I need a formula to make excel matches each names in colume B bellow with names in Colume A , then if the two names are matched then copy the mark for each students in colume A infront of each matched student name cell in Colume B. For example : John's mark is 5 , I need from excel to find where is John in Colume B and input John Mark in E6 cell. Colume A Colume B names marks name Marks John 5 David E4 Steve 7 George E5 David 6 John E6 Thomas 1 Steve E7 George 9 Thomas E8

Solved by S. H. in 12 mins

find answer for Question 7 from the excel spreadsheet.

Solved by I. J. in 16 mins

I am having a problem with the filter in excel. When I search for a value in the search box, I am seeing two of the same entry in the search results. I should be only seeing one.

Solved by T. S. in 23 mins

I need help fining the formula for a question in excel

Solved by V. S. in 27 mins

On the summary page in column S I want it to match the ADM name in column P and then match it in the Data tab in Column U. Then on the Data tab I want it to search for Question No 1 (Column N) and then ad the values from Column R I was using countif but its too many arguments to search for all these values with one formula

Solved by I. A. in 21 mins