formula

  1. K

    # Condition is - How to highlight Cell Value via other cell "TRUE" OR "FALSE" value (if "K1" = FALSE after change cell color to Red) (No VBA)

    @ How to change "H2" cell color change After "FALSE" ????????????????????????????????????????????????????????????????????????????????????? (No VBA only for condition formatting)
  2. A

    COUNTIFS - Too Many Arguments

    I thought I understood the formula but I keep getting this error. Goal: 1. Count the number of "Admission" in Column B, only if Column J says "Vent" 2. Count the number of "Discharge" in column B, only if column J says "Vent" current formula: =COUNTIFS(B5:B28,"ADMISSION", J5:J28,"VENT") I...
  3. D

    Formula in Excel to display email message with CC & email receiver

    Hello everybody, I am currently following this youtube video: (specifically look at around 07:30-08:30) in order to create an email link in my excel file that people can click on, have a pre-determined email message written and then fill out the blanks and send it out. However, while I tried...
  4. D

    Send/display email through Excel in Outlook

    Hello everybody, I am currently trying to create a macro in Excel that, once you click on it, displays a pre-written message (by me) and then allows the user to send off the email from their own account. Is this possible? Furthermore, I know that you can do something like: Set.subject /...
  5. 0

    Formula Sorting and nested IF statements

    I am working on a project for an event where contestants time is recorded real time and depending on all the other contestants scores (as they are entered) a "place" and a "score" are awarded. 1st, 2nd, 3rd, etc places are awarded points if they are members, based on the contestant with the...
  6. D

    Have one cell check whenever data in another cell changes for entire column

    Hello everybody, I am currently managing a database full of stock quantities, here: Is there any way (I imagine some VBA coding) in which I can create a column 3 rows to the right of this one (row L in this case), where every single cell in row L would count the last time (in date, so for...
  7. T

    Need help with a formula...I think using countif example posted

    Hi all, hoping someone can help me using the attached example. I need a formula that will count how many times "apple" or "orange" appears....but I do not want it to count more than once in the same cell. So for this example, in A1 "apple" appears twice and "orange" appears once - I only want...
  8. D

    Pivot table solution? Please help!

    Hello everybody, I am currently managing a list of materials for different sections: The top of the list looks like this: I have about 6 sections (EM, Formulering, Inspektion & more - please let me know if you want all the names). I want to create some sort of pivot table (I assume? I...
  9. V

    Filter or Show only output result

    Hi, Thanks in advance, we have the following sheet where we want to match some condition ABCDEFGHIJ1O NoDatedescp/fDateStatusTrackCommentfp265859542206o is still pending526510-01-2015on rent359624/A5recd very goodo again3359624642206o is sent to us26541510-02-20163596246/A68recd order...
  10. D

    Conditionally format cells to red color if cell 4 rows to the left is not blank

    Hello everybody, I currently have the following list: I want to create a formula (probably through conditional formatting i'd imagine), that basically says: If the cell 4 turns to the left of any designated cell (A1) in row E is not = blank, color the cell in row E with a red...
  11. S

    How to average same cell across worksheets given a condition

    Hello - I'm trying to create a master Workbook that can take the average of the values of an individual cell across multiple workbooks, but given a certain condition is met. For example, I want to average all of the values of C3 (which is a number) across all worksheets, but only when cell A4...
  12. D

    + and - (plus and minus) in Excel list

    Hello everybody, I am currently currently managing a stock overview in Excel (manually), where I have a set quantity. I want to create two columns next to my quantity column where I can enter numbers that should be substracted and added to the quantity, so it looks like this: Now obviously I...
  13. M

    Need help with macro

    Hello! I am trying to use the below macro to flag an error message when a date range exceeds 7 days. I have used the below which only applies to the first cell in the column. What must I do to apply it to the whole column, I have 350 rows. Just to let you know column K is a calculation of...
  14. R

    Formula result other than displayed

    Hello people, The formula I've written shows a zero as result, whereas when clicking the fx-symbol to check the formula, it shows the result will be 1; as expected. Who can tell me why I see a '0' as result in the cell?
  15. A

    Help With A Formula

    Hi, I have a column (D) in my workbook that shows when a file was last updated. I need help with a formula (or whatever approach is right) to determine how long it has been since it's last update. I would like to use the current date comparing against what the date is in the column it was last...
  16. T

    Formula help

    Anyone know the formula to pull the filename only and pout it into a cell. Like just the files without the file name extension?
  17. M

    post information below a merged cell table

    So I have a table with a huge amount of information and it is broken up into 31 sections, one for each day of the month. On the left column are names of associates... So row 2 has a series of merged cells with numbers... 1,2,3 Under that in row 3 are 6 categories which repeat 31 times under...
  18. E

    VBA - update formula when creating a new sheet

    Hello, I have several sheet here - Total is the calculation of all sheets (exclude Template) - Template is the master sheet of Nancy, Quincy, Bella, etc Step on macro : 1. Add new sheet 2. Copy and paste 'Template' sheet 3. Calculate the total on 'Total' sheet (sum formula) The problem is...
  19. M

    Get value based total column in range minus Blank columns

    Hi. I have data in range from Columns G to R. I have value "a" at column J and then 2 Empty Columns. After them I have data at column M and formula give me value "d" but I want to be "b". Also for Column Q, I have "h" but I want "c". If I have Data, this is my formula at Column M( change Column...
  20. V

    Sum if some condition match

    Hi All, We have the following sheets Sheet1 ABCDE1d & TNameOTNEWP/l22/20/2018 0:38:52Tom Van52466521425832/26/2018 16:47:52652302547 Sheet2 ABC102-20-20182Tom VanTest 1pass3Test 2o.k.4Test 35Test 46Test 5 we want the following result if Sheet2!A2 will match Sheet1!B2:B3 and Sheet2!C1 date...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top