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.
if the values in col M and N are non-numbers then =SUM(K7:BC7) should ignore them just fine. as for #2, on the master you just want to type = and then go to the corresponding sheet and highlight the range of data you want "copied" there and you should get something like: =Candidate1!K7:BD7 You can make is a little easier if you list the TAB names on the master (let's say in A1:A5) then next to it (i.e. in B1) you can type =INDIRECT(A1&"!K7:BC7") and then you can fill/copy down.