combining

How can I combine the tags at the end of my ID #'s if I have duplicate values? Specifically, I have a dynamic list of ID numbers that are regularly put into a spreadsheet and depending on what the patient needs, a tag is put on to the end of the #. For example: Patient 14454 may need test "B"...

I have 3 workbooks in Excel 2010 that are identical. I have created one master file that is in exactly the same format. All of these files have multiple tabs but I need to collate the information in the master workbook from 3 of the tabs in each of the original workbooks. How can I use a...

alright guys and gals i need some help with a formula i want to search a list of people which is set up as such colA last name, colB first name, ColC office num, colD fax num, colE home num, colF cell num ect. this list is located on sheet 2. i would like my users to be able to search this list...

Hello everyone, I am new with excel and have been trying to help my boss with this simple problem all day: I have an excel file with thousands of names in column A. In column B, I have thousands of addresses. Example: A.........|....B..........| Name....Address line 1...

I'm unsure how to get the results I want. I download data from some software and get the below results. Column D uses multiple cells for the data. <TABLE style="WIDTH: 142pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=189 border=0><COLGROUP><COL style="WIDTH: 16pt...

I have to combine the cell contents (values and cell comments) from one cell, to another cell (on the same row) that already contains a value and a comment. I can use paste special to add the values together (I don't need to retain the individual values) but I need to show both sets of comments...

Hi This is my first post on this forum, I couldn't find the answer elsewhere, that's why I decided to post it here: I would like to combine multiple rows with the same id, into one. Eg. -------------------------------------------------------------------------------------------- ID (movie...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

I want to start with an apology as I know this has been asked and answered a hundred times already. I have searched past threads, but still cannot implement the solutions you all have been so gracious in providing. So here is the issue: I have a folder with several workbooks. I need to pull...

Hi there I wish to combine the following COUNTIFS together but am becoming stuck and stuckier.. as I cant seem to get past the first 2 COUNTIFS Essentially (C2:C47,"Y") is the most important Column C 1st must be a Y to continue with COUNTIFS which are meant to be adding the number of times...

Hi all, As always there are several solution to a problem so I am interested to see what others would do in the following situation: Let's assume I have five spreadsheets with the same layout; the contents refers to different countries and I would like to add them all together in a new...

Happy Friday Excel Wizards! There are similar posts on the boards but I haven't found one that quite gets me to where I need to be and I am getting desperate! What I want to do is have a userform that includes checkboxes and upon selection of the checkbox, it will print the quote for the...