Unclear of syntax of aggregate function. I realize I should write a VBA script but time is crucial.
Two tables, I would like to compare the company name from each table.
Because the names differ slightly in each table, I would like to trim the last characters or use only the first 8 characters.
I need help on the aggregate function:
tables: table1, tables2
column titles: company (identical in both tables)
Do I write the formula in a new column in each table so that I can then compare the results? The column would be "trimmed" in both tables.
Do I follow these steps?
Insert column names from all tables in query?
In the trimmed column, I should have "expression" instead "group by," correct?
Enter this formula in the criteria?
=dfirst(["table1"]!["company"],"trimmed") Prob incorrect.
What do I put on the left hand side of the formula? ["table"]!["trimmed"]
What about quotation marks?
Help!
=DFirst([Jan 19]![IO Company],[jan 19])
Bookmarks