Forum Widgets
Latest Discussions
Excel Maps not showing all options for regions
Good morning , I am trying to generate maps with excel, however I don't visualize the possibility to select Multiple countries/regions and Countries/regions, only World and regions with data. The first screenshot is how it should be, the second is my Excel program. Does someone know why? thank you for any help (consider that I am at Excel for dummies level... ) MarinaMarCar80Feb 13, 2025Occasional Reader0Views0likes0CommentsA side panel for drawing borders
Hello all, A few days ago I found an option to more easily draw borders of cells. The standard option under Home => Font is not so handy as it needs a lot of clicking and I often struggle to get the borders exactly as I want them. But, as I said I recently found a option to have a fixed panel to the right of the screen in which I could more easily just change the thickness of the border and then click on the cells. But now I can't find it anymore. Was I hallucinating? I've searched quite a bit. Many thanks to those who can tell me where the option is? Kind regards, MichaelMike_Z_JNJFeb 13, 2025Copper Contributor0Views0likes0CommentsHow to stop excel from updating dates.
Hi there, I have a running order list that we keep track of what is ordered when and when things are received. we are using a check box to initiate when the item was received. my problem is that the when i go to update an item the previous dates update to the current date. How can i prevent the date in column H from updating to keep historical dates? example of the document and the formula i am using. thank you in advanceEvoss87Feb 13, 2025Occasional Reader48Views0likes5CommentsWhat 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 Contributor25Views0likes3CommentsDax to find open status for more than 1 hour
Hi Team, I have the below table: Here I want to find that whether door is being open for more than 1 hour or not. The Status column shows whether door is open or not. CreatedOn column shows time duration. Could you please help me create a dax logic to achieve this? PFA file here B&M.pbix Thanks in advance! SergeiBaklan8Views0likes0Commentsinventory
I have created an inventory spreadsheet and was looking a formula to use for finding a product in the list that is in there more than once with the same description but may have two different prices, which are in a different category. Based on the product name I want to add the last months inventory to the purchased inventory.aeo21Feb 13, 2025Copper Contributor59Views0likes5CommentsFailure to Print Excel document
One of my Excel files won't print. I get a msg saying "file could not be printed due to an error on (my printer name) on e03". Do not have any problems with other Excel or other app files printing. I'm using Office 365. Solution??Jake42JakeFeb 13, 2025Copper Contributor47KViews0likes3Comments#unknown! displayed in excel where an inserted picture should be located
A supplier is sending me an excel template which contains pictures in a cell The picture can be viewed in web based outlook and web based excel but when I download the file the cell states #unknown! I believe the supplier is using a personal 365 account and I am using 365 Apps for enterprise I think they are adding the picture by completing the below (taken from MS site) this is what I see when I open it up on web based outlook But this is what I see when I download an open in excel desktop Any help is greatly appreciatedAButler1910Feb 13, 2025Copper Contributor44KViews1like12CommentsCalculating a running average grade
Hi I am a teacher and want to add to my student record sheet a running average grade. I would like to set it up so that the average updates throughout the year when more test data is added. However this means that there will be missing data, as students will not have completed all the tests until the end of the year. This is my data. The different written tests have different grade boundaries and the grades shown are populated by different vlookups based on the % scored in the test. As they have different boundaries, my idea was to assign each grade with a point score, lookup this point score with a vlookup, then average these point scores before looking up a grade. I have started with this formulae (not quite got to the stage to look up the final grade). Im not sure how to make larger sorry I have tried using If functions to solve the problem of missing data but as soon as there is missing data i get a #VALUE! error Is there anyway to get around this and work out the average with these gaps? ThanksSolvedA-T24Feb 13, 2025Occasional Reader61Views0likes2CommentsBOM 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 Reader94Views1like4Comments
Resources
Tags
- excel42,199 Topics
- Formulas and Functions24,462 Topics
- Macros and VBA6,353 Topics
- office 3655,938 Topics
- Excel on Mac2,618 Topics
- BI & Data Analysis2,333 Topics
- Excel for web1,879 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,609 Topics