Hey everyone,
I am trying to set up a conditional Minimum formula. On Sheet 1, I have 1000 IDs split into 20 different groups all on one rolling list. So Column A has all of the IDs, Coulmn B has the group name they are in, and Column C has the values of each. On another sheet (Sheet 2) I have the list of the 20 groups in Column A. I want to know if there is a formula that can give me the minimum for each group while also excluding 0's.
Any help would be great! Thanks!
I am trying to set up a conditional Minimum formula. On Sheet 1, I have 1000 IDs split into 20 different groups all on one rolling list. So Column A has all of the IDs, Coulmn B has the group name they are in, and Column C has the values of each. On another sheet (Sheet 2) I have the list of the 20 groups in Column A. I want to know if there is a formula that can give me the minimum for each group while also excluding 0's.
Any help would be great! Thanks!