1. C

    Formula help needed

    Would anyone know the formula when copying down rows from row 1 it does the following: - where x can any positive number, e.g. if x = 4, the following from row 1 down would be 1 2 3 4 1 2 3 1 2 1 "" "" etc. e.g. if x = 3 1 2 3 1 2 1 "" "" etc. I suspect you would need the function row() and...
  2. T

    "Contains" filter on number and text column

    Hi, I've got a column that I want to filter using "contains" filter in my vba code. Most of the column data is a 3 digit number - e.g. "842" But some have more digits/letters - e.g. "84203-A" Filter input is from a textbox in a userform. Is there any way I can use an autofilter so that if...
  3. L

    Split hours and minutes in two columns

    Hi, I need a sum of time to be displayed in two colums rather than 1. E.g. 7,4 or 7:24 needs to be one culumn with a 7 and another column with a 24. Any suggestions?
  4. M

    Automating inserting columns

    Afternoon all; Hoping someone can help me with what im sure is a simple problem. I have an excel SS that has roughly 100 columns populated with data. However I need to insert a column starting with column D and then automatically inserting a new column every other column after that. E.g insert...
  5. F

    Finding the number of duplicate points in the plane

    I have 2 columns representing points P in the x-y plane, e.g. Pn xn yn P1 2 3 P2 1 2 P3 9 6 P4 2 5 P5 1 2 P6 2 5 How can I find the number of duplicate points (e.g. 2 here)? Needs to be via formula, not manually or code.
  6. A

    get formulas to skip columns

    I need to be able to quickly copy formulas on sheet1 by dragging but excel doesn't recognize the sequence e.g. CELL D56 =IF(OR(B56=""),"",IF(OR(Sheet2!E32=Sheet1!B56,Sheet2!E32=0),"OK","ERROR")) CELL D57 =IF(OR(B57=""),"",IF(OR(Sheet2!G32=Sheet1!B57,Sheet2!G32=0),"OK","ERROR")) CELL D58...
  7. T

    IF Conditional formatting with more conditions

    I need a formula that I will use based on column A1 and B1. I'll need to put formula's in column C1, Column D1, ColumnE1 and Column F1 and all these formulas are dependent on each other (e.g. A1 = Damaged, B1 = Non-Usable then C1 must return "Return t Vendor - Repairs", D1 must return "Held For...
  8. R

    Integrate automatic journey time into excel formula

    Afternoon guys I use Excel 2016 to produce costing sheets for projects, and I'm trying to figure out if I can get excel to automatically work out how far each customer is from a preset location e.g. a contractor. Any ideas on how to achieve it? Not sure whether it needs to be a super-techy...
  9. C

    Sales Pacing Forecasting - Weekly report changing figures

    Good Morning, I have a report that comes out of our system weekly. It shows all past business actual revenues e.g anything before today and all future(today to the end of time!) forecasted revenues. We are trying to look at or pull the data so that it does the below. *** Put a date in a cell...
  10. muhammad susanto

    VBA : Pulling Picture From Multiple Sheets Into 1 Sheet

    hi expert.. i need vba code to collect/pull only image/photos e.g. jpg or jpeg from several sheets into 1 sheet. my data picture in sheet "hitung1,hitung2,hitung3, etc......" in cell D9 to F9.. i want that pictures can pulled into 1 sheet e.g. sheet1 in cell M2 to O2 down. The pictures must...
  11. P

    General VBA question

    I am an intermediate/advanced user of Excel but have never tried to learn VBA. All the work I do is very calculation and chart heavy, working with time-series and statistics etc. A typical worksheet might include several columns of price data, from which there are several other columns of...
  12. A

    Create / Consolidate Data Range from Full Values

    Hi, I have tried to find an answer to this but to no avail. I am trying to condense a full list of values into ranges (and there isn't necessarily a pattern). E.g. <tbody> Column 1 Column 2 1 1 2 1 3 1 4 2 5 2 6 3 7 3 8 3 9 4 </tbody> Would become: <tbody> Column 1...
  13. F

    Sequence flag

    I have no idea where to start on this one I have a row of columns that would contain days of a month e.g 31 On a row I would like to flag a sequence of 15 in one cell and the next right being 9 Ignoring all other combinations e.g 15 15. Or zero 15 or 9 15 - only to flag a 15 then next...
  14. P

    Power Pivot Question_ Counting Pivot

    Hi All, I'm a rookie about PowerPivot and I'm trying to develop a tool by using DAX formulas but stuck at some point. Attached you will find the data structure that I'm working on: there are 3 "Tables" named Opp, Users, KPI and there are relationships between tables. (e.g. 'Opp[Opp_Owner] column...
  15. S

    Finding Errors using the .Find in VBA

    Hi All, Just need a little help refining my macro. I'm trying to find errors in a column using part of the following script... Dim rngFound As Range Set rngFound = Columns("N").Find(What:=IsError, After:=Range("N4"), LookAt:=xlWhole, _ SearchOrder:=xlByRows, SearchDirection:=xlNext...
  16. D

    get the 12th date

    not sure if this is possible, but I'm trying to get the 12th day ..but if the 12th day falls on a weekend , I want the tuesday following e.g., this month (July)...July 12th is fine because it falls on a Friday but, for May....the 12th was on a Sunday, so I want the formula to pick up May 14...
  17. E

    Is there a way to calculate SUMPRODUCT for an array and a number?

    Is there a way to calculate SUMPRODUCT for an array and a number? E.g. array 1,2,3,4 and a number 10 So it should be 1x10+2x10... Thanks!
  18. H

    Formula to replace zero-length string

    Hi, few sort of follow-up questions to this thread here: https://www.mrexcel.com/forum/excel-questions/42495-better-explanation-null-empty-nothing-solved.html 1) Is there a formula-solution (i.e. no VBA and no text to columns as I understand that solutions do exist with these tools) to convert...
  19. A

    numbers extraction

    this is the question posted by another member in "Questions in Other Languages" https://www.mrexcel.com/forum/questions-other-languages/1099110-extract-tail-tail-combination.html that I'd translated here the last digit of any pairs of numbers in A:F matched the last digit in G, merged the...
  20. S

    Custom Formatting - Number & Text

    Hello, everyone! I am trying to create a spreadsheet to track action items for contract task orders. To make things easier for me to avoid formatting mistakes (the spreadsheet will be editable by more than just me) I would like to create a custom formatting that takes an entered ID number -...

Some videos you may like

This Week's Hot Topics