Forum Discussion
Solved
Help! I know so little about excel that I can't even explain what I need!
Hello: As chair of a 5 member Search Committee, I'm trying to streamline the search process and also trying to ensure, at least as much as possible, that every candidate is provided with the same op...
- if the linked sheet I did 2 things:
a) the TOTAL formula for each candidate I changed to:
=SUM(K7:AJ7,AR7:BC7)
because columns AK - AQ are all summed up in AR so i skip them so you don't 'double add' them
b) I reformatted the sheets so COLUMN A is the list count (1,2,3,4,...) and column 2 is the date to make the sorting/formula easier assuming you want the count 1,2,3,4 to still be that way on the master. If on the other hand you want the list 1,2,3,... from the CANDIDATE sheet to stay with the candidate so the MASTER sheet is NOT in order but rather refers to the corresponding number on the other sheet, we can shift the SORT formula to column A
c) I added a basic SORT formula onto the MASTER and reference the entire table from the CANDIDATE sheet and sort by the last (TOTAL) column highest to lowest.
d) I added an IF() statement just to blank out the 0 values to make it look cleaner.
mtarler's recommendations may be sufficient for you, but I am not certain of the structure of your data in the workbook. See all sheets in the attached workbook for considerations and steps.
- Hi SnowMan55. I'm so grateful for your help. Since I know so little about the proper terms to use, I've included a OneDrive link to a dummy workbook with two spreadsheets, one is a master where I'd like to move the candidate's row from the individual spreadsheet to the master so that we can have all the candidate's values and total score on the same spreadsheet to enable us to rank them.
https://bama365-my.sharepoint.com/:x:/g/personal/talamedalawson_ua_edu/EcuSakaN_9RErWGYOsOBQKkB1iY9AAWR2fgyfv3_GPt60Q?e=ZisQLx
Again, thank you so much for your willingness to help a total stranger! There's a lot going wrong in the world today but, undeniably, there's also a lot of good. Hope you're having a good Sunday.- I neglected to clarify that the individual spreadsheets are for the independent reviews. After we discuss our independent reviews then I'd like to move the rows to the master spreadsheet.
- if the linked sheet I did 2 things:
a) the TOTAL formula for each candidate I changed to:
=SUM(K7:AJ7,AR7:BC7)
because columns AK - AQ are all summed up in AR so i skip them so you don't 'double add' them
b) I reformatted the sheets so COLUMN A is the list count (1,2,3,4,...) and column 2 is the date to make the sorting/formula easier assuming you want the count 1,2,3,4 to still be that way on the master. If on the other hand you want the list 1,2,3,... from the CANDIDATE sheet to stay with the candidate so the MASTER sheet is NOT in order but rather refers to the corresponding number on the other sheet, we can shift the SORT formula to column A
c) I added a basic SORT formula onto the MASTER and reference the entire table from the CANDIDATE sheet and sort by the last (TOTAL) column highest to lowest.
d) I added an IF() statement just to blank out the 0 values to make it look cleaner.
