rows and columns

  1. D

    Range.Rows property with autofilter applied

    Hi MrExcel, I need your help. I have an autofilter applied to a range resulting in non-continuous set of rows visible (see snapshot). Assume I want to access the number of the first visible non-header row (which is number 7 in this case). When I run Dim rng As Range Set rng =...
  2. Q

    Index and Match across different sheets

    Hello, I have a 2 D data (rows and columns) on Sheet 1 and I have specific values in Sheet 2. I want my index match formula to return select from the range in Sheet 1 and the rows and columns in Sheet 2 to return the value specific to that combination. =INDEX('Zone & Pricing...
  3. T

    Logical operators work in columns

    I found this script and i now wonder how to make it work in more than one row. i tried to add Range("A1:A10"). but it gives me a run time-error 13 . Hope you can help. Sub test() Dim score1 As Integer, score2 As Integer, result As String score1 = Range("A1").Value score2 = Range("B1").Value...
  4. C

    Update cell of filtered column header selection

    Good day all, I would very much like to have a certain cell reference(A4) be updated with the team leader I select on the header filters. Reason being, I have to print out the whole team for every team leader, and have the leader's name on top of the list. I have a database with staff members...
  5. A

    Need to add duplicates in a format

    I have 2 sheets that i need to merge into one but the format is not as simple so it cannot be just copy pasted. But i feel there will be a way to do that with a vba. Hoping to get a solution from here. here is what I am looking to do. First column is "Source URL" and Second column is "URL"...
  6. T

    How to transpose multiple rows of an array into a single column & preserve order of values

    Hi all, I hope someone can help, I'm at my wits end! have a large data set that represents births by age of the mother for each county. Mother's age is represented on my x axis, the county code on my y axis, and the birth counts for each age are reflected in a single row for each county. I am...
  7. G

    delete the row that has the earliest time

    hi I'm new to vba and I'm trying to write a code that will delete duplicate rows if say values in column C match up. But I want to delete the row that has the earliest time stamp heres an example. <tbody> Number time stamp round device 5 16/6/22:39:44 5 15 4 16/6/22:39:44 2 16 8...
  8. ProgramUser

    Taking occurrences of unique numbers (two tables) and placing results list across rows with corresponding occurrence values [Compare Two Tables, look

    Dear Excellers, This is part of a larger project involving trigonometric ratios. The Situation; I have two tables, one table (A22:E22) with unique numbers derived from trigonometric functions, I then check this table’ values for duplicates using a vba code snippet I wrote (see below) into a...
  9. D

    Rows to Columns with Every Other Row Formula

    Hello, I'm working with a Word Document that includes course number, course title and course description. I saved the document as a .txt file and used Excel to open the .txt file. The current Excel format is one column; one row contains course number and title and the row directly below...
  10. ask2tsp

    named range used as argument in ROWS or COLUMNS function results in #VALUE! error

    named range namedRng ="$A$1:"&ADDRESS(COUNTA($A:$A);COUNTA(!$1:$1);1) that in my case evaluates to $A$1:$H$74 when a cel contains the formula =ROWS(namedRng) it shows #VALUE! i tried evaluate formula where the formula evaluates to ROWS($A$1:$H$74) when a cel contains the formula...
  11. D

    Excel 2013 - Missing # of Rows & Columns for Selected Range

    My office upgraded from Office 2010 to 2013. In 2010 and earlier versions, Excel would show the number of rows and columns I had selected at the bottom right of the selection before I'd take my hand off the Shift key or left mouse button. Now, it only seems to show this in the Name box until...
  12. W

    Change format of an existing table, transpose to 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...
  13. C

    Macro to combine row data and delete extra row

    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 #...
  14. L

    VBA- Export Excel table Rows to a text file in a specific format

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

    The Hardest Challenge Ever!...Need help with a formula that extract and sorts unique values from a data set.

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

    How to edit of rows in Excel-VBA - Test Data Generation

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

    Partial matching text in a vocabulary database

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

    Macro to fill tables that have changing number of rows

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

    Macro to fill tables that have changing number of rows

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

    Loop through entire sheet in VBA

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

Some videos you may like

This Week's Hot Topics

Top