name manager rejecting lambdas
I tried pasting a lambda in name manager but excel refused. I belive that it's because either it is too long (which it isnt) or it has too many optional parameters (8). Anyone knows why name manager will reject to paste my lambda? These are the parameters: =LAMBDA(array,slice1,[index1],[return_index_slice2],[index2],[return_index],[if_not_found],[logic],[headers],[function],LET(...))
Using a combination of IF Statement and LET function
Hello, I am trying to do the following from the attached link: If the Fiscal period date in Col B (of the SORTED_INV_CN worksheet) is greater than/equal to Dec 2025 or less than April 2025 then type in "Ignore" Else, use the LET function to lookup by Invoice# in the LookUp-Comment worksheet However, the function in Cell D2 of the SORTED_INV_CN worksheet is returning "Ignore" for all the rows in Column D. At the end of the day, I am required to evaluate the xlookup function for date range less than Dec 2025 and April 2025. I am partial to the LET function as it reduces the need to add a 2nd xlookup formula. The LET function works without the parent IF function but is returning erroneous data as soon as I incorporate the IF(OR( function. Here is the link to the file: https://docs.google.com/spreadsheets/d/1oiWWXXOSorZuB5Q4vzgdHO_kyRkvGE3L/edit?usp=drive_link&ouid=103354753371375324640&rtpof=true&sd=true I think the problem lies in the way the date format is being interpreted between the evaluation cells. Hope you can point me in the right direction. Thank you. Regards, Shams.
Sheet View Issues with Excel Web Browser
Hi, I have created a Excel document for my department to use, I tried Excel App but due to the size of the Spreadsheet it kept freezing, as a result I switched it to use Excel through Web Browser. The sheet no longer freezes which is good. I do have another issue though.....I wanted multiple users to be able to access, edit the sheet at the same time so I did some research and Sheet View seemed to be the way forward. I created a Sheet view for each employee to use so when you go to View, Sheet View and click on the relevant person their work is updated, saved etc and this shouldn't affect others view. This is working in terms of people editing. The main issue now though is that despite following advice sometimes when someone changes a filter on their own sheet view it seems to change others view. My understanding was you can hide, filter etc within your own Sheet view but this doesn't seem to be the case.......PLEASE HELP!!!! My excel and computer Skills aren't excellent to please any simple advise would be great.My Percentage of total sales is not 100 - Why?
I have 20 categories of Sales Revenue in Column A, the total revenue for each category is in column B, the % of a category, as it relates to the total categories is in column C but the Total Percentage is over 100% when I total all the percentages, what am I missing? Amount % of Sales Backup & Recover-Desktop Suppor 70,808.50 2.2% Barracuda Back Up - Cloud to Cloud 11,220.00 0.35% Barracuda ESS - Security Edition $51,508.57 1.62% Barracuda Sentinel 20,093.52 0.63% Carrier Management / NOC Support Services $239,618.99 7.54% Cust Support Srvs/Provisioning/vCIO Svcs $98,514.00 3.10% Field Services Support-Single $1,447,941.00 45.56% FTE Tech 159,227.50 5.01% Hardware Lease Revenue 11,114.22 0.35% Help Desk Services 1,604,649.85 50.49% IH-New User_Laptop Setup $230,523.19 7.25% IH-Remote Work Support Services 60,172.85 1.89% MRR - Data Services/Ticket Overage $40,057.00 1.26% Network & Security Hardware $985,825.90 31.02% Network Monitoring Service-Devices 153,696.60 4.84% NRR - Carrier Management / NOC Services 11,245.00 0.35% NRR - ESS Email Security Services 28,865.00 0.91% NRR - Help Desk 46,500.00 1.46% NRR - Migration Implementation 98,595.00 3.10% NRR - Monitoring Services 15,000.00 0.47% Remote Server Monitoring 102,455.03 3.22% Remote Work/Sharepoint Migration $84,026.55 2.64% Shipping & Delivery Fee 49,970.63 1.57% Software/Licenses 491,422.97 15.46% TOTAL $3,178,015.20 192.35%
Formula/method to link the data/responses I get from my forms into a different table.
Hi everyone! I need help with a project that I'm creating. Im making use of Microsoft Forms in order to input certain information. I made use of branching since some answers depend on the previous choice. So moving on to my problem, I want my table2 to get the responses/data from the data table created by the forms. Table 2 Table of responses For reference for the spill error, here is the formula that I used. Any insights will help a lot. Thank you have a great day everyone.
