Forum Widgets
Latest Discussions
Change Default Browser in Which Hyperlinks Open
Moments ago for whatever reason, my Excel Home and Student 2021 began opening hyperlinks in Edge. I did not change this setting. How do I change the browser back to Google Chrome without editing the registry? If it makes any difference, I am using Windows 11.grasFeb 10, 2025Occasional Reader39Views0likes6CommentsRepeat list of items for each month in table
Hi all I am looking to have an automatic repeating list of items that repeats based on the amount of months in a table. If however a month is mentioned in the list of items, the item will only repeat for that month only and not all the months in the table. Please see my example spreadsheet with the desired output, which should make it clear. I just need a formula to make this output table. I guess LET would be possible, but can anyone help please? Thank you Mattmatt0020190Feb 10, 2025Brass Contributor20Views0likes1CommentMissing slots calculation
Dear Experts, I have data like below:- Each Frame(Column A) has 4 corresponding slots(Column B) :- So, A6(955) has entry 3,8,13,18 , which is a complete set, and so on as shown in the ok(complete set) example. In column J, K , I want to populate the Frames(J == SFN == Frames) which are in complete and in Column K, want to populate the slots which are missing in those corresponding Frames. Attached is the Worksheet. Thanks in Advance, Br, AnupamSolved121Views0likes9CommentsEfficiency request - Splitting sheet by owner
Hello, I am looking to create a sheet for each sales rep to be able see just the accounts they own. Currently I've been manually duplicating the sheets and doing 5 minute of cleaning to get it to a view that was just the reps while maintaining the existing drop downs and formulas. Would love some advice on how to automate creating the separate sheets per user. Thank you!23Views0likes1CommentCheckbox online disappearing when doing to desktop in excel.
When i use Office365 online i can use insert> checkbox and can see the box, when i open it on desktop version the box is gone but can see the true and false value in the formula barSavageswayFeb 09, 2025Occasional Reader21Views0likes4CommentsDegenerate MAP blows up Excel
Does this formula work for you? =MAP(0,1,LAMBDA(x,y,x+y)) Which Build are you on? I am stuck on 2406 because all Builds since blow up when running my spreadsheets - which, as I type this, JUST MIGHT be down to this nonsense. Not only does this innocent instruction return #VALUE!, it also appears to corrupt Excel beyond recovery. Which is a problem because the MAP(LAMBDA( phrase is a wrap one needs to deploy when a Lambda(a,b... might have to handle vectors for a and b to return a vector of results for a computation that will not support such vector inputs natively. The cure for this nonsense on my Build appears to be =MAP(HSTACK(0),HSTACK(1),LAMBDA(x,y,x+y)) Unfortunately, it is hard to remember this. I might have to scour my Lambdas. The problem only appears to concern MAPs with multiple vectors. =MAP(1,LAMBDA(x,x)) is just fine.ecovonreinFeb 09, 2025Iron Contributor32Views0likes1CommentFormula assistant
Hi All, Attached the following pic: Im trying to create the yellow cells by formula (I made it manually) the rules: if the column date and the raw date is a match so it should give us column H value (exm:cell J7, the column date is 01/01/2025, same as row 7 date so im getting H7 value) one cell to the right where we got our match I want it to take the left cell divide by minus 4 and multy by 3 (15360/4*-3 = -11520) and than to the next 3 cell to the right, I want to get the -11520/-3 = 3840 after 3 cells I want it to get zeroed, thx all in advanced !TomerIwanirFeb 09, 2025Occasional Reader44Views0likes3CommentsAI to work with Excel
Hello All, I have been trying to find an AI that can help be transform data in Excel. The specific task at hand is to transform data from a cash register into a csv that can be directly imported into a German accounting software named DATEV. It has some specific requirements concerning amounts (no thousand separator) and a date format that is a bit odd. So far, I just pivoted the sales transaction data into a table with 8 columns for each product category and copied them manually into a csv that can be imported with no problem. That takes about 20 minutes, checking for errors etc. Now I just spent 90 minutes explaining the task to ChatGPT, but it kept spitting out only nonsense, completely unusable. I could of course learn python pandas, but that would take a while. Does anyone know an AI that can translate a fairly simple format into another fairly simple format? Thanks.alexmeneikis_17111969Feb 09, 2025Copper Contributor18Views0likes1Comment
Resources
Tags
- excel42,172 Topics
- Formulas and Functions24,447 Topics
- Macros and VBA6,348 Topics
- office 3655,930 Topics
- Excel on Mac2,616 Topics
- BI & Data Analysis2,328 Topics
- Excel for web1,878 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,606 Topics