large column data

  1. R

    First Post: Listing variables in a Column

    Hey All, new to MrExcel so please be kind, I fear my question may be viewed as simple by some. I have a datasheet with 6000+ entries. One column has lists of companies, of which there are around 300 and their are entered into this column multiple times. I organized and identified the largest...
  2. A

    working with Large Non Contiguous Data

    Hello Everyone, Im pretty desperate. I've got a column with around 9000 rows of data and I need to average non-contiguous rows. So I need to average row 1,4,7,10 (every 3rd row or so), and I have no idea how to do it. I just found out that we can use VBA to do this, but I havent figured out a...
  3. C

    Opening data sets in excel that are too large for excel

    Hey Guys!!:) I've got a dataset that is too large for excel, (a few million rows when the limit is 1048576) To overcome this I've been copy and pasting within this limit which is time consuming, is there any way to automatically paste excess data into the next column? Thanks in advance!!!
  4. T

    Finding Text

    So I have a log at work for orders from people in the office that is the format: "Person Who Placed Order"-"Person Ordered For" The account number in the next cell is represented only for the "Person Ordered For" and should correspond to their name. Since there are a large number of orders, it...
  5. PirateJenny

    Large volume text

    I am a research assistant extracting data from Word documents and copying it to an Excel sheet. Some of the data is lengthy and (for the purposes of the research) cannot be broken into multiple cells. At a certain row height (242.25) or character volume the text will no longer wrap. I have...
  6. H

    Hide columns randomly using macro !!

    Hi, I am stuck up in following condition using macro... I have large data in worksheet having 200 Columns and 60 rows in "sheet1". Concept is - User inputs some number where that number's column only be visible and rest 199 columns and their data will be invisible. ( Eg - number entered 2...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top