sort and seperate data

  1. I

    Intercompany reconciliation

    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...
  2. F

    Sorting rows by full color

    Can you sort a spreadsheet last rows by full color?
  3. J

    Excel Duplicate Code

    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...
  4. D

    Sorting Full Name Cells By Last Name

    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...
  5. J

    Using value criteria in two columns to find row in which two columns most closely match the criteria

    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...
  6. A

    Two Lists of Contacts within one sheet. Need help sorting to find duplicates/format

    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...
  7. S

    processing all worksheets in a workbook.

    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...
  8. K

    sum cells based on content

    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...
  9. C

    Sorting a messy database output by address suburb

    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...
  10. C

    how to delete certain cells from a column in a large spreadsheet

    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
  11. A

    Advance Sort & Filter

    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!
  12. andrewb90

    Sorting by cell contents

    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...
  13. J

    Merging 3 odules into 1

    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...
  14. H

    Remove words in 2 column & arrange numbers in descending

    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...
  15. T

    Advanced Filter - Multi Scenario

    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 -...
  16. A

    A little more organization needed

    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...
  17. R

    Copy from source sheet to multiple sheets

    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...
  18. R

    Placing into the correct name and category

    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...
  19. S

    Moving data to new columns

    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...
  20. S

    How to search a lot of data for a specific value

    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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top