ignore

IGNORE - there was a formatting issue with the incoming data. Nothing to see here except an embarrassed person who should have checked more before asking :(

Hi all, I am trying to do an addition of three columns together of various times to get a total time. However many rows have a NULL in them when a time was not taken. I want to ignore this text to avoid getting the #VALUE ! sign which I am currently getting. Can anybody please help me with...

Hi, When creating a power pivot from two different excel files, all comma's and dots are ignored after importing or refreshing. For example: In my excel file "Productivity", I have a column with percentages (also percentage format), and a column with time units (for example 0.3 of an hour)...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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