expertise

I would like my spreadsheet to have two sheets. One will have people with their areas of interest and expertise. The second sheet will have requests from customers for people with specific areas of interest and expertise. Can I make the second sheet search the first one and come up with people...

Dear Mrexcelians. When I look back at where I was before I discovered Mrexcel, IT WAS TOTAL DARKNESS .....LITERALLY!! Am ready to market this site FOR ITS SUPER-EXCEL EXPERTISE, ITS AWESOME READING OTHER USERS' QUIZZES & ASNWERS. God Bless Mrexce Regards Patrick Nyaga

=SUMIFS('Transaction Raw Data'!$J$3:$J$5009,'Transaction Raw Data'!$G$3:$G$5009,"XYZ",'Transaction Raw Data'!$G$3:$G$5009,"ABC",'Transaction Raw Data'!$H$3:$H$5009,"Operating Expense") I want to sum column J if it meets the 3 criteria - 2 criteria from column G and one criteria from column H...

Hallo :smile: I have a question about clustering in excel and I don't even know if it is even possible doing it (in excel). I will give a simple example: There are 4 teachers and 4 assignments. Everyone indicated if he/she has the right expertise to evaluate a certain assignment with (YES)...

Hi all, I have a large document containing a list of researchers, their expertise and the companies they work with. Each researcher has a different number of expertise and companies they work with. I am trying to group all the rows from one academic together and link them to that specific...