function

I am trying to create a function that when I enter a part number in Cell B17-B29 it will match that part # to "sheet1" and pull the pricing and description. I have all the pricing for everything on the Sheet 1 attached to this main form. For example the equation I put in was only to test the...

Hello, In the code below, I am selecting a specific range. Within that range I am replacing all the cells that contain $O$1 with a formula which contains the RowNumber. Note that everytime I run the code, the RowNumber value changes. So I cannot simply write a number as a replacement. When I...

I am trying to create a nested IF statement to look at a cell and do 3 things: 1. look to see if cell is blank, if so leave blank, 2. date in cell- todays date is < 30 print" DUE" in cell. 3. look to see if cell has NA typed in the cell, if so leave blank My code works in terms of the...

There's a web site (Market Holidays for United States for 2022) that has a small table of the list of Market Holidays. Long story short, I was able to pull in all the tables from 1900 to 2100 using a Power Query function. In doing that I discovered that 56 years (including 2017) are missing the...

I have a table with 20 rows and only 6 rows have data in them. I'm trying to get the average of only the rows containing data in a column. Can anyone help me figure out why I'm getting an error on this formula? Example: Sam 5 Jess 2 Dean 4 Michael 4

Just looking for some guidance... I'm confused on what I should be looking for as far as what formula would accomplish what I'm looking to do. I'd like to be able to look at column H, and if it has text rather than a date, I'd like to change it to the date... You can see in Column A, these...

Hi. I need help with writting a formula. I have a table with 2 or 3 columns. In the first column i have the same number in some cells,but i don't know for sure which cells. In the second and third column i have data that is different in each cell but is connected with the same number from the...

How do I convert decimal dates into a format that shows the month and day? I have tried the formulas given on the internet, but they do not work for me, and I can't figure out why. =DATE(INT(A1),1,1)+MOD(A1,1)*365.25-1 gave 646481. =DATE(INT(A1), 1, 1)+MOD(A1,1)*(DATE(INT(A1)+1, 1...

Hello guys, I have a job that has to do with Google Sheets and would love to get your support in the MrExcel community I have a sheet like this. Phone API URL Access_Token_from_API_URL 09199999999...

Hello there, Seen a lot of literature on this but not something as specific (via organic search). Let's say I have a list of numbers in one column. What function (no macro) would enable me to randomise the appearance of a number not in the first column but within a specific range (from 1 to...

Hi all, Using Excel 365. I'm trying to build a VLookup Formula as a string in VBE so I can apply the formula to a Range using the Formula property of the Range Object. I created a Function that returns a string When in Break Mode, I hover on all of the variables, all fo the variables return...

Hello, I have tried using Index Match and Vlookup but keep getting no results. I even format to wrap and set all data to match format. I would like something similar to the screenshot below. I need a function or VBA that would pull from a cell with line breaks and output with line breaks...

Here is the function. It works. It runs hundreds of times during some VBA procedure. Can the function be optimized? It accepts temparray as an array and identifies the first occurrence of "O", "A+" etc. in elements of array. I think it can be optimized as it compares tempArray(i) in every...

Hi everyone. I'm still new to VBA and running into an issue when trying to create two functions that take a parameter to find the defined range and then copy paste that range into a new sheet. Why am I being thrown this "PasteSpecial method of Range class failed" error in my copyRange function...

Hello, I need help with saving an Invoice Workbook which contains the "Today()" function using a Macro. The Active Workbook (Invoice) has the "Today()" function in Cell B14. Auto Calculate is active so whenever I open the Workbook todays date is displayed. So far so good :) I have 3 Macro's...

Hello, I have the following code which (should) create an array. Function UnitCheckArr() Dim UnitValueArr(2 To 250) As Long Dim UnitValue As Long For UnitValue = LBound(UnitValueArr) To UBound(UnitValueArr) UnitValueArr(UnitValue) = Cells(UnitValue, 4) * Cells(UnitValue, 6) Next UnitValue...

I have a set of dates say in column A and want to associate custom week numbers that reset after every 5 weeks. So for example, the week counting starts from 27/09/21 (Monday) and will end on 31/10/21 (Sunday) making it 5 weeks. For dates after 31st of October, I’d want to reset the week number...

Hi guys, So I created a function that sort of works like a VLOOKUP but for each criteria value returns multiple matches all concatenated and separated by comma (in the same cell). Do you think this function is going to work fine? Or does it need some adjustments? Thank you. The code: Public...

Hi, I am using a macro (see below) to update multiple charts in multiple PowerPoint files (macro is stored in .xlm file). The macro is calling multiple functions (SV1, SV2, SV3, SV4, SV5, SV6). Each function is dedicated to update specific PowerPoint file. The question is: Do I need 6...

I have a userform that takes input from the user and adds it to the first five rows in the next available column of the worksheet. In row 6, I want a formula like: =IFERROR(AVERAGE(D7:D32),"") but the cell reference, of course, has to be for the current column (which changes with each instance...