Forum Discussion
Automate with excel and a database.
- 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.
re: tried to upload the actual Xlsx file but the system does not allow it.
zip the excel .xlsx file then ,then Open full text editor and Browse files to attach.
or upload your zipped file to http://e.anyoupin.cn/EData/?p=tools.ceshi.index/uploadFileForm
According the screenshot,you can create a help list to tag your original cost items.
help list/database structure like below
type item
other health
other barna
car east cost
rather than the second picture you uploaded
Then you can reclassify the original cost list item and output pivottable or sql to two dimension table at last.
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.peiyezhu Actually i am now starting to increase the scale of it and it says that the level of nesting is more than I could
Any idea how to tackle this?
- 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