conditions to a criteria

  1. M

    Random select from column A with no duplicates in column B

    Hello. My task is to select 5 REPORT IDs (Column A) without having any duplicates by the Creator Name (Column B). REPORT IDCreator...
  2. A

    if condition is met then copy the row data into a worksheet for multiple sheets/conditions

    Hi, whats the easiest way to get the data (which is pulled in from 2 other workbooks) into regional tabs ? SO from the table below if the region column = 'Auckland' then move the entire row to the Auckland tab and so forth for all the other regional tabs. once the data is in the regions i...
    • Alberino
    • Thread
    • auckland bulka conditions to a criteria data taranaki
    • Replies: 2
    • Forum: Excel Questions
  3. N

    SumProduct Different Sum Range Based on Criteria

    Hi, Im working in Excel 2016. I am looking to find out if it is possible to designate different sum ranges for one specific criteria in a sumproduct formula while the rest of the conditions apply to both. Example: <tbody> A B C D E 1 Color Month ForSale AM1 Am2 2 Black 1 Y 50 100...
    • neb255
    • Thread
    • black blue conditions to a criteria sum sumproduct
    • Replies: 4
    • Forum: Excel Questions
  4. K

    Need Fertilization for summery sheet

    Dear Experts, I have a datasheet and i want result in second sheet based on week numbers. Main columns are as i mentioned below, Customers Styles Qty Rate Values shipment dates week numbers (Weeknum) status (In-process, ready to ship, shipped) in second sheet using same columns and i want...
    • Kamran01
    • Thread
    • conditions conditions to a criteria drop-down list filter lookup
    • Replies: 0
    • Forum: Excel Questions
  5. Z

    Multiple condition formating

    Alright guys, I feel a bit embarrased to ask help for conditional formating, but I have tried and tried to make this work out myself but I cant accomplish anything. I am just stuck. I need to do some multiple condition formating here. I have categories which take part of a material inventory...
    • Zenru
    • Thread
    • categories conditions conditions to a criteria exce 2013 material
    • Replies: 1
    • Forum: Excel Questions
  6. C

    Transpose sequence of values based on conditions

    Hello folks, I am currently struggling to set up a macro to transpose arrays of records based on conditions. I am quite new to VBA, so any tips and advice on how best to achieve this will be very much appreciated. Below is the format of my 'raw' data in Excel (Version 16.0.6741.2056) Column...
  7. M

    Advanced Sumproduct and combinations with IFs for every options

    The below is not so simple as you may think of. Here is example of table. Initial has 80K of records and many columns. -- removed inline image --- I would like to sumporduct to count items from table but is not standard easy sumproduct I want. Basically I want to sumproduct to count 4...
  8. M

    Counting unique values with multiple conditions and criteria

    Hi...I need help on how to accomplish this problem. The array formula SUM(IF(FREQUENCY(IF(D14:D26 >= 90,MATCH(C14:C26,C14:C26,0)),ROW(C14:C26)-ROW(C15)+1),1)) only works for 1 condition but for multiple conditions like if the Training Index is <=89.99 and >=80, it doesn't work. In my second...
    • MagsinoAS
    • Thread
    • array conditions to a criteria count unique values in a range
    • Replies: 2
    • Forum: Excel Questions
  9. M

    A formula with a lot of conditions..

    Hi, I need a field (DepField) that depends on seven other fields (Let's say the fields are named 1-7). All fields (including the dependent field can be either "Red", "Yellow" or "Green" There are different conditions for the dependent field (DepField): If either field: 1, 3 or 4 = "Red", then...
    • missmyady
    • Thread
    • condition conditions to a criteria formula general help
    • Replies: 1
    • Forum: Excel Questions
  10. K

    Sumifs & isblank

    Hi - I am trying to create a condition in a SUMIFS function that looks at works as follows: A B C D (Date) (estimated) (actual) (quantity) 1 9/1/13 9/1/13...
  11. J

    Nested if statement with vlookup + conditions

    HELLO Excel Experts! Goal = Return a value "0" if cell value is blank or "1" if value matches same one on other sheet. I feel I'm close but can't figure this out. I think I need if statement to set conditions of "1" TRUE or "0" FALSE & vlookup to match values on two different worksheets. I...
    • jlugo
    • Thread
    • conditions to a criteria nested if statement vlookup
    • Replies: 3
    • Forum: Excel Questions
  12. D

    Possible Loop Solution Needed: Delete Row Based On Conditions

    Objective: To have no more of 10 specialties per name. The 10 specialties must be the same each time I run it even if there is an introduction of a new specialty next time I run it. Whatever is greater than 10 specialties with the same name should have it's entire row deleted. Problem: I have...
    • drmingle
    • Thread
    • conditions to a criteria delete content excel 2003 vba
    • Replies: 0
    • Forum: Excel Questions
  13. R

    Make calculation using only selected characters from a cell

    Hi all This is the issue I have ( I am calculating school grades) Originally I wanted to use only the 1st character in a cell to make a calculation so for example rather than using "A+" or "A-" I used "A". The foruma for this =LEFT(A1,1) However I now realise that I need to make calculations...
    • Rameses
    • Thread
    • conditions to a criteria making calculations selecting characters
    • Replies: 1
    • Forum: Excel Questions

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    • Started by roykana
    • Replies: 37
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    • Started by Joseph111
    • Replies: 26
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    • Started by Goalexcel
    • Replies: 25
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    • Started by microhunt
    • Replies: 24
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    • Started by Marq
    • Replies: 23
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top