Tag Archives: INDIRECT

Creating conditional dropdowns

Challenge: Create two dropdowns, the second one only showing values relevant to what has been selected in the first one. This question has come up a lot in my Excel career. A good example is where you have two-tiered data. … Continue reading

Frequency count on a range of data

Challenge: I have thousands of rows of data, each containing multiple columns of piece of information. I want a frequency count of each piece of information that appears. I received some data the other day. In total, there were 1,000 … Continue reading