Forum Widgets
Latest Discussions
How to freeze Excel tab at the start.
Hi, I've seen this before but can't for the life fo me remember how its done. I have an excel file that has multiple tabs and I want to freeze the first tab in place, so that when I scroll at the bottom to see different tabs, it stays in place. How do I do that? Thanks
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 well
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.
Cumulative 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.Need Help with Error
Hello. I'm hoping someone can help with this error. I'm not sure why this error is occurring because I haven't changed anything in this book regarding Active X Controls and this is happening with multiple files of the same type originated from a template that I've created. I've attached the screen print of the errors. These are the steps I've taken to save the file: Click: File-Save As Save As window appears Name file, choose Macro Enabled Workbook Click Save Error message appears: Errors were detected while saving... Click: Continue Save As window appears Click: Save Error message appears: Excel encountered errors during save.... Click: Ok Repairs to 'file name' box appears Click: Close File does not save. I click Save and the same thing happens.
Populate future date
Hi, Is it possible to create a formula which inserts a future date, either 5 working days or 20 working days or blank Sheet includes a received date, column G, the formula would be in column H if column I states Yes then I'd like a date inserted into Due date column H = received date plus 5 working days. So if received date is 1st November 2024 (01/11/2024) the 5th working day date expected is 8th November 2024 (08/11/2024) If column I states no then I'd like a date inserted into Due date column H = received date plus 20 working days. So if received date is 1st November 2024 (01/11/2024) the 20th working day date expected is 29th November 2024 (29/11/2024) If column I is blank then keep as blank Thanks in advance if you can helpExcel desktop formula connection to Excel online
Hi community, I've searched online for a solution to directly connect to a sharepoint excel or excel online in the formulas. Most sites say its not possible and then this guy has an issue with a formula that seems to work: ='https//SERVERNAME.sharepoint.com/sites/XXXStoreDevelopment/Doc Box/[SUT_Rates_01012023.xlsx]TxRates_20230101'!$G:$G But when I try to recreate i cant get it to work, - Do you know why? - Can you help me with the syntax in the url that opens up/ links to the data? -at what level should the last dash be: /[SUT_Rates_01012023.xlsx]TxRates_20230101'!$G:$G - and do you need to set it up in a table, like it seems here: [SUT_Rates_01012023.xlsx], or is it the name of the sheet? Many thanks for any help
