I dont have UNIQUE function
Good morning, Excel community! I need your help because I've noticed that I don't have the UNIQUE() function in Excel. I know there are other ways to find unique values in Excel, such as going to Data > Remove Duplicates, but I wanted to know why I don't have access to this function. I have the latest version of Excel, and I don't understand why it's not available to me, whereas my coworker does have it. I'm not sure if it could be because I have Microsoft Office Standard 2019. I work as a data analyst and, if so, what functions am I missing out on for data validation? What are the new functions that I don’t have access to? Thanks in advance for your help.
PLEASE HELP - Excel Horizontal Scroll Not Working
Hello all: I have an excel workbook that is many columns wide. I am on a Macbook Pro, Office 365. Scroll lock is *not* on, please do not suggest I turn it off. I can scroll in other workbooks. On this workbook, if I am selecting cells and trying to scroll horizontally, it won't continue the horizontal scroll beyond what is visual on screen. I am extremely annoyed, please help. Thank-you, CarlIssue With Pasting on Filtered Rows in a Excel Table : MAC
I have this issue, where, if I copy a cell, and paste on the filtered rows, the paste happens on all the rows and not only the selected row. This happens specifically when the range is in a Table. Detailed Video - https://app.vidcast.io/share/c164a6c7-ecd9-4667-8d76-008a5cb910f3 Can anyone help me with this?
Cross Reference with variable data
I have to cross reference two worksheets. I have mocked an example below. Sheet 1 lists a Credit card statement. Sheet 2 is an Amazon purchase list. I have to check that the CC data is picked up in the Amazon worksheet and return YES or NO to a column. This is to stop double counting. Here is the variable problem. The dates don't match up between the sheets (usually +/- 1day because of CC/amazon processing); and an amount could be seen multiple times in the array (same purchase twice or another purchase of the same price). My solution has been to Filter both sheets by month so I have less entries to manually scan. Is there any way to formulate considering there are variables? Been playing around with combo of =IF(AND(VLOOKUP)) but can't quite get there. Any help most appreciated.Saving Excel files on Mac
Hello everybody, I am looking for help with saving my excel files on Mac. I am using excel files with macros, but when I open it on OneDrive Windows and save it and after that I want open it on OneDrive Mac, it automatically turns off autosaving and shows two problems. - An unexpected error occurred. Automatic refresh has been disabled for this Excel session. and after that, when I want save file - Errors occurred while saving file ///. Microsoft Excel can save this file only after removing or fixing some features. Click Continue to make corrections in a new file. To cancel saving the file, click the Cancel button. It looks like file is broken, but every file I have cannot be broken. I can't save it. This problem is with every macro file on Mac. Has somebody this problem? Thank you for your help
Excel links used to open in one click
Company uses microsoft teams to mange construction projects. One hope page with links to each jobs tracking page. The links used to open in one click, now we have to hover, and click on the popup link, or use command click to open the link on mac computer I’m assuming an update of sort changed this. How do I reset it to open links just by clicking them once?? Thanks!!
