Thanks so much, Mynda for your enlightenment and patience. Have a great weekend with your loved ones, Mynda
Hi Mynda, Thanks so much for your quick reply. The thing is because my data is quite messy, I need to clean it up using some formula each time I ha...
hi Anders I have tried repairing the office installation before but it didn't work. I feel it is a dead end. I prefer to use full screen instead...
Hi Frans, Actually, even with a newly open file, I also have the same problem - full screen with formula bar. I attached a short video and the f...
Dear Philip Thanks for your reply. I don't think I would ever understand why the EXCEL developer team would let the column number (in letters) t...
Hi Velouria and Mynda, Thanks for your reply. Actually, my question is - with the same index formula ie same range with column 0, why in both the ...
Hi Mynda, Sorry, I guess when I uploaded the file earlier it was not attached properly. Hereby I attach the file again. Thanks again Mynda ...
Hi Mynda, Thanks so much for your quick reply and your advice. When I inserted 3 columns in the data worksheet, the 1st column data appears er...