Forum Discussion
Welcome 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 Team
91 Replies
Sangeeta Mudnal I want to add multiple bullet points in one cell for multiple lines. Since the data is large where I need to do this for more than 1000 cells and every cell contains more than 20 lines. Hence doing manually would be almost impossible. Could not find any solution anywhere.
If anyone can help would be a great support.
That's more chanced to be answered if you Start New Discussion from this https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral page.
- Can someone please help me with my below post/question?
Thanks
Don
Don_Thornton replied to Sangeeta Mudnal
‎Jun 24 2024 08:07 PM
Hello: How do I receive help with a problem I am having with updating a file with "Stock" data types.
I have a spreadsheet that retrieves historical stock data. The file has over 3000 stock tickers. When I try to refresh the file I receive the following error message. Very few of the cells will update and most state #CALC! in the cell.
The error statement is: "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated."
I have used this function in the past and it has worked but every time I change the date to search by date, which is once every quarter, this message returns and it takes a long time to update the file. Microsoft has helped in the past but now states I need to reach out to this community for help as they cannot diagnosis the problem for me anymore.
Thank you in advance for any help or guidance.
Don Thornton The following formula returns "you have used too many arguments in the formula, where is the mistake that will correct this?
=IF(BJ67>0,IF(BJ68>0,IF(BJ67<BJ68,BJ69,IF(BK67>0,IF(BK68>0,IF(BK67>BK68,BK69,IF(BL67>0,BL68<0,BL69,IF(BM67<0,BM68>0,BM69,IF(BN67<0,BN68<0,BN68<0,BN69,0)))))))
You posted this twice, I moved the other one to a new discussion and replied there.
- Hello: How do I receive help with a problem I am having with updating a file with "Stock" data types.
I have a spreadsheet that retrieves historical stock data. The file has over 3000 stock tickers. When I try to refresh the file I receive the following error message. Very few of the cells will update and most state #CALC! in the cell.
The error statement is: "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated."
I have used this function in the past and it has worked but every time I change the date to search by date, which is once every quarter, this message returns and it takes a long time to update the file. Microsoft has helped in the past but now states I need to reach out to this community for help as they cannot diagnosis the problem for me anymore.
Thank you in advance for any help or guidance.
Don Thornton - Never mind, I found it!
- Hi Sangeeta, I'm new to the Community. I work for the Army as a federal government civilian Operations Research Analyst and use Excel extensively. Our organization uses Excel 365. I am always looking for tips and sometimes next help solving problems using Excel. How do I post a question to the Community, or am is what I'm doing right now the way to do it?
- The SpellNumber function is not working in Office 365, in spite of reinstalling the office 365
Please check previous post in this thread how to start the new discussion.
- Hi Excel expert team. I have a Excel formula which had been struggling me for sometime. I really need help to advise for a Vlookup table for my excel chart.
Is this a right place to share my issue?Please go to https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral and start a new discussion.
Please create a small sample workbook demonstrating the problem (without sensitive data), upload it to a cloud store such as OneDrive, Google Drive, Dropbox or similar, share it and include a link in your post.
- Customer Name Cust PO Item Code Product Category 3 Digits Code Returned Value
Example TUM 227.E0119.006 3M (653) 653 Being (227)
1 TUM 332.H0501.001 Ace Glass (108) 108
2 TUM 789.M0400.001 Advantech (110) 110
3 TUM 314.C0508.006 AikMoh (308) 308
4 NTU 376.W0500.004 Analtech (194) 194
5 NTU 168.T0907.009 As One (789) 789
6 Cargene 308.O8136.003 B.Braun (314) 314
7 Kuraray 304.B0609.003 Beatson Bottle (452) 452
8 Kuraray 304.B0609.003 Becton Dickinson (320) 320
9 Kuraray 789.S0600.002 Being (227) 227
10 Kuraray 314.C0508.003 Bel-art (280) 280
11 Kuraray 376.B0101.002 Burkle (116) 116
12 Firmenich 280.T0300.008 Changsha Yingtai (228) 228
13 BR Metals 308.00110.001 Chemoscience (332) 332
Can you advise me the excel formula for above chart by either using vlookup or solutions to match the first 3 digits product code in Item No. column with 3 digits in the bracket of Item code column. Return the match entire item code column into Return value column. Show me the result in the chart too. I had provide the first link as example of the return value. Appreciate for your help in advance.
