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
79 Replies
- 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.
- hello, i have been asked to create macros which are "Create a macro in Final worksheet that with a click will replace what you have in the exchange rate column with the live exchange rate and "Create another macro that will set it back to 0.9 for all items". its for a spreadsheet i am trying to do for an assignment that's due tomorrow and i am wondering whether you could help me with this? if you want i could send the whole guide to give you context and my spreadsheet just for you to have a look. i have attached a google drive link below for the guide and my spreadsheet. if you go to the guide just scroll all the way down and you will the 2 macros mentioned.
https://drive.google.com/drive/folders/1o_Uk9Sgq2Bghs05zlNb1blBbTqE_YE1Q?usp=drive_linkPlease go to https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral , click on Start new discussion button and articulate your question. Low chances someone will answer in this thread.
- i have already done that twice and no replies unfortunately.
HI I have got an issue I hope you can help with.
so Lets say that Cell H7 is a Monday and there are empty cells below that, I would like to be able to get the excel sheet to pull the names from the week Rota to be displayed under H7
example
From B7 to B 15 I want names to come over to H8 - H15 if H7 says Monday and yes H7's day will change as the date changes so B then goes to F7 - 15 Monday through to Friday
Monday Alex / Tariq Alex / Tariq Dario Dario Dario / Elizabeth Dario / Elizabeth Elizabeth Elizabeth - Hello all,
whith this code in Python for Excel, gives #TIMEOUT Error. Any solution?. Thanks in advance
import hashlib
ip='cxdnnyjw'
ans=''
ans2='????????'
for i in range(10**8):
h=hashlib.md5((ip+str(i)).encode()).hexdigest()
if h.startswith('00000'):
pos=h[5]
ans=ans+pos
if pos in '01234567' and ans2[int(pos)]=='?':
ans2=ans2[:int(pos)]+h[6]+ans2[int(pos)+1:]
if ans2.find('?')==-1:
break
print('ans1:',ans[:8])
print('ans2:',ans2)It looks like sandbox timeout limit is about 30 sec. Didn't see the documentation, but
import time time.sleep(29) '*end*'works, adding couple of seconds gives #TIMEOUT! error.
For future please ask your questions by "Start new discussion" button at https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral . Your question in this thread most probably seen only few people who replied in past in thread, thus have notification.
Hi all
Not sure where to start a discussion, so replying to the welcome post here. In excel, I’ve got constantly updating current stock prices that’s fed in through an API. In the adjacent cells I'm hoping to statically record the reported stock prices in every 5 minute intervals. Say at 3pm the price was $1 and at 3.05pm it was $1.2. Is there anyway I can do this? Either vba or formula will be good. It should be automated. Thanks!
- This is the best place to create the discussion. It's been linked a few times already in this thread.
https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneralThank you! Sorry for posting in the wrong place. Patrick2788
Sangeeta Mudnal Thank you very much for allowing me to join this community.
I do have an Excel issue which I would very much appreciate some help with. Where do I post my query please?
On the first page, you should have seen this button:
"Start a new discussion".
I am unable to get cell to multiply ie @sum(333 x 444)
=333*444
- Thanks,
It is good to see that, here lots of new update and questions are posted by User, which helps to increase the knowledge. - Bonjour
Je n’ai plus le code source du VBA ( Visual basic) dans le développeur.
Comment je peux faire pour rétablir le menu développeur à son départ
