e.g

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...

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...

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?

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...

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.

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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!

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...

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...

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 -...