Forum Widgets
Latest Discussions
BOM explosion - repeating sequence of arrays
I have 2 tables, Table 1 and Table 2 Table 1 shows the products I have to make, Kit 1, 2 and 3. Table 2 shows the items used to make the kits. In the resulting table I would like a list of the 4 products to make from table 1 exploded with the items to use in each kit. It's quite similar to a previous thread about a repeating sequence of arrays, the main difference that each row from table 1 have to be repeated a different number of times depending on items in table 2. Any help that guide me in the right direction is very much appreciated. I know how to make this in VBA, but I think it can be done using array formulas which I prefer as they expand automatically of rows in table 1 or 2 changes.Solvedk_pedFeb 13, 2025Occasional Reader62Views0likes4CommentsWhat causes an excel file to 'Show Print Preview' rather than show the preview by default.
I am curious what causes this to happen, I have already set the print area etc., but for some reason I don't get an immediate preview when going to print, I have to click this button inside the print preview. (I have also attached the full screenshot Doesn't seem to matter what settings I change so far, just curious what exactly causes this change in excel, I have many other documents that just bring up the preview straight away when going to print, but at the moment, this one particular file I have to click another button. I have a MS flow that converts excel files to pdf automatically after a review process, but it keeps failing on this one file and I can't figure out why, but I think the key revolves around this, so I really want to find out what causes excel to present an additional button that you have to click to generate a preview rather than showing the preview off the bat like it does with every other file which works fine in the flow. ThankyouModulaFeb 13, 2025Copper Contributor8Views0likes0CommentsSorting data by time.
Dear community, I have this Excel file with lots of data that I have to filter. My issue is that I have a lot of duplicated coordinates (Column E and F); however, I can't delete all duplicated coordinates because I would like to keep valuable data from other columns such as G,H,I,J which has unique values. Question 1: Is there a way to filter the data from column A based on time ? For example, I would like to remove all rows that have less than 5 minutes in between each other. Question 2: Is there a way to compress the duplicated coordinates from column E and F without removing the data from the G,H,I,J columns ? Thank you in advance, and I appreciate your help.Stefan22Feb 13, 2025Copper Contributor35Views0likes1CommentLarge space suddenly appeared between formula bar & A1 - HELP!?
I don't know what happened or how to fix this. Suddenly I have a large space between the formula bar and the beginning of my spreadsheet (A1) and I can only read about 3 lines of information. Not only did this happen on the spreadsheet I was working on but it spread to ALL of my workbooks, including when I I tried to open a brand new one. It's like Excel itself went crazy. What happened & how can I fix this? SherriSherri LawryFeb 12, 2025Copper Contributor222KViews0likes35CommentsRuntime error popup hiding in Mission Control - not accessible
Hi I'm running Excel and VBA on a Mac with a couple of screens. If I receive any type of Runtime error popup, it does not appear on either of the screens as an overlay on my worksheet or VBE. I can locate the runtime message by pressing the Mission control key F3 and select the message by clicking the mouse on it or pressing space. However, none of the buttons (End, Debug etc) are functional when clicking on them. The box just minimises and I'm stuck on the error. How do I take control of the box and progress by acknowledging the error? Esc doesn't work here either.PhilskyInOzFeb 12, 2025Copper Contributor3.8KViews1like7CommentsExcel Drop Down Box
I would Like to know if it is Possible to increase the width of the dropdown box in excel. the infomation i have to be shown in the drop down box does not fit in the little box. Can it be increased in width to show all information? ThanksZR1-638HPFeb 12, 2025Occasional Reader15Views0likes1Comment"OVERWRITE EXISTING CELLS WITH NEW DATA..." GET DESELECTED
HELLO , I HAVE OFFICE 365 . FROM 1 MONTH AGO THE BUTTON IN DATA TAB THEN PROPERTIES AND IN IT "OVERWRITE EXISTING CELLS WITH NEW DATA..." GET DESELCTED AUTOMATICALLY AND WHEN WE REFRESH DATA IT GET OVERLAPPED . EARLIER IT WAS WORKING FINE LIKE IN SCREEN SHOT WE HAD SELECTED "OVERWRITE........" TAB BUT WHEN WE PRESS OK AND REOPEN IT IT GET DESELECTED PLEASE HELP ON THISPREETFeb 12, 2025Copper Contributor58Views0likes3CommentsHow to fill a range of Sheet A with data from Sheet B by repeating this action for each value
Hi, I have two sheets A & B. Sheet A has a table where A1:H1 is the header. The range C2:C9 of this table is blank but there is data in the ranges A2:B9 and D2:H9. Sheet B has data in the range A1:A43. I have to fill the range C2:C9 of Sheet A with data from Sheet B by repeating this action for each value in Sheet B.SolvedDan1ExcelUserFeb 12, 2025Copper Contributor100Views0likes10Comments
Resources
Tags
- excel42,196 Topics
- Formulas and Functions24,461 Topics
- Macros and VBA6,352 Topics
- office 3655,936 Topics
- Excel on Mac2,617 Topics
- BI & Data Analysis2,332 Topics
- Excel for web1,878 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,608 Topics