formula

  1. 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...
  2. 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?
  3. 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...
  4. 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?
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. V

    Filter and Index match range if some condition match

    HI All, Thanks in advance, we have two sheet and want some result First Sheet ABC1O NoDatedesc265859521-07-2015o is still pending3359624621-07-2015o is sent to us465894710-07-2015o is pending due to stock562547808-07-2015O is in dispatch process Second Sheet ABCD1I...
  10. V

    Concatenate Unique Values but remove the "/" where the valuue is unique

    Hi all, I need your guidance if possible on how to amend the below array formula? =TEXTJOIN("/", TRUE, IF(MATCH(AN4:AN23, AN4:AN23, 0)=MATCH(ROW(AN4:AN23), ROW(AN4:AN23)), AN4:AN23, "")) Currently it adds the "/" as a pefix to the end of all values but i need this removing so it shows like...
  11. R

    Fill in the start date and end date with each list name with vba

    Dear All Master , Please help me to fill in the start and end dates that have been specified in the vba sheet in column B that I marked the color based on the list of names in the vba sheet in column B that I marked the color. The result is in sheet 2 in column A & B which I marked green. I...
  12. I

    How would I convert time values to words?

    Hello. I have a workbook I created to track break times at my work. I have a column of times in a workbook in the custom format [h]:mm:ss. Example 0:06:00 for six minutes. This column tells us how long the person went over the required break time. I would like to, in another column display this...
  13. V

    Concatenate to show values to 2 decimal points

    Hi all, I have tried Google to find a fix to my issue but nothing has worked. The problem that I have is the below formula needs to show 2 decimal points when it concatenates. =IFERROR(IF($CJ2=$CK2,$CJ2,IF(CZ2=2,(CONCATENATE("£",$CJ2," / ","£",$CK2)),IF(CZ2>2,(CONCATENATE("£",$CJ2," -...
  14. V

    if some condition match then sum of the value

    Hi all, Thanks, We have the following two sheets ABC1O NumberT1T22pk-98417aa568df9563pk-526325aa659df9568 Sheet2 ABC1NumberNo of StuAttent2pk-984175244563pk-526325624634pk-98417235305pk-526325654155556 we required if Sheet1!A2:A match with Sheet2!A2:A and heading of E2 & F2, then total of...
  15. D

    How to get the specific charachters from the text?

    Hello Everyone, I would like to take the specific characters from the texts in the first column into second column with the formula. Could you help me with this? Which formula should I use? We have 5 specific characters ("Correction", "AB Correction", "Secondary Work", "Final Check"...
  16. S

    Help needed to create a formula

    Hello, I am trying to do the following (and I am totally stuck). I have a list of suppliers and their respective deliveries they did for us. For each delivery, I have assigned a scale (green, yellow, red), in order to measure how good the delivery was in terms of timing. What I would...
  17. W

    Adding number of days to a TEXT date formula

    Hi, I am trying to set up a formula that adds 30 days (payment due) to the date on the invoice being sent. I have being able to create the formula that references the invoice date but I can't seem to add on the extra bit that adds on the 30 additional days. ="Due Date for Payment...
  18. A

    Dragging Formula with Cell Range not overlapping

    I am trying to create a summary page for a large data collection workbook. I am running into an issue however when trying to drag my formula down through the column. The formula is set to show as Done if there is a value in cells F4:F15 using =IF(COUNTBLANK(Sheet1!F4:F15)=12, "","Done") I want...
  19. B

    Excel formula to verify info in one sheet to pooulate a cell in another

    Hi I require the ability to do the following If Cell O31 on Sheet 1 contains "Yes" then the value of cell V40 on Sheet 1 is copied into cell E9 on Sheet 2 can I get so help with this thanks
  20. A

    Excel Noob looking for help!

    Hi people! This is probably so easy for most of you and I imagine you could do it in your sleep, however after fiddling around I've still gotten no where. I have an excel sheet, with around 30,000 columns and quite a lot of rows about Pro Cycling and how I rate their performances. Column one...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top