Forum Discussion
Solved
Automate with excel and a database.
Hi Guys, I am currently on a project and I am kind of stuck. Basically I am trying to figure out how I can filter an excel table using a database in the background. Let's say I have a bank s...
- Yes,I have received the rar file you uploaded.
Date Transaction details
11 5月 2022 365 Online Elaine M
relative to
Friends
Elaine
so you are going to match the category for part of the Transaction details rath and
database than full equal。
https://answers.microsoft.com/en-us/msoffice/forum/all/excel-formula-to-compare-text-in-a-cell-to/d94aca5a-e987-4786-851f-4faaf3785f44
If you have got the list of database with the structure I mentioned in previous thread,you can also apply formula easily.
I would like try sql in this situation.
Yes,I have received the rar file you uploaded.
Date Transaction details
11 5月 2022 365 Online Elaine M
relative to
Friends
Elaine
so you are going to match the category for part of the Transaction details rath and
database than full equal。
https://answers.microsoft.com/en-us/msoffice/forum/all/excel-formula-to-compare-text-in-a-cell-to/d94aca5a-e987-4786-851f-4faaf3785f44
If you have got the list of database with the structure I mentioned in previous thread,you can also apply formula easily.
I would like try sql in this situation.
Date Transaction details
11 5月 2022 365 Online Elaine M
relative to
Friends
Elaine
so you are going to match the category for part of the Transaction details rath and
database than full equal。
https://answers.microsoft.com/en-us/msoffice/forum/all/excel-formula-to-compare-text-in-a-cell-to/d94aca5a-e987-4786-851f-4faaf3785f44
If you have got the list of database with the structure I mentioned in previous thread,you can also apply formula easily.
I would like try sql in this situation.
Thanks, i think this link is also very helpful. I do believe that your first response answer most of it as well so thanks a million for your time and effort.
D
D