formula

  1. tlc53

    Unique description List

    Hi there, I'm trying to create a unique list of all items which remain unresolved/does not have a resolved date allocated to it. {=IFERROR(INDEX($B$15:$B$19,SMALL(IF($D$15:$D$19<>"",ROW($B$15:$B$19)), ROW(1:1))-1,1),””)} In column B I have the description (B15:B19) In column D there is a...
  2. B

    Specific text conditional formatting

    Hi Everyone, I've made custom sheets and I decided to add a post validation process to a column. My plan is use formula isnumbersearch to look for specific cells having "001" within them. This is all within the same workbook; I'd like to from this sheet(Sheet2) have conditional formatting that...
  3. K

    Adding string text after the result of .Formula function

    In my code, I am letting the user insert a desired date. I then use today's date and the user's input date to calculate the number of days that have passed since the input date & update it daily. This is the code. Target.NumberFormat = "0" Target.Formula = "=Today()- " & CLng(Target) However...
  4. B

    Formula for multi criteria

    Hi Everyone, I want to check if two fields within my excel data equal the same. For instance I want to check Column C and Column F have 1011293 with an X. How would I do that?
  5. D

    Return cell value from database

    Hi, I have a database of responders to a large survey which will be having additions made constantly. I have created a formula to return me a list of the sheets in the workbook (1 sheet per responder) and now I want to collect all response to each questions. Is there a formula I can use to...
  6. C

    Substitute Exact

    Hi All i want to be able to find an exact match when using substitute, not sure if possible. I currently have the substitute formula working fine up until cell A10 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(E5, A5, B5), A6...
  7. B

    Speed Up Column Formula with VBA

    Hi. I'm trying to fill a specified formula from row B2 till there's no adjacent data in column C. The below is what I have and it works, but it takes some time, which I know is mostly because it's reaching out to another workbook. But, any ideas to speed it up would be greatly appreciated. Sub...
  8. M

    Write properly a formula

    Hello, I have this formula in VBA, but I can't make it work Worksheets("mySheet").Range(myRange).formula = "=CONCATENATE(CODICI!" & string1 & "" - "" & ",CODICI!" & string2 & ")" It gives me: "type mismatch " Any ideas? Thank you
  9. N

    Formula to Collate Data

    Could someone please help? I am trying to pull column data from multiple sheets (24 I total so far) into 1 master sheet without doubling up data. These are part numbers. Some are on the same sheet multiple times and also across multiple sheets Reference Sheet1 (same number same sheet)...
  10. J

    I need to replace 0's with NA

    Good morning, I am looking to update a dynamic getpivotdata table so the results can be charted in a bar chart (a pivot table is used to summarise the getpivotdata table so only relevant cells are reflected in the chart). The issue is that the getpivotdata table includes REF errors that impact...
  11. J

    Index Match Return Values

    Hello All, Thanks for all the support in the past. I would like to use the following formula =INDEX(Sheet2!C:C,MATCH(1,(N2=Sheet2!B:B)*(A2=Sheet2!A:A),0) )but it seems to not function properly. I have two worksheets open 1 and 2 = I have two criteria to match on. Column A and Column N on...
  12. T

    Excel Formula Date

    Hello, I'm hoping someone will have a good solution for this. Our client sends a list of dates and it either has seven or eight digits in column M, depending on the month. The format we want is MM/DD/YYYY. The formula I have is: =LEFT(RIGHT(M2,8),2)&"/"&LEFT(RIGHT(M2,6),2)&"/"&RIGHT(M2,4)...
  13. F

    Contact details spreadsheet...!?!

    Hi All, I have inherited a sizeable spreadsheet from a predecessor and need to clean it up to enable me to convert it to a CSV file our our CRM system. The problem is, she has entered all of the telephone numbers into one column and i need to distinguish between landlines and mobiles. Is there...
  14. P

    Consider first occurrence while using SUMIFS

    Following table data is my challenge. Can anyone help me to resolve this. I need two formula that can 1. Return -5000 on the first line using criteria company, code and month in a cell and 2. Return -5000 on the second line using the same criteria mentioned above in another cell Sometimes...
  15. N

    Get the highest and lowest % and oldest and newest date (Formula needed) No vba please.

    Please help. I have a list of dates in column A and list of % (e.g., 1.2% etc) in Column B. I need to extract 4 items: 1. Oldest Date 2. Newest Date 3. Lowest % 4. HIghest % Thanks.
  16. N

    Extract XX% from a string

    Hi, How do I extract the % (e.g., 5.81000%) from the ff strings via formula? IRS WAT NXERO Inbis PAYER 5.81000% 20200345 IRS FET NXGSI Inbis PAYER 0.825% 20200345 Thanks
  17. B

    Inserting Rows with formulas automatically populated from the row above

    I'm sure this is a simple fix, but I am trying to insert rows in an excel spreadsheet and I want the row I insert to automatically populate the same formula from the row above it. For example: In cell N6, I have =IF(C6="@",E6,0) In cell N7, I have =IF(C7="@",E7,0) Now if I insert an entire...
  18. M

    Move target once sum is reached

    Value Target used Rolling Total Target 5 19 5 19 10 19 15 18 5 19 20 25 18 18 18 15 15 25 15 17 25 37 8 15 8
  19. SelinaR

    Timesheet formula issue

    Hi - I've checked over the various timesheet threads and can't find an answer to my issue: I would like to eliminate the grey subtotal coloums and in TOTAL HOURS (blue coloumn) I would like the formula to be: START to FINISH less Start & finish Meal break.... as these are all 24hr time formats...
  20. T

    Excel formula question

    Hi, I need a formula that will do the following, =IF(A1≥300,"YES","NO") but cannot seem to get it working. The formula essentially needs to read A1, ignore the first two characters of the cell and output YES if the number is more than or equal to 300. Below is an example of the data set and...

Some videos you may like

This Week's Hot Topics

Top