home

My string is from my smarthouse: 7.3.2018 10:25:40 +? 71 EnergiUte Strøm sender <MÅLEVERDI> til Smart Home Controller (DP:85) 8,430 (Netzversorgt) 74 % 7.3.2018 10:25:40 +0.0947 Smart Home Controller sender <BEKREFTELSE> til 71 EnergiUte (Netzversorgt) 58 % 7.3.2018 10:25:52 +12...

I have a spreadsheet that I put together to print checks. In one cell I have the following: =CONCATENATE("c", TEXT(N1, "000000"),"c a", N9, "a ", N8, "c ") and that cell is formatted with the font: MICR encoding. When I print this check from my computer at home I do not get MICR encoding. What...

I'm currently trying to use the Index Match function to look up values in two columns and then move the associated value in another column to another sheet, but can't currently make it work. Sheet 1, that I'm taking the values from is displayed below - <tbody> Home Team Away Team Match Points...

Hi, I have a document with many tabs. I would like to navigate from and to Home tab by just using buttons - no hiperlinks and no code. Could someone help please?

I write code at home and work. Home computer needs Microsoft Word 15.0 Object Library. When I program at work the reference changes to Microsoft Word 16.0 Object Library. Then the program hangs when back at home. After searching I learned that I should use Late binding. The problem is that in...

Earlier this month I was trying to figure out how to add a print button to a worksheet to print selected cells as a PDF document - https://www.mrexcel.com/forum/excel-questions/1037201-add-print-button-worksheet-print-selected-cells-pdf-document.html - which as you can see from that thread, I...

A21:A30 are locations C32:C2000 has names of locations G32:G2000 has a dollar amount H32:H2000 has a dollar amount I need B21 to only count locations in C32:C2000 that correspond to A21 and have a value in either G21 or H21. Example C32 is "Home". The formula sees that A21 is "Home", but also...

I select a print area and Print Preview shows everything fine with lots of free space. I want to add a border round the table, so I add a column to the left in Select Print Area. Print preview insists on making this a separate page, so I can't get a neat box. Does anyone have an idea why...

Dear all, I use Ctrl+Home button very frequently in excel. I have purchased new keyboard where Home and End buttons are not available. Please guide is there any alternative keyboard shortcut to get the same functionality of Ctrl+home/End button? Appreciate a lot. Thanks

Hello, Hope you are well. I am trying to navigate between sheets using named ranges I set up. E.g. I have a Sheet1 named Polar and Sheet2 named Inventory. When I click on a home button on the Inventory sheet it should navigate to the Polar sheet using the named range "home" that is set up for...

Hi guys i have this formula - =MAX(FREQUENCY(IF(ISNUMBER(MATCH($I$5:$I$200,{"won"},0)),ROW($I$5:$I$200)),IF($I$5:$I$200,"lost","drew"),0),ROW($I$5:$I$200),IF($H$5:$H$200="Home",ROW($I$5:$I$200))))) when i enter it it says that ive entered too many arguments -- im trying to find how many games...

I am trying to copy and paste data from the internet and it works fine at my work computer but when I do it at home it puts everything in column A rather than spread it out across the columns. Any suggestions as to why this may occur? I am most likely using different versions of excel at home...

I have sports statistical data and both the home and away team are listed on the same line. I am trying to create a way to do a pivot table that would allow me to look at a teams statistics whether they played at home or not. The way the sheet is structured, I can do a heck of a pivot table...

Hi All, I have done many researches but cant seem to find the right 1 to get it to work I want to display a gif file in a certain location in my worksheet without having any scroll bars I have tried to draw the web tool on my machine at both home and work but i get an error saying that i...

I was hoping to get assistance with a formula that will look at a numeric value in one cell, and then apply a formula that will take that number and apply itself to another cell with custom text and make increments of +1 on an entirely different number (starting at 1). For example: <tbody> 5...

Hello All, I am a little perplexed here. I have Excel 2016 at home and at work. Not sure why I can Use the Split Column command at home to split a cell with multiple delimited values at home into multiple rows but not at work. Can anyone help me out. I have turned on all Add-Ins that I can...

Hello, I have received a spreadsheet with survey results and many of the questions have multiple answers in multiple columns. For example: <tbody> Respondent Where do you keep the product? a@gmail.com Home Car b@gmail.com Work c@gmail.com Home Car d@gmail.com Rental...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

Hello. I am a first time poster here. I am used to using lookups, but stuck with moving to a situation where I have multiple matches and want to apply a criteria to return a single value I am interested in. The data below show some inspection data for care home quality, which include some...

Hi, I have a list of times for technicians over the course of the month showing the time they arrived home, I am trying the identify what the average arrival time for each person is for the month. However whenever I use AVERAGE() I get some rather strange results? Can anyone help? I have pasted...