[52 week high] formula not working
I have a spreadsheet where I track my portfolio data. I have attached a sample. It appears that the "[52 week high]" formula is not working properly. It shows up as the same price as the current "Price" for most securities. While this is in theory possible, the "Price" is below the "[Previous close]", so therefore it appears incorrect. Is this a known issue? How can it be resolved?
Formula challenge: re-shape and cleanup
You're tasked with re-shaping and cleaning up the fictional Faber College alumni list to be used for a mail merge. Going from this: To this: To spice things up, the First and Last names must be in separate columns. Additionally, bellman records must not be included in your list (They've been contacted already). The rules are simple: The solution must be a formula. VBA, PowerQuery, helper columns, fill handle - not allowed. I've included my solution. I believe the best solutions for this exercise will involve some of the newest functions currently available on the Beta channel. I'm looking forward to seeing some creativity. Have at it!Can anyone help me with this SWITCH function
Hello Everyone, This SWITCH function is used to produce a number that then I can use to sort workers and their functions. =SWITCH(TRUE, IF(AND(ISNUMBER(J2)=TRUE,M2="Working")=TRUE,5,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Working")=TRUE,500,0), IF(AND(ISNUMBER(J2)=TRUE,M2="Special Project")=TRUE,15,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Special Project")=TRUE,515,0), IF(AND(ISNUMBER(J2)=TRUE,M2="Stand By")=TRUE,20,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Stand By")=TRUE,520,0), IF(AND(ISNUMBER(J2)=TRUE,M2="Special Project UFN")=TRUE,25,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Special Project UFN")=TRUE,525,0), 50 ) In Column J I have their Start Time, from the Kronos System, and in Column K I have their End Time. In Column M I have Tasks names that would indicate what each Team member is doing. Each component does evaluate correctly but the function always return 50? What am I missing here? Thanks in Advance! GiGi
Excel Help
Is there a way (either formula or macro /something) for the following. I have 2 different spread sheets (files) open at the same time. First is called Time Card Second is called Wages Time Card will have a staff members details as well as dates and shift times. (20 Tabs for different staff members and their details) Wages will have Tab 1 - Summary of all staff names, hourly rates, hours worked for each day and gross amounts to be paid Tab 2 - 20 payslips with the above mentioned details, but payslip style. Lets call the first person Joe Deer I need something in Time Card next or close, to this person's name, when clicking it it will jump to his payslip in Wages sheet As mentioned. Formula or macro.. Guess anything will do. Thanks
Unwanted pasting of data in new raw or column
There is a strange property of excel - when I have a range copied (a cell or more) and will like to add new columns or rows excel will add the with the copied rang pasted. It is awful, as it take time and sometimes leads to a crash. Is there a way to prevent excel from doing so? By the way I wonder when Microsoft will produce excel that does not crash?MSO Files being randomly renamed while open on desktop
Not sure if anyone is facing this issue - but I have been facing this for 2 months now and it is really really frustating..! While working on Excel, Word or Powerpoint - a lot of times (very frequent now) the filename of the open file (on which we are working) suddenly gets saved as a random number (e.g. 12456.xlsx). If we aren't alert - if you close this file - "You lose the original file from the original location". Gone - absolutely disappears. I tried to do some research on the issue and found - Closing Excel App and reopening will give you the randomly named file in 'recent' list - however you can't open it. Checked the hidden folders and found same name file in '.temp.upload' folder, but without any .extension Renamed this file to .xslx and I got all my data back. However - if you do not rcover your file on same day there is a chance that you lose this file forever. I understand now by some online surfing that this is a Onedrive Sync issue. However, my broadband is super - checked the data throughput for the instance and it was continuous highspeed without any drops. This has become so frustrating now that I am thinking of moving out of MSO. It is very stressful and distracting now to be continuously alert and check the filename every few seconds. Does anyone else face this issue? Are there any solutions for this problem?
Signature Line - Cannot use certificate to sign
Hello, I work for an IT support section and am having difficulties with resolving an issue with signature lines. The users have recently received new Windows 11 devices with Office 365 enterprise applications installed (Excel, Word etc.). Signing signature lines on Excel workbooks worked when they were on Windows 10 on their older devices. They had generated user certificates on their previous devices that were able to be used to sign signature lines with. I've used our Networks trusted CA to publish new certificates to the Personal > Certificates on the current user certificates. I've done this the same way as I did when on W10. What I've found is that the certificate is able to be used to sign documents in Word but not Excel. Version of Office: Microsoft 365 Apps for enterprise 2605 16.0.20026.20182 I have found the following error in the diagnostic log for Excel relating to the error code -2147418113 which the Microsoft error code tool advised it was a Catastrophic failure referenced as "E_UNEXPECTED". None of the information obtained so far has helped me fix the issue. The only clue I can see is htat it works in Word and not Excel. Can anyone advise?Excel worksheet protected but can't use text to column function
HI I have a worksheet that several people use that I need to protect. There are formulas and a pivot table. I have been able to lock what I need and am able to refresh the pivot table but I can not use the "text to column" function in the raw data as its greyed out. The area in question are not locked cells but the function is still unavailable. We need to be able to use the text to column function but I also need the sheet locked to protect the formulas.excel crashes changing font color
hi all, here is a good one. in excel (via microsoft365) I can open a speadsheet and enter data into a cell. I can't change anything with the font, color etc from the ribbon or the right click menu. It works with keyboard short cuts. Excel just hangs until I am forced to crash. I have tried with an existing spreadsheet on a different PC and it works fine. I have tried with a new blank spreadsheet with entry only in one cell, same. repaired MS 365, fast and slow, uninstalled and reinstalled to no avail. I am at a loss, any clues or directions? cheers
