In the Excel report, there are problems that they use such numbers to book. 12345678 ⑨⑩ (4) ⑵ ⑷⑸⑹⑺⑻⑼⑽⑾⑿⒀⒁⒂⒃⒄⒅⒆⒇ 贰 贰 柒捌 柒捌 一 一 二 三 三 三
How do I find out the data greater than XXX?
Copy the data to another table, then automatically convert the data through your macro, then you can complete the lookup
Cells.replace what: = "1", replacement: = "1", lookat: = xlbyrows, matchs: = false, searchformat: = false, replaceformat: = false cells.replace What: = "(1) ", Replacement: =" 1 ", lookat: = xlpart, searchorder _: = xlbyrows, matchcase: = false, searchformat: = false, replaceformat: = false cells.replace what: =" ", replacement: =" 1 " , Lookat: = xlpart, searchorder _: = xlbyrows, matchs: = false, searchformat: = false, replaceformat: = false cells.replace what: = "1", replacement: = "1", lookat: = xlpart, searchier _ : = xlbyrows, matchcase: = false, searchformat: = false, replaceformat: = false
Push
Then use any desired query method
