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.
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.
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.
- Oh. my. gosh. You are an angel. I cannot begin to tell you what a sense of relief I am experiencing right now knowing that these issues are resolved but also I'm overwhelmed by the thoughtfulness of people in this forum. Thank you. Thank you. Thank you. This was my first time asking for assistance in a forum such as this. I can only hope and pray that I have an opportunity to pay it forward in an area in which I have competency. Obviously not in Excel! My best to you, mtarler. You are a godsend. Tania