single

Hello! How to paste multiline formatted text from Word to a single Excel celll? Is it possible? So far, it pastes every line in new cell, but I want everything in one cell, while preserving the bullet formatting etc. Thanks!

Hi, I'm trying to calculate the median salary based on a set of conditions - job code = 42, school type = single site. Sample data: <style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in...

Using</SPAN></SPAN> Excel 2000</SPAN> Hi,</SPAN> I want to join multiple cells C:P columns, into single column R for that using formula getting the result as below</SPAN></SPAN>...

In my C column I have some data which looks like this : 0(1), 1(0), 0(0), 2(1), 3(0), 0(0), etc. I'm trying to sum up the numbers on the LEFT of the parenthesis. This example would nomally return 5. I tried using this fomula: =sumproduct(--(LEFT(C1:C30),1))) but i get a #VALUE ! error. Right...

Hello,</SPAN></SPAN> Every single row of the Data columns C:P, I want to copy into 4 rows in the columns R:J </SPAN></SPAN> Example for row 6...copy as follow</SPAN></SPAN> C6:F6, copy in to R6:U6</SPAN></SPAN> G6:J6, copy in to R7:U7</SPAN></SPAN> K6:M6, copy in to R8:T8</SPAN></SPAN>...

Hi! I am trying to return the size of a selection, when I specify the type and output required, which may not match the exact output, and therefore needs to find the closest match, for a certain type. <tbody> A B C D E F 1 Type Output Size Type Single 2 Single 200 300 Output 175 3...

Hallo, I've this little problem to solve. I have a list of names in a column. Every name has one of the following values to associate with: 1 or 0.5. - Mr John (value 1) - Mr Morrison (value 0.5) - Mr Morrison (value 0.5) (a single name could be present more times) - Mr X (value 1) - Mr X...

I've used MrExcel's Trick #916 to remove blanks from my listbut now I want the results to be alphabetized without rearranging the primarylist after each time I add data, the data is all single text and no numbers.

Hi, I use a variation of this formula quite a lot.. essentially a sumifs (or countifs) surrounded by a sumproduct to use the range in one of the criteria instead of stacking several lookups together.. =SUMPRODUCT(SUMIFS(RAWDATA!$D:$D,RAWDATA!$A:$A,$A$40:$A$46,RAWDATA!$BR:$BR,B$4)) Where the...

So I've been through multiple tutorials and online examples and I feel like I'm almost there but none of them have examples of using a range instead of a single value. I have a directory full of 24 files and I want to do the automated equivalent of copying and pasting the same data range of...

Hello, I've got a 6 questions in a survey asking in different ways whether someone feels better after using our service. People can answer Strongly agree, Agree, Neutral, Disagree or Strongly disagree to each of the 6 questions. I want to do a calculation to see how many people answered...

Hello members of Mr Excel, My puzzle presents as follows ... I have a table that looks pretty much like the following in a sample version: <tbody> Date 1 MO 2 MO 3 MO 6 MO 1 YR 2 YR 3 YR 5 YR 7 YR 10 YR 20 YR 30 YR ######## 2.41 2.42 2.39 2.54 2.62 2.63 2.61 2.64 2.72 2.79 2.92 3.03...

I would like to be able to take data presented along a single row and have it moved to a single column. The code below is what I have constructed in order to accomplish this task. I am receiving an error "Pastespecial method of range class failed" on the line immediately below. Why is it...

Hi team! Is it possible to combine two formulas like below ones into one single formula? F1: =+IF($C$1="Jan";$B$27;VLOOKUP($C$1;Months!$E$7:$F$18;2;0)*7+$B$27) F2:=+IF($C$1="Jan";$B$55;VLOOKUP($C$1;Months!$E$7:$F$18;2;0)*7+$B$55) Thank you in advance!!

I have words in a cell cell and would like to have the brackets and single quotes removed and put in alpha order. I have this in a single cell: ['red', 'blue', 'green', 'yellow']. I want this in a single cell: blue green red yellow

This works in excel 97 -2003 but does not work in 2013 or 2016. I get a the #Name ? value. Will you review and see what needs to change to work in 2013 or newer? Function BOND(Subtotal, TaxRate) As Single 'Author Jim Hesh 'Set limits and...

Hi all, This is a seemingly simple operations but can't figure it out. Goal: I have some content copied, I want to paste it into a single cell. The default when I control+paste into excel is that is paste it as multiple rows/lines. Even when I right click for more paste options, there isn't any...

Hi All and Festive greetings! I have started to create a database with a number of tables for different types of data that is required and started to build a single table to allow a user to enter the details. Within this form i have used the Tab control so i can split the different areas and...

Can someone help me with combining the following two macros? I cannot seem to figure out what I need to change/update. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Target.Address <> "$B$3" Then Exit Sub Application.EnableEvents =...

Hi All Thank you for your Supporting I have small problem; I copy data between the “Standardization Code: “in single row. The “Standardization Code” part of the sentence