FILTER function returning VALUE error
Hi all, I am doing a very simple FILTER function and cannot figure out why it is not working. Below is my data I want to filter. "ID" column is column A, "Eligible?" column is B, data are in rows 2-6. ID Eligible? 100 TRUE 101 TRUE 102 TRUE 103 TRUE 104 FALSE My formula: =FILTER(A2:A6,B2:B6=TRUE,"") Returns a #VALUE! error, rather than the IDs 100-103 as I expect. Can someone help me understand why? I have tried without the =TRUE, without the last argument, command+shift+return on Mac to make it an array function, and other things. I am stumped! Please help :) Thank you!
Vlookup not calculating
here is my formula...for some weird reason it isn't calculating... =VLOOKUP(A2,'RE GP'!A$1:A$5600,1,FALSE) it just remains in the cell as is, with the = sign and the formula I've used this formula for years, and never had an issue. Why won't it do the lookup? The range is correct, data is sorted in ascending order. I am looking to match content. I did it successfully looking from the tab RE GP at the tab where I want to do the look up. There aren't any extra spaces. It looks like my commas are in place. Thanks so much!
Excel filter search removing previous filter selections, MacBook
Copied from a Reddit post, which describes my problem perfectly: "I have a data set and I want to filter for a series of values in a specific column, say Albert, George, Quellan, and Zelda. My issue is that when I start filtering by name the filter automatically reverts to "Select All" or "Select All Search Results" So I will Search "Albert" and select it, then clear the search and the filter will be back on "Select All" I can search "Albert" and apply the filter, which works for seeing just Albert, but then when I search "George" I run into the same problem. If I search "George" it deselects "Albert" What works is scrolling through and finding each name manually, but there are many names so this is a bit inefficient. Does anyone know what is happening here? Is there some setting I can change so that I can just search each name, select it, then end up with all the names selected?" https://www.reddit.com/r/excel/comments/sq0oa5/excel_filter_search_removing_previous_filter/?rdt=36084 Does anybody know a solution for this? Thanks in advance, Frederik J.
Excel Power Query | Mac | Get excel from folders AND sub folders
HI All, Has anyone managed to get power query on mac working to load excel files from folders & sub folders? By following this for the main folder https://www.mrexcel.com/excel-tips/power-query-debuts-for-excel-for-mac-but-with-significant-gaps/ I'm halfway there but have hit a prob on the files that are stored in sub folders. It brings them back but doesn't ref them correctly (path is that of the parent folder) and so data load fails.. Thanks in advance DaveMicrosoft AutoUpdate error installing Excel 16.97
Hi, I am getting an update error installing Microsoft Excel 16.97 on Mac OS Sequoia. I am currently on 16.96. The install stops near the end of the progress bar for a long time and then I get an update error. I've had similar issues before and resolved by installing from the pkg file but I can't find the 16.97 install file.
Sorting in Excel using a Mac and using custom lists
I have created a custom sort list in Excel by going to Preferences > Sort and created a list. There was an old list there that I didn't need and deleted. My question is: when I go to sort the data and I click on Sort > Custom Sort and under the heading "Order", I click on the options and the drop down menu includes a selection that no longer need. How do I get rid of this? Does anyone have any idea please? TIA
Stock quotes from Refinitiv stopped working, any alternatives?
Hi, I've noticed that after March 3rd update to 16.95 on Mac my stock quotes from Refinitiv stopped working. There is no "stock" data type in the ribbon. Same thing with online app. Did you notice this? Are there any alternatives for stock quotes to this data type that gets data from Refinitiv
Excel in OneDrive and on Mac.
Hi everyone, I am working in Excel on a Mac and I cannot add a logo in the header, or type in the footer. all of the ribbon is greyed out so I can't select insert date. I have checked on Microsoft 365 updates are automatic. I have put the spreadsheet in page layout view. I have checked the margins. I have downloaded both documents one contains the logo picture, and the spreadsheet, but still unable to click on the image to paste it in the header. I have checked help function, and worked on it for several hours, but still unable to use it. Cheryl.Excel date function handling issues since April 10th update
Since April 10th update, some date function are not working properly and that's a huge problem when my spreadsheets depend significantly on searches based on dates. These problem is not only affecting new registers. It affects aswell all previous information making spreadsheets useless. Big problem when you rely on Excel to process a great deal of performance indicators of your business. For example, this formula "=TEXT(A1,"dd/mm/yyyy")" should return this result = "12/02/2025" but instead it shows like these "12/02/yyyy" making impossible to use it with any search function as Hlookup or Vlookup, for example. In this formula A1 is a specific date in "dd/mm/yyyy" format.
