rows and columns

I have a table that I extracted from ArcGIS (see an extract of the table below). It features 12 designated sites and within each of the sites there are occurences of up to 63 different feature types. Current extracted table: Name Feature...

Good morning. My problem is.... I receive multiple spreadsheets, some of the data is duplicated and I need it combined into one spreadsheet. I have tried filtering and removing duplicates but neither work. The data is as follows: Column C Column D Column E to N #...

I am needing help in exporting a table to a text file in a specific format. The table is in the following order: <tbody> S 45 2 58 E 297.74 N 59 7 11 E 102.1 </tbody> I am looking for an output in a text file of the following format: The range can also be variable, i.e. the column count by...

Hi everyone, I have been searching for a formula that would do the following, extract unique values from a frequency chart..Please excuse me I am new to this form and limited knowledge of excel. (I am not a spreadsheet master..lol) example of the chart: <tbody> a b c d e 1 gas 205 2...

I've recorded a macro to create columns in the table I want to use, now I want to input things in each row. I found this piece of code that will ask for number of rows of input and display that many blank rows: <code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline...

I'm a teacher and I have a vocabulary database of common English words--and the many derivatives of those words--that I want to teach my ESL students. I've manipulated the database to the point that it looks like this: <tbody> Singular Noun Plural Noun Base Verb Form First Person...

Greetings everyone, I'm trying to write a macro that will read data from one spreadsheet and graph it in another when the number of rows is variable. The data consists of 8 tables. Each table will have a maximum of 24 rows. The number of columns are different for each table, but they...

Greetings everyone, I'm trying to write a macro that will read data from one spreadsheet and graph it in another when the number of rows is variable. The data consists of 8 tables. Each table will have a maximum of 24 rows. The number of columns are different for each table, but they...

Hello! I've been stuck on this one task for a while now and I was hoping to get some help. I currently have a spreadsheet of data ranging from A1:AF60, some of which are in BOLD text. I need to loop through each cell in the entire spreadsheet and select the entire row if that row contains a...

I have two columns: <TBODY> red</SPAN> red</SPAN> yellow</SPAN> blue</SPAN> teal</SPAN> yellow</SPAN> black </SPAN> black </SPAN> green</SPAN> green</SPAN> pink</SPAN> pink</SPAN> orange</SPAN> grey </SPAN> grey </SPAN> white</SPAN> brown</SPAN> brown</SPAN>...

I want to be able to search different columns that have texts and numbers which display only those rows that contain those categories. The columns are labeled by "#/Area/Name/Sector/Type/Value($)/Date" I was hoping someone could help me understand how to input a proper code that would make this...

Hi guys, I have data sorted into 2000 rows and 10 columns. Now I have to copy and paste row 5 cells in row 7 to row 8, row 10 to 11, row 13 to 14 and so on in an interval of three for the rest of the 2000 rows. Can anyone help me with a macro that can do this? Thanks you very much.

Well I have the following problem: The first Row of A is like this: <table border="0" cellpadding="0" cellspacing="0" width="271" height="68"><col width="132"><tr><td valign="top"> </td></tr><tr height="40"> <td class="xl63" style="height: 30pt; width: 99pt;" width="132" height="40">...

I am trying to prepare a spread sheet. My font is Arial (10) pt. I have the grid prepared and have adjusted the row height to (30). I would like to be able to type more than one line into the cells, but when I try it jumps to the next cell below. Is there any way to do this? Thanks for your...

I have a very large file with two columns with about 40,000 rows, is there an excel formula to match the same numbers in column A to the same numbers in column B and all the other non matching numbers to be pushed to the bottom of the columns?? please help me

What you are looking at is a excel file i created from the import new data wizard. Now my report has a header which you can see at the top is all cut up because of my columns. Less importantly within the report you can also see "r This Colo r" and "r This Styl e" it is suppose to say Total For...

What you are looking at is a excel file i created from the import new data wizard. Now my report has a header which you can see at the top is all cut up because of my columns. Less importantly within the report you can also see "r This Colo r" and "r This Styl e" it is suppose to say Total For...

I have about 3000 rows of data in column A. At every 50 cells, i need to get one cell and copy it onto its own row - so cell A1, A51, A101 etc need to be copied to cell C1, D1, E1. I want to loop it because of the amount of data but have no idea at all how to do this

Was wondering if there was any way to have a worksheet smaller than 256x65536 cells in Excel 2000 - ? Impetus for this is using a background image, which causes the file size to balloon when it tiles infinitely across & down the sheet. Hiding cells has no effect and there seems to be no way to...

The code below attempts to parse the worksheet COPY_APR_All_States based upon the state (column "F") by making a new worksheet (named by State, the "holdState" variable) for every state found in column "F" of COPY_APR_All_States, and then adding the respective rows to the new worksheet. I have...