Pinned Posts
Forum Widgets
Latest Discussions
Weird Printing in Excel
Hello knowledgable peeps! I have an excel spreadsheet - been using for years - its 6 sheets printed double sided from within a larger sheet so I know how to do all the page margin stuff, scaling etc - however looking at this document in page break preview, it shows the 6 highlighted pages with breaks correctly and says which each page number will be they are but page two is printing the first few rows on page two then the rest of the sheet on page three. Print preview says its only printing 6 pages yet it keeps printing seven. I have checked that errors are NOT set to print as blank but cant see any reason why the results are contradicting what the preview says will happen. Many TIA :)
SUMPRODUCT ERROR
I am trying to count the number of entries that meet a given criterion across 141 worksheets. I first use =@INDEX(SheetNames,G3) to retrieve each sheet name where SheetNames is the range of sheet names and G3 is the cell reference for the sheet number. I then use =SUMPRODUCT(COUNTIF(INDIRECT("'"&$H$5:$H$145&"'!d34:d35"),A2)) where $H$5:$H$145 is the range of worksheet names created by the command above. cells d34 and d35 contain the information used to select the information to count, if it meets the criterion in column a. I followed the instructions for an earlier version of Excel and this combination worked. Now the SUMPRODUCT equation returns #REF. What has happened and how do I fix it. Or where do I find the instructions for making it work now. (BTW, this is the worksheet that counts the number of inurnments for a given year across 141 worksheets that have information about partners that have reserved a columbarium niche. The year of interest is given in Column A (such as A2) with the formula in B2.) Thanks for any help.How to convert dates in excel to common format.
Good day. Please support - I have 2 dates generated from SAP and which come in different formats (columns E & G). I have already tried all possibilities to change it via built-in excel settings, but no positive result. Please advise if there are any options to adjust dates format to common. Note* date in column G to be read as January 2, not Feb. 1.
Consolidate/Merge Data in Multiple Files
I have two spreadsheets - both are lists of items with a tag number, serial number, item description, and comments (among other categories). On one of the spreadsheets, the comments column is completed but it is empty in the other spreadsheet. How can I add the comments from the spreadsheet that has them to the one that doesn't, based on what the tag number of each item is? Both spreadsheets are in a different order and some of the inventory items we have on one list do not match the other list, either because they are new inventory items or they were removed from inventory.File Attachments
🚫 Reminder: Do Not Share Real Customer Data or PII in the Community As a friendly reminder to all members of the Excel Community: Please do not post any content that contains personally identifiable information (PII) or real customer data. This includes names, email addresses, phone numbers, account numbers, or any other data that could be used to identify an individual. 🔒 Protecting privacy is a shared responsibility. If we suspect that any content contains real customer data, community administrators may remove it without warning to protect privacy and ensure compliance with our policies. Per our Terms of Use : You should only upload content that you have permission to share. If you're sharing examples or screenshots, please use dummy or anonymized data. Clearly indicate in your post that the data is fictitious or anonymized. Let’s work together to keep the Microsoft Tech Community a safe, respectful, and productive space for everyone. If you find a post with content likely to be personal in it then please report the post using the cog in the top right corner. Thank you for your cooperation! Microsoft Tech Community Admin Team
Help With Excel Line Graph "Switches"
I apologize if this query has already been raised before. I have been tasked with creating a graph that compares data across multiple years. With how cluttered the graph is becoming, I was curious if it was possible to show/hide certain data ranges through formulas. I am aware I can do so through the graph settings, selecting which data series to hide and such, however it is likely I will be switching comparison between different years on the fly, and was wondering if I could set a simple command that will allow to show/hide each year's data ranges as necessary? Or will I just need to suck it up and interfere with the graph settings every time?
Concat and Concatenate problem
I have 203 column of data that I need to merge each row of that data into one column - tyring to merge street names for a list of addresses. I ahve done this before but the function does not seem to be working. Can someone help? What I tried: =Concat(c2,d2:c39,d39) then =concat(c2," ",d2) this was just to join first row of info then tried the same function with concatenate.
