QUESTION : For my work, I regularly open data in Excel 365 that comes to me in a weird CSV […]
Tag: microsoft-excel-365
Finding highest numerical value from a range of hybrid data in Excel
QUESTION : I have a row of 6 alpha-numeric values as in the picture. I need a formula that will […]
Geography, Stocks – Excel’s rich data types / linked data types
QUESTION : In Excel 365 (the full online version), I see there is such functionality: Now, I find articles implying […]
I’m trying to get live exchange rates into a sheet/cell
QUESTION : Excel 365 or excel V. 16.36 on a Mac. I’m trying to get live exchange rates into a […]
How to format the table like this
QUESTION : I have the following table and past it for test case in CSV format too: ;;Prediction;;;;Real Result ;;Shares;;Likes;;Shares;Likes;Notes […]
How can I format a character string in Excel to insert hyphens?
QUESTION : I have a string in a cell that is 8 characters. E.g. ABCDEFGH, can I use a custom […]
Extract current YEAR from sheet name which contains months
QUESTION : =MID(CELL(“filename”,AM4),FIND(“]”,CELL(“filename”,AM4))+1,255) Hey all, Im Using the above to get the sheet name which are months, but to return […]
Unpivot multiple columns into two distinct ones without VBA
QUESTION : I’ve got a dataset that has thousands of rows and multiple columns for questions and answers that expand […]
How to place insert shapes to upper level in Excel 365?
QUESTION : Until Excel 2016, the GUI allows easy access to the Insert > Shapes in the top level of […]
automatically mirror =NOW value from one cell to another
QUESTION : I am using an excel file to upload data to a database. During the import specific cell values […]