based

  1. B

    IF Statement

    I am trying to do an if statement based on another if statement: So if someone is In a team I want the formula to do another If statement based on this. Below is my current formula: =IF(C2<54%,"1",IF(C2>=80%,"2","3")) But I need to repeat this if statement 3 times as I have 3 teams with...
  2. V

    Getting Cell Data Based on Boolean Values

    Ok, I have a range of 10 cells that will be filled with a true/false value based on a userform. Is there a way I can fill in another cell with the values that are true? In the below examples say Value 1 is in D1 and TRUE is in E1. In cell A1 I would like to show all the cells in D with a...
  3. L

    Filtering Data based on row data and extract - VBA Code

    Hello All, I have some data set up as per below: Header has three rows then multiple columns: <colgroup><col><col span="8"></colgroup><tbody> ABC KOP KLP TGF KLO NOM DAN 1425 8745 4256 2536 458 985 74856 Apple Mango Apple Orange...
  4. muhammad susanto

    Sequential Number Based On Given Number

    hi all.. how to make sequential number with parameter my target in column "interval" and "given" number as parameter (based on) like this layout : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial...
  5. L

    Formula to pull in name based on criteria from one worksheet to another

    Hello I would like to pull in the fields "Name" and "Comments" from one worksheet into another based on the criteria "where Active = X"). So John Smith and his comments would get pulled into the new worksheet. Thank you <tbody> Name Comments Active John Smith lorem ipsum X Sam Smith...
  6. R

    Counting Values in Column A based on value in Column B

    I want to Sum values from Column A based on a specific Value in Column B. In the sample below I would want the total for each name based on values in Column A. For Example, John would = 15 total, Ryan = 7, etc. <tbody> # 12 John 5 Ryan 7 Mike 3 John 2 Ryan 5 Mike...
  7. F

    Conditional Formating and data validation

    Hello, What is the formula to conditionally format other cells based on the selection from a data validation cell? What I want to do is to fill cells with a colour based on a data validation selection. Then as the second layer of conditional formatting fill cells based on the "start date"...
  8. O

    Shading Rows based on Changed value.

    Hey Excel Gurus, I want to shade a row based on the value in column I. There are sequences of values in column I. for example column I 5D 5D 5D 8X 8X 2M 9M So Rows 1 to 3 meaning 5D should be no color, 4 to 5 meaning 8X should be the chosen color from formatting. 2M no color. 9M same chosen...
  9. H

    Array depending on 2 variables

    I have the following sheet https://1drv.ms/x/s!Ai6fM6lT5gt6h0vP6kgG5MmfsdsU It consists of a table that is populated by a list (with an array). The last column of the table is based on a value in B21. Goal: I want to populate a second table based on the value in B21 and based on the last...
  10. J

    Generate number based on given numbers with no duplicate

    Hi all Seek help. Is there a formula to self generate numbers with a given number with no duplicate. Example: In A1, I have 1234. What formula to use to generate number in a column B1, a series of numbers based on A1 (1234) until there is no repeat. cheers
  11. B

    count number of months

    Hi all please can you help I'm trying to write a formula for the cells in yellow which counts the number of whole months in a calendar year based on the start date, e.g. start date 1st July 2019... there are 6 months in 2019 from start date. The numbers in there I've just manually worked out...
  12. G

    Generating value based on hierarchy

    I've got a tough one, been racking my brains on this for a bit. In short I'm trying to create a "hierarchy" key based on everyone above an individual. For example if I'm four levels down from the CEO, my hierarchy key will be my id, my bosses id, his bosses id, and the CEO. The CEO doesn't have...
  13. T

    Search Column and Highlight Matches in a Range

    I have a 10 x 10 range of cells that are numbered 1-100 (Squares for NCAA Pool). On another tab in the same workbook I have a "winners column" which is formula based that returns which cell won based on a search. To provide a visual of how many different cells have won I would like to...
  14. L

    Excel graph with 2 legends

    Hi all, I want to create a graph based on years (2017, 2018 and 2019), companies (A1, A2 and A3) and type of product (cake, chocolate and cookie). I know it's possible to create a graph based on 2 of these, but it is possible to based one on all of them? If so, how should I setup my data? Thanks.
  15. D

    Can you generate a list from a list?

    Hello, I am looking for some help with lists or for an answer if this is even possible. I would like to create a "home page"(tab 1) with 3 drop down lists. The tricky part is that I would like list 2 to pre-populate based on the selection in list 1, and then list 3 to populate based on the...
  16. L

    text results based on score and also changing the score

    Hi I want to provide text result based on students score but also I want to modify the score and add bonus based on the score and put the new result in "new score" column. The conditions are the following If the score is >20 = very good ( they get a 5% performance bonus) If the score is 16-20 =...
  17. C

    CommandButton(1).visible code needed to fix

    Hi All I want to add another section of code that will make my commandButton1 visible or not based on all 5 cells having data. If all five have data then show button if not don't show button. The 5 cells are, A3, A4, A5, A6, A7. I've got the code to do this for commandButton2 based on one cell...
  18. G

    Loop based on cell value

    Hi, Can anyone look into this? It is not working. Basically, what I need is to delete every "Test" in a specific range that may change based on Range("A1"). If my understanding is correct, I wanted to set it up in Row 2 up to the last row, and any column based on A1 Value. Sub TEST() Dim...

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