Last seen: Jun 16, 2025
Poping topic up since there is no reply, which I find odd. Regards, Ayal Telem.
Dear Anders, It will not work since not only the header wording is different, but the content of the columns. you can have new columns compare t...
Dear Anders, The data is coming from Google forms. I can't use PQ, or paste everything in the same sheet since columns keep changing on a weekly...
Riny Hi, I'll try to simplify: The "From Folder" connector will not reognize the headers of the table in the file. The row below the (unreco...
Stupid me!! Since the files are in Hebrew, I made an extensive file with screen shots explaining my problem/s, but forgot to upload it!!. So, my...
Hi Alan, Thank you for your replying. First, I cannot find "File->Import" only "File->Export". Looked both on the web the the PC version. ...
Dear Riny, When I look at items in column B, all are Custom "dd/mm", as you can see in the attached files. I also checked on the 365-web to make...
Hi, Soooo, after a long time I found the time to continue the subject. In the attached file you can see in sheet "Apr" that although lines 17&am...
Dear Riny, Thanks for the reply. I can't understand what you did differently from me, because I also formatted all columns as I wanted, but it f...
Dear Velouria, I did a clear fill before, but I guess I never did it for the whole table. Once I cleared the fill from all the table it worked OK. ...
Dear Riny, It works wonderfully - thanks a million. Now, I need to understand why your works and mine doesn't. Regards, Ayal Telem.
Hi, Mynda, The file I attached is a sample of the original, as the file is in Hebrew. I tried to change the column type in PQ, but it doesn't fi...
I changed it to Numers both through the Ctrl+1, and PQ, but the problem persists. Anyway, i think we'll leave it as one of life's mysteries.
In PQ the column is set as Number, so I don't know where the problem is.
Thank you very much Velouria & Riny. I knew it has to do with different formating between the cells, but couldn't, and still doesn't understand...