ignore

  1. A

    VBA to export to CSV, ignoring cells with value of "null"

    Hi everyone, I'm working on a final piece to my puzzle, for now, and that is to certain data from cells in one worksheet to format another worksheet for a CSV file that will be used for creating DHCP reservations. What I'd like is to export only data from my worksheet called, "DHCP", that...
  2. K

    Please help with ignoring spaces in this listing issue.

    I am using a few animals here just to understand how to do this, as I'm dealing with hundreds of cells worth of real data. I have tried using the istext function combined with nested if statements but no luck. I essentially want to do the following: Cat 0 0 Dog 0 Moose I would like...
  3. A

    Ignore a number of sheets before checking rest

    I have a macro button on sheet 1 to check sheets for a certain piece of data which is great but I need to ignore sheets 1 2 and 3 Dim ws As Worksheet If ws.Name <> "My sheet 1" Or "My sheet 2" Or "My sheet 3" Then Cant seem to figure it out
  4. M

    Flagging increases in values when a certain criteria is met

    Hi all, I use this site often but I'm usually able to find a solution to my problem through your threads, but not this time so it's my first post. Essentially I have huge amounts of lab data and have been automatically generating a testing schedule from it using a small macro but most...
  5. D

    Count with Blanks

    I have a list of of numbers shown as percentages in A1:A25 within the list there are some blank cells. I need to count the amount of numbers that are >= 7.50% but the blank cells seem to be counted as zeros and are causing problems. Anyone help me out with the countif statement that will...
  6. I

    Ignore Duplicate Entries on (dynamic) Data Validation List

    First of all I would like to thank you in advance for taking the time to read my question, I have looked everywhere for a solution with no avail, without further ado, here is the problem: Suppose we have three columns as below: (I am using Excel 2010) ID Sys Code 1 Roma A4 2 Roma...
  7. D

    Ignoring a vlookup if no data

    Hi All, I am trying to write a formula to create the sum of multiple VLOOKUPs. This is pretty simple with the basic knowledge i have however, i have a problem whereby the data points change on a daily basis so i need the vlookup to ignore any values that are not found and then countinue to...
  8. E

    ignoring blank cells in an array forumla

    I have this formula in a cell: =IF(ISERROR(INDEX($R$1:$AF$5000,SMALL(IF($R$1:$AF$5000=$Q$1,ROW($R$1:$AF$5000)),ROW(5:5)),5)),"",INDEX($R$1:$AF$5000,SMALL(IF($R$1:$AF$5000=$Q$1,ROW($R$1:$AF$5000)),ROW(5:5)),5)) If the cell it's pulling the information from is blank it puts a 0 in the cell. I...
  9. Grizlore

    formula help for finding first of duplicate entries

    Hi All, Can you help? I have a huge list in column A which contains serial numbers. I need to count how many serial number there are, so i need to ignore any duplicates in the list. I am trying to create a formula which puts a "1" in column B when the first serial number appears, and a "0"...
  10. Grizlore

    Count and ignore when duplicated (preferably in a pivot)

    Hi Can you help please? I have a large set of data and I would like to be able to count the Incident Numbers in column A, however these Incident Numbers are duplicated down column. Example of data in column A 20990 21011 21011 21025 21025 21025 21025 21025 21025 Example of the required...
  11. S

    Ignore messages by a program due to cnx to excel via macro

    Hi guys I am writing excel macro to create a table for young's modulus of materials. Just briefly describing what is meant to be done, connecting a table with 175000 row (rows contains materials e.x. metals ... etc) with different ID's some times similar, temperatures and norms. What I am up to...
  12. R

    Time Calculation Problems: AVERAGEIFS for data inclusive between certain times, which may cross over midnight, duration may result in a negative numbe

    Good afternoon, I am trying to get the average time it takes for employees to be ready/available for their shift, with a separate column showing the duration (minutes and seconds) since some people understand that better. However, anything over 20 minutes before or after the shift begin time...
  13. J

    Pivot on a pivot

    Hi, I've been creating a skills matrix with row titles of skills and column titles of job roles. Then the data in the table allocates required skills levels of those skills against roles. This gives me a nice matrix of all the roles, and all the skills. For example: Skills matrix...
  14. A

    Using the AVERAGE() function w/ Referenced Letters

    I'm creating a spreadsheet that will allow me to track evaluations completed on multiple individuals, ultimately allowing me to see where all individuals are ranked against each other. In these evaluations an individual is graded in several categories with a letter from A to G. These letters...
  15. L

    Possible to maintain userform on workbook close?

    Hi, So I have a Userform which updates progress as to where in the process the workbook is currently at. It works great, the only issue I have is that near the end of the routine, I have to free up memory because this is very data intensive. So in the code, I have a "resumecode" that I...
  16. Y

    Ignore Hidden Rows with TTest

    Hi, I'd like to have Ttest ignore hidden rows. Normally: =TTest(A1:A10,A11:A20,2,3) would compare group 1 (A1 to A10) with group 2 (A11 to A20) but how to ignore hidden rows? I know the function SUBTOTAL can ignore hidden cells but the function used in subtotal does not have TTest. Please...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top