excel
41634 TopicsLookup 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.17Views0likes5CommentsHyperlink() kills sharepoint file links
I have a concat that takes a site base URL: https://foobar.sharepoint.com/:x/r/Shared Documents/ and links it to the known file structure to reach a file, to reference a total in it automatically, save me manually going and finding the files and totals in each one. However when I use hyperlink() to make it clickable, it takes me to URL: https://foodbar.sharepoint.com/Shared Documents/..... remaining correct file path The hyperlink command seems to be stripping the :x/r/ and making the file unreachable. If I type them in manually I get to the file. Is this expected behaviour?3Views0likes1CommentHow 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? Thanks4Views0likes2CommentsHow to unprotect Excel sheet if forgot the password
I recently encountered a problem and hope to get your help. I set a protection password for an Excel file before. Now I want to modify some data, but I found that I forgot Excel password. I wonder if there is any way to remove the protection or unprotect Excel sheet password? If anyone knows a related solution or has had a similar experience, please share it, thank you very much! This file is very important to me, and there is a lot of work data in it. I have tried some methods found on the Internet, but none of them worked. It would be great if someone could provide some specific steps or recommend some tools.Solved492KViews0likes40CommentsInput 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.28Views0likes3CommentsCumulative 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.38Views0likes5CommentsPlease 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. Chris63Views1like6CommentsSelecting Data Based on Multiple Criteria
I need an Excel Formula Wizard to help me with data selection. Following is an example of my data: It is a list of leads that have been received through two different marketing channels (ECO Portal and Seminars and Roadshows). This is what I'm trying to accomplish: If an 'Account Name' has leads from both of the 'Lead Generators' of 'Eco Portal' and 'Seminars & Roadshows' (not just one of them) and the 'Closing Date' falls within the date ranges of the 'Created Date' and the 'Plus 6 mos' date, and the 'Status' is 'Won', then select the data and include 'Sales $' in total. Data should be summarized by Account Name. My spreadsheet has 32K records, so it is extremely slow going through these one by one to get what I am looking for. Thank you!68Views0likes8CommentsPopulate 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 help56Views1like7CommentsSearch table based on 2 criteria
Hello clever people, I'm trying to find a formula to return a cell in a table, based on finding the right row and column, from two cells that are using drop-down lists. I have a table of hours and based on months for rows and percentage of time in the columns. I have two drop-down lists, one which selects the months and the other selects the percentage of time. I then need to find the number of hours in the table based on these two criteria. For example: 12 months and 4% should return 66 hours in my yellow cell. Does anyone know what formula i should use please? Many thankss FranSolved27Views1like4Comments