•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Filter but with Array Condition?
Our take
In today’s data-driven landscape, creating dynamic tables that adapt to changing datasets is essential for effective analysis. You’re looking to count unique calendar days linked to each ID, utilizing two arrays: one for your Date table and another for your ID table. While your formula is on the right track, the challenge lies in applying it dynamically across each row of your ID array. Let’s explore innovative solutions that will empower your data management and streamline your workflow, ensuring accurate counts for each unique ID.
Hello,
I have two sets of data that changes from week to week, with IDs & Dates. I'm trying to create a dynamic table that counts how many unique calendar days are associated with each ID.
Date table has Ids & Dates (ID in col 1, Date in col 2) - it's an array starting in A4
ID table has IDs for the week to be needed (Just an array of IDs that's on T4)
I came up with Count(unique(filter(choosecols(A4#,2),choosecols(A4#,1)=T4#))), but that doesn't work because T4# can't be an array. It works with T4, but how can I dynamically put it on every row?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#financial modeling with spreadsheets#Excel alternatives for data analysis#generative AI for data analysis#rows.com#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#Excel compatibility#row zero#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#unique calendar days#dynamic table#IDs for the week