I am looking to simplify this workflow. In the first group I am currently getting all Text Note instances from Revit, sorting and grouping and getting a count of each by category name. In the second group I am getting the Text Note Types and certain parameters also in the second group I am using a countifs and a vlookup to populate an excel file to find duplicate parameters and copy the counts from the first part to the second.
Issues: the excel columns where the countifs and vlookup need to be adjusted depending on how many text note types there are (manually doing in excel)
What is the best way to do this? See screen image and attached dyn file. I can attache the excel if needed.
I am able to take the countifs and vlookup and use a string.replace node to change the cell number to a number based off of the counts, the only manual work I have to do is to click and drag the top row of cells down to get excel to extend the series.
@Kulkul Here is an updated file. I couldn’t figure out Bumble Bee for the countifs and vlookups but figured out a way to do with lists. I would like to change the color column to an actual color fill in excel but need help with bumble bee… @Konrad_K_Sobon
I’m sure there is a way to do this correctly, faster, etc but for now it gets me what I want.
@john_pierson this is what I needed the list creation based on count for…