Search results for query: *

Hi, I have a list of codes in one cell separated by comma's. I have to compare another cell to see if that value exists. I've tried using the Vlookup formula but it doesn't work. I need to compare BPL to PROC to make sure the BPL codes are in the PROC column. PROC BPL AAC, AK...

Hi, I received an excel report with codes and descriptions. The codes and descriptions are in multiple rows. I need to combine all the data descriptions for each code into 1 cell for the corresponding code. The number of rows per code is variable. There are no duplicate codes. I tried to use a...

Hi, I am trying to pull a query to get the right 3 characters in a field. I need to right trim the field first. What I wrote is not working. It returns blanks. I would appreciate any help with this. I've tried several variations of rtrim and right string to no avail. I eventually want to update...

Hi, I am having a problem trying to figure out how to write a query to get the results I need. I need to see both the IPCD and IPCD2 codes as there can be several different IPCD2 codes associated with one IPCD. There are also several generations which is where I having a problem. I don't want to...

Hi Everyone, I just had SSMS Tools installed on my laptop. Now when I open an existing query modify it for a different client and then save as to a different location it is saving the changes over the original query as well. Has anyone else had this issue or know how to fix it? Thanks Deana

Hi, I found the code at the bottom on this site and I have been trying to modify and have been unsuccessful. I have thousands of rows of data and I need to break the data out by adding a blank row based on values in column 2. Any help would be greatly appreciated. When the cell value changes in...

Hi, I have a spreadsheet with values in column A. Not all cells have data. The previous data needs to copied down. I inserted a column and created a formula to get the values copied down as there are over 42,000 rows with intermittent missing data. I wrote a formula =IF(ISBLANK(A2),B2,A2) to...

Hi, I have data in one cell that is comprised of 3 different codes. I need to add a space between these codes that have 2 constant characters and one variable. Example: Code in cell - 123456ABCDH32568HA I want - 123456 ABCD H32568HA Code in cell - ABCDIHBG1234THLKDRWS I want - ABCDIHBG 1234...

Hi, Is there a way to remove a list of items that are in multiple cells? I have a sample of the list below (there are a total of 687 codes). I am looking to find each one of those codes anywhere on the sheet and remove them without having to do each one manually...

Hi, I have to compare ranges on two worksheets in the same workbook and having difficulty. I need to compare TMG 2015 columns a through H to Doug 2015 columns A through H. I tried using the Match function but have never used it before. It's not working the way I need it to...

Hi, I am having a problem with a SUMIFS formula and #DIV/0!. This works fine but it returns #DIV/0! in some cells which I don't want to display. =SUMIFS('CO Detail'!$D:$D,'CO Detail'!$C:$C, "=20: Assigned - For Estimate",'CO Detail'!$A:$A, B33)/D15 I tried to get the #DIV/0! cells to display...

Hi Everyone, I am having a problem combining IF statements with VLOOKUP. The statements all work perfect independently but I need to combine them. I tried just putting a comma between each statement to combine them but I just get #VALUE returned. These are looking up rates for member premiums...

Hi, I am having trouble with a Not Exists query. I am trying to find all the CNS and NP rows in the same table that do not have corresponding PA rows. I mocked up data to test the query but the expectd results are not showing. It's not pulling anything. Any help would be greatly appreciated...

Hi, I have a table that I need to update blank description fields with an existing description. The existing description is based on a 5 character code. (example 12345 is the code) I need to update any other codes with the same initial 5 characters with that description. So 12345AB, 12345CD...

Hi Everyone, I am going to apologize in advance if this posts twice. The first time I posted it didn't show up. My knowledge of SQL is beginner level. My job only requires simple insert and update queries. I have now been tasked with working change requests that require updates to all 18...

Hi, I have an excel spreadsheet that I need to break out the data. I have 18 columns of information. The row count is variable. I need to break out the data as follows. Is there a better way to get this data broken out? The way I did it with the formula may be a convoluted way of doing this so...

Hi All, I have a workbook with 2 different worksheets. CUSID's and CompanyTableHierarchy. I am trying to populate column BG on company table hierarchy with column A from sheet CUSID's. This is based on first 3 character matching subgroup values from both sheets. There are 59 rows on the...

Hi All, I have a 2007 excel spreadsheet that has several tabs with information. The last tab is a summary. I am able to pull information from all the tabs to the summary with no problem, except the class tab. I have a formula to pull info from the class tab --- (='Tab 4 - Class ID'!D7&"-"&'Tab...

Hi, I also posted this in the VB Script forum, but it was suggested it was better suited for this one. I have been searching for quite a while trying to figure this out. I have a simple comma delimited formatting macro I recorded in excel to format an exported file from a program called...

Hi, I have been searching for quite a while trying to figure this out. I have a simple comma delimited formatting macro I recorded in excel to format an exported file from a program called Redgate. This file is exported in .csv format. After using the macro I noticed the data in certain columns...