I am building a database to collect data on defects for work. I need a formula that would look for the most called defect for the week and instead of reporting the # of calls post the name of the part instead. I don't see why it wouldn't be possible but am new to Excel and just now figuring this stuff out. Thank you much for any advice in advance.
The file setup like this
Column A - Location, Column B - Part, Column C+ week ending date.
Each row just fills in the data for the above with the number of defects that week under the date.
I have the totals built into a separate sheet that will contain the formula in question so that all I need to do is enter the data and refer to the second sheet for any information I need.
Secondary question, I normally just hit the Column to select all and sort but it was switching up the totals when they were in the same sheet which was why I transfered them over to the second sheet. Is there a way to tell excel to sort only the actual data without actually selecting the data itself so that I can continue to use the Column to select all rather than select just the cells the data is in?
Bookmarks