formulas and functions
25376 TopicsFormula Excel Help
Hi, I'd like to create a formula which looks at column F and if it contains words, "Jay", "Em" then to go to column B AND C and if they both state 'Complete' or 'NA' then to return words in column D with 'Case Closed' If column F does not contain 'Jay' or 'Em' then return a blank If one of the two Column B and C contain any other words then column D should return words 'Case Open' Hope that all makes sense. Is this possible? At the moment I have a formula which only looks at column B and C, this is the forumla with the actual column table headers: =IF(AND([@[Servicing Status]]="Complete", [@[Complaint Status]]="Complete"), "Case closed", "Case Open")Solved9.6KViews0likes24CommentsPivot Table
Hi everyone, I have an issue with the pivot table. There are filters from slicers and row labels in the table; when I double-click on any category from the table to see the filtered data, Excel fetches all data, not just what I filter on. Like below, I filtered from the slicer, and from the row labels, (Bills) should be between 100,000 and 200,000. I would like to see the (Bills) for (Central) in the (Start), but it gives me 632,478 and bills less than 100,000 and 200,000, not the 3 clients. Even if I tried from (In Progress), it's the same; it brings all data. The issue is only with the Bills column, but other filters come up correctly56Views0likes1CommentExcel add same formula easy way
Hello, I have numbers in C1 till Z1 cells. I would like to multiply these cells value with A1 value. Example: +A1*C1, +A1*B1......+A1*Z1 I know I could write one by one. But is there a simple way to add all cells to this formula? So if I change A1 cell value all the values have to change. C1-Z1 is not fixed. It have to change when A1 changing.1KViews0likes6CommentsExcel image not showing up on Windows users
I use Excel on Mac, and I've prepared a quotation list with all of the product images inserted into cells. When I send the Excel document to another Mac user, they are able to see the images. However, when I send it to a Microsoft user, they don't see any images in the document. I've attempted to upload it to Google Drive, but I encountered the error message below: Does anyone know a solution to this?1KViews0likes2CommentsCountIFS/SumIFS Question
Hello everyone, I'm working with a lot of data, and trying to find a way to add quantities already in the sheets but spread out over 500 or more rows. I'm not able to change how the data is delivered to me, as it's a downloaded file from a 3rd party. Here's a sample of what I'm looking at: A B C D Plain Bagel 7 Plain Bagel Bagel Spreads Cream Cheese 5 Plain Bagel Bagel Spreads Butter 2 Plain Bagel Toasted/Warmed Yes Toasted/Warmed 7 Double Espresso Food Selection Plain Bagel w/ Cream Cheese 4 Hot Chai Latte Food Selection Plain Bagel w/ No Spread 2 Iced Coffee Food Selection Plain Bagel w/ Butter 6 Basically, I'm trying to add the numbers in column "D," but only if these requirements are met: If column A says Plain Bagel, column's B and C have to be empty. If column C has any type of Plain Bagel, then those should also be added. In case it's needed: I'm currently using Excel for the web, but I do have access to the desktop version as well.Solved223Views0likes12CommentsWelcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel Team66KViews30likes98CommentsCharting help needed
Dear Experts, I have a data as below, So , in Column "G" we have 2 Rntis( 21,8,66 & 53714), and I need to plot the time difference for report of each rnti, which is calculated by subtracting the consecutive - SFNs, for that rnti. Now , the problem here is that in below for example , for the rnti-53714, it's not correct, for example at row-244, my last report for rnti=53714 came at row 241, so the difference should be (821-789) * 10, while in my case it's doing the subtraction in consecutive SFNs, which basically messes up my analysis. I tried to do something like below from column W to AF, but not sure how to achieve this properly( X axis should be my time, Y axis should be my average-ms and distribution should be based on the RNTI. Attached is the worksheet..(anything in -ve and above 400 is Outliers and need to be removed) in ms column also. Thanks in Advance! Br, Anupam112Views0likes2CommentsData Model error
I am getting the following error in Excel. "We couldn't get data from the Data Model. Here's the error message we got: An unexpected error occurred (file 'pcminorobjcoll.inl' , line 109, function 'PCMinorObjectCollection<class PCProperty, class NameHashSupport> :: SetNameAndUpdateCollection'). I have found various articles that have suggested going through and checking the source data headings. I did this and nothing seems to be out of the ordinary. https://contexturesblog.com/archives/2020/03/26/excel-pivot-table-refresh-error-with-data-model/ Is there anyone that can help me? The document is fairly large and used frequently by staff. I'd like to avoid recreating it, or tearing it apart. If possible.37KViews0likes11CommentsSheet 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.986Views0likes7CommentsExcel TEXTBEFORE function went away and gives #NAME? error
Hi all, I had an Excel sheet working using Office 2019 on a Windows 11 machine using the TEXTBEFORE function. Now after the latest Windows update, the function seems to have disappeared from excel? I now see #NAME? errors, and its not an option for selecting when adding a new function to a cell. The functions were also auto-replaced with a new prefix: ``` =_xlfn.TEXTBEFORE(L241, " ") ``` I'm on Excel Version 2410 Tried to add the build number, but I get an error on publishing saying "##.#.#### is not allowed in the community" Anybody else seen this or have any ideas on what's happening?982Views0likes4Comments