First off, I'm a sort of a beginner at excel. I'm trying to extract data from a spread sheet of farmers and the fiscal quarter during which we purchased moringa seeds from them. However there are duplicates of the farmers due to multiple purchases from the same farmer. I'm trying to determine the number of unique farmers we worked with by fiscal quarter, without duplicates. My first approach was a countifs formula and then make the criteria the specific fiscal quarter and aunique formula, but that doesn't work because the second part of the countifs doesn't have two criteria or at least I can't figure out the second criterion. Does anyone have any suggestions?
Bookmarks