I am new to this so apologies in advance if i make any stupid questions.
I have a large database (around 300,000 columns) where each entry represents a person and i am trying to map the income distribution of my population (e.g., 5 people have an income of 0, 6 people have an income of 0.1, ..., 1 person has an income of 100,000) according to 2 specific criteria - if they have 0, 1, 2 or 3 kids and if they are younger (or older) than 25y old.
One of my criterion works as a changing input and whenever i change it so will the eligible cases for me to compute the distribution.
Since i need the distribution I need to count all cases for unique income values.
I already have two additional columns with if functions to flag eligible cases.
I tried recording a macro using a pivot table but it just wasn't working..