excel
41632 TopicsInput 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.21Views0likes2CommentsLookup 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.13Views0likes3CommentsCumulative 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.36Views0likes5CommentsPlease 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. Chris62Views1like6CommentsSelecting 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!68Views0likes8CommentsHow 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.Solved491KViews0likes39CommentsPopulate 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 FranSolved25Views1like4CommentsXLAM load error with KB 5002653
Hello, Since applied KB 5002653, My .XLAM macros are no longer loaded by Excel 2016 at startup from the Addins folder (Fine with Excel 2021). The first character of the macro files that Excel try to load is truncated (first char is missing). Everything is fine if I uninstall KB5002653. Is it a know issue with the November Update ? Thank you NicolasSolved663Views0likes4CommentsExcel formula help
Hi all, I have a cell where it contains information such as below in cell A1. I want to use a formula to extract the dollar value of Orange (Navel) which is $1,091.49. This figure will change week on week range from $0 to $100,000,000. Any idea how can I do that? Revenue Apple $6,854,191.79. Revenue Orange (Navel) $1,091.49. Revenue Orange (Blood) $7,459.50. Revenue Water Melon $344.16. Revenue Pineapple $43,540.05. Thank you Regards, VinceSolved44Views0likes10Comments