sort and seperate data

Hi I have approx 500 companies which could have a balance with each other. So in total are approx 250K combinations. I am trying to group them to see whether the balances between them are correct or not. For example AB-CD should be grouped with CD-AB. I have tried to find MATCH and INDEX...

Can you sort a spreadsheet last rows by full color?

I know it may be a novice request and an even easier solution but I wanted to know what the VBA code would be to remove the duplicate in one column and its correlating data in other columns and only keep unique items. To explain: I have a spreadsheet with 7 (A-G) columns with numbers in Column...

Hi Team, I have a list of full names in a row that I need sorted by last name. I know I can separate the first and last names by using Text To Columns and the space as a separator, but I was wondering if there was a clever formula to spit only the last name out into a helper column...

Hello, So I have 80 or so large data sets that I have smoothed and then found the slope between each point. I then calculate the average change of the slope along the curve. I would like to search for a row in the two columns where the average slope percent change is less than 1% in one column...

HI, I have received very two lists of contact information that have been combined into one sheet as seen below. I have broken this down into a smaller sample size because each list contaions over 5,000 rows and 20 columns wide. My question is.... Is there a way to sort the list below by...

I am trying to do the same few things to all sheets in a worksheet. However, so far it seems to work only on 1 sheet. For example, for the first step, it cuts the first row and then pastes it one column to the right as it should, but instead of going on to the next worksheet it cuts again the...

I'm working on a timesheet, trying to get it to add the various types of leave based on what kind of leave is taken. For the most part, I have this working using the following formula: {=SUM(IF(ISNUMBER(FIND(R$1,C2:P2)),VALUE(LEFT(C2:P2,FIND(R$1,C2:P2)-1)),0))} It is only when there is more...

Hi! I would like to sort the list of variables into each of their own rows somehow, but I don't even know where to start! Any help at all would be awesome! Thank you! <colgroup><col><col><col></colgroup><tbody> WEL02B 5 Mont Street CALORA NORTH NSW 2211 DOB: 13/01/2011 ABN...

Hello, I have a spreadsheet that has more than 4,000 individual records I would like to remove from one column any record containing a number higher than 90. Any help is appreciated

Hello Everyone, I have data in two sheets that need to be sorted. I need to create a list of records that are on the first list but NOT on the 2nd list. I was wondering how I could sort these records out using the name columns (2) and filter into a new sheet. Thank you!

I have a subscriber list where in column A the customer is labeled as 'inactive' or '7day' or 'Sunday' and then in column B:D are address and detail info. What I need is a way to hide all rows that have 'inactive' as the label in Column A. Additionally, If I have A4&A5 as a merged cell saying...

Hello GANG! I have 3 modules I am trying to merge into 1...they are: Sub WriteOffs() ' ' WriteOffs Macro ' maniplute Imported Oracle Data for write-offs ' ' Columns("J:L").Select Selection.Delete Shift:=xlToLeft...

In my workbook, 2 columns & 6 rows are filled as: 1. Each of the 2 columns will have minimum 5 rows filled with +ve integers. 2. 1 out of 6 rows in each column may contain a word “BUY”. 3. If criteria #2 is not met with, then that row will also contain a +ve integer. In 1...

Greetings, I am trying to filter an Excel 2003 spreadsheet. There are two unique scenarios that I need to handle. First scenario, list contains funds with multiple classes, one of which is called "total," filter the list to return only the fund containing the word "total" Ex. Div Growth -...

Hello, I have to make a spreadsheet to track credit solicitation. In column B I have a list of my employees (currently entered alphabetically manually). the next columns (D-O) i enter the number of credits opened for each employee, each month. This is totaled into column Q for a year...

Hi folks... I need to breakout data from a source worksheet to 2 other worksheets. The source worksheet (Sheet 1) looks like the following: <TABLE style="WIDTH: 613pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=816 border=0><COLGROUP><COL style="WIDTH: 53pt...

Hi everyone, I have a very repetitive problem here that i've been having for quite some time now. I need to input quantity of items into the existing database that holds all the items names which is sorted by category. Below is a sample of the problem: Table 1 - Items with quantity that is...

I have one column with repeating name, address, city/state/zip, and phone number for locations, each in it's own row. For example, A1 is name 1, A2 is address 1, A3 is City/state/zip 1, and A4 is phone 1. Then A5 is name 2, A6 is address 2, etc. This repeats down column 1 for several hundred...

I have a worksheet with lots of data upon it. I want to search that data for specific items in specific locations and values next to that item. Data Worksheet <TABLE style="WIDTH: 304pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=406 border=0 x:str><COLGROUP><COL...