- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel Help
Posted on 1/13/25 at 12:38 pm
Posted on 1/13/25 at 12:38 pm
The formulas ChatGPT spit out aren't working. Its suggesting =counta(unique(filter(a:a,b:b=e3))) but that just returns "1"
I have a data set like below:
I need to find the number of unique dates that have apple in column B. Answer would be 2. The dataset could be upwards of 50k rows. TIA
I have a data set like below:
I need to find the number of unique dates that have apple in column B. Answer would be 2. The dataset could be upwards of 50k rows. TIA
This post was edited on 1/13/25 at 12:39 pm
2
Posted on 1/13/25 at 12:50 pm to whiskey over ice
OK, I tried what you have and it worked for me.
ETA: Could it be you have a space in one of the descriptions or something marginally different between what is in E3 and what is in the columns you are looking at?
ETA: Could it be you have a space in one of the descriptions or something marginally different between what is in E3 and what is in the columns you are looking at?
This post was edited on 1/13/25 at 1:18 pm
Posted on 1/13/25 at 3:08 pm to mdomingue
quote:
I tried what you have and it worked for me.
Same
Different methodology, if you copy the table to a new sheet. Convert to an excel table. Click remove duplicates. Summarize with a pivot table, filtered on "apple".
Posted on 1/13/25 at 8:18 pm to whiskey over ice
Pivot table and count by date in the values section.
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News