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.
Just uploaded it.
Pelase let me know if you can access it..
Link http://e.anyoupin.cn/Edata/?p=tools.ceshi.index/downloadTreeFile&file=/excel/Workings%20dl.rar
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.
This is a vedio about SAAS sql。
http://e.anyoupin.cn/EData/?s=Automate
This is the SAAS input site.
The attached is a demo raw data structure for upload.
If possible，submit your 2 sheets to fetch the output report.
Thanks for your swift response.
by "scale" i meant the amount of conditions. I added two more condition for "Bob" and "Other" and i got the msg i shared in the previous email.
Now about Cbm. Do you mind talking me trough it? I am a bit confused about what the workings below were trying to achieve.
Regards,
- increase the scale of it
I can not get what you mean increase the scale.
In fact I use sql to accomplish this kind of task like below.
http://e.anyoupin.cn/EData/?s=894 - 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