Hi guys,
I have an export of raw data that I am looking to count the values of. However depending on the account and certain attributes that it has, the column I am referring to for the count function can change (i.e: one account will have the refernce column in DA, but another will have it in DK)
I have a reference table that I am trying to have as the standard layout for the headers, and I plan to use this formula:
=IFERROR((INDEX('Account Export'!1:1048576,(Output!$A2+2),MATCH(Output!B$1,'Account Export'!$1:$1,0))),"")
I have placed a hidden column as a reference with numbers (ascending with respect to the row number) and used this as the $A*+2 value so I can pull the equation down across all the needed rows.
Ideally, this would then fill the column with the data, and ideally, I would copy and paste as values to reduce the file size and load on the computer. Another tab would then count these (countifs mainly) and tally the totals up. My end goal is to just take a raw file export, copy and paste and the data fields will automatically populate in the reference table I created.
However pulling that equation down across 500k rows is not ideal and I face a crash everytime.
Is there a way to bypass the table creation and use a function that can find the header title and begin the count function accordingly? Hope someone can help. Thanks in advance!
Bookmarks