Forum Widgets
Latest Discussions
What happens if your Facebook account is hacked?Secure^Account
Visit the Facebook Help Center 866-798-O445 to report the hack and follow the steps to secure your account. Use the "Hacked Accounts" option under the "Security" section. You may be asked {866}-798-O445 to verify your identity, change your password, and review any suspicious activity.
What if someone hacked Facebook and changed my email and phone number and password?
Visit the Facebook Help Center 1*833-422-1450 to report the hack and follow the steps to secure your account. Use the "Hacked Accounts" option under the "Security" section. You may be asked (1)833-422-1450 to verify your identity, change your password, and review any suspicious activity ()1() 833-422-1450.
How can I chat with Facebook support? ProBleM SolVeR**
If you're looking to chat with Facebook support ❤️**(1)-833-202-6822**❤️, simply head to the Help Center on Facebook's website. Click on the "Support Inbox" option, and you'll be able to chat with a representative ❤️**(1)-833-202-6822**❤️who can assist you with your concerns. Remember to be patient and provide detailed information to help them help you efficiently. Happy chatting!
Input Info in only 2 Columns
Good morning, Thanks to the help of everyone my sheet is coming right along. I got 1 more thing I would like to see if it is possible. Currently I have 10 Columns 6 out of those 10 are generating automatically through formulas. Everything is being doing with Bluetooth scanners. Box 1 (ID) Box 2 (Radio) box 3 and 4 has info that sometimes needs to be manually entered. My question: Will it possible to set something up where my scans can go A2 to B2 then A3 to B3 etc. I was able to do it by locking all other cells but like mentioned before every once in a something has to be entered on C2 and D2. Also have tried selecting A2:B20 and creating a selection name and that partially works until I have to click out. When I reselect the range, it starts from the top again. Any suggestions would be highly appreciated.
Lookup Value From a Chart
I am trying to figure out how to find a value from 2 other known values. I tried doing this with a lookup and I am unfamiliar exactly how to do so. Any help with direction on this would be greatly appreciated. In the example, you would enter your "Overhang" and "Pitch" on the upper right corner and it would give you the Result needed from the yellow chart.MAX & IFBLANK Formula Combined
Just wanted to say thanks to everybody out there that continues to help us less knowledgeable Excel users. I have a range of values from K106:O110. There are situations where they are either filled with a value or they are blank. I want the maximum value of the range to be displayed in cell D275. If there is no values in the range of K106:O110. I want cell D275 to be blank. Right now I can only get a "0.000" when my range K106:O110 is blank. Current D275 cell string: =MAX(IF(ISBLANK(K106:O110),"",K106:O110)) What am I doing wrong? Thanks in advance for your help!
Macro to sort data
Hello, I want help with macro code: Here's the macro I'm using: Sub ClearAndSortDataAutomatically() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Review") ' Ensure this matches your actual sheet name ' Clear existing sort settings ws.Sort.SortFields.Clear ' Unmerge any merged cells in the specified range if necessary ws.Range("A8:P84").UnMerge ' Adjust the range as needed ' Perform the sort specifically for the range K9 to K84 With ws.Sort ' Sort by Segment (Column F) Z to A .SortFields.Add Key:=ws.Range("F8:F84"), _ SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal ' Sort by Indicator (Column E) A to Z .SortFields.Add Key:=ws.Range("E8:E84"), _ SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal ' Sort by Total Procedure (Column P) Largest to Smallest .SortFields.Add Key:=ws.Range("P8:P84"), _ SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal ' Sort by Set# (Column K) A to Z .SortFields.Add Key:=ws.Range("K8:K84"), _ SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal ' Perform the actual sort limited to rows 9 through 84 .SetRange ws.Range("A8:P84") ' Adjust range as needed within the specified limits .Header = xlYes ' Indicates that the first row is a header .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With ' After sorting, merge the cells from A9 to A44 ws.Range("A9:A44").Merge ' Merge the specified range End Sub Here's what I want to achieve in excel Segment first in Z to A order Indicator A to Z total procedures Largest to smallest Set # Z to A Please note: My data starts row 9 and column A9 to A44 is merged cell, also, I have column G to Column J hidden, column N&O are hidden. I have attached excel wb where one is before sorting how the data looks and other tab is after sorting how the data should look like. appreciate any help, I'm open to any other suggestions as wellCumulative Average of other percentages (non-contiguous range)
Please help me figure out a formula to calculate the cumulative average of the semester averages. Keep in mind that many of the semester grades will be 0 because we haven't reached those semesters yet. I need a formula that will show " the real time" program cumulative average.Please update Excel to handle more than 15 digit numbers!
I'm a professional database designer, and this limitation has caused me no end of headaches. The problem: numbers that are more than 15 digits long have all digits after the 15th converted into zeros. Microsoft provided workaround: format the the field as text. This workaround is only useful if you are doing data entry directly into an existing Excel spreadsheet that you are able to format the cells ahead of time. It's incredibly unhelpful when you are pushing and pulling data from different data sources. For example, if I need to push data out of a program like FileMaker to Excel, and the system I am pushing from has numeric fields (in particular ID fields), excel sees them as numbers and replaces the digits after the 15th. This jacks up formulas as well as any data synching possibilities. In situations like that, I end up having to export the data as .csv file, and then pull it in to an excel sheet and then do a bunch of conversion options on import (which does not always work, btw). But this is not a practical solution for every day users who are not tech savvy. I should be able to export the data directly to excel without the data being converted. This has been a big problem for every client I have that requires data being pushed to Excel. And this problem has existed for decades. Other spreadsheet programs (like google sheets) do not appear to have this issue. Can someone please explain why Excel continues to cling to this archaic standard? Are there any plans to update Excel to handle more than 15 digits? I know I am not the only one who has run into this problem. I've seen all kinds of posts about it. But trying to let Microsoft know how much of a problem this is has been a challenge. Their article on the subject had a link to give product feedback, and that link led me to this space. So here it is: product feedback for Excel. PLEASE FIX THIS! Thank you. Chris
