values

In excel, SUM(number 1, [number 2], ...) is used to sum an array of cells, however, I'm trying to go back to the mathematical usage of summation: n Σ f(n) = f(1) + f(2) + ... + f(n-1) + f(n) i = 1 I'm trying to use this to plug in values to a function such as PV(i%, n,, F) to sum present...

Hi I am trying to write a copypaste macro that will only paste non-blank or non-zero values (the CopyNonZeroValues macro). The “EXAMPLE_RANGE” the macro is referring to is a worksheet that has a bunch of formula driven outputs. If the formula returns a zero, I have it return/formatted as “”...

Hi I have set of numbers in a range , say B2:F6, that are colored differently due to conditional-formatting. I'm looking for a sub to find/identify say YELLOW cells in range B2:F6, then copy YELLOW cell values, then paste the values into YELLOW col. starting in cell B10, and do same for other...

Hi there, It's a long time since I wrote my last message. I would be grateful if somebody could help me on this issue: I have this table with these values: <tbody> Time In Time Out Product ID 00:00:10 00:00:13 A 00:00:15 00:00:19 B 00:01:20 00:01:21 C ... ... ... </tbody> and I...

Dear MrExcel community, greetings! After thorough searching through forum, I could not find an answer to my needs (maybe I didn't search properly?) I have a following issue: I have a LOC column that has unique values (locations) and GRADE column (which has only 4 possible values). My...

In a worksheet (called Summary) I have values from G2 to Gn and I'd like column H from H2 to however long to be the unique values from G.

Dear excel experts, I'm struggling to complete successfully one index formula. I need to return a value from a sheet, matching three different criteria. I want to find in sheet "VICEPROCESS NE DN" in column S a value, based on the match of three values in columns D,E and F. That have to be...

Ok, so I have pivot table in which I have 2 values I need to represent. One value I have to represent by months and represent SUM, and other should be just SUM. If I put values in pivot, I can in one click present SUM of both values. OR I can separate both values by month, putting month field in...

Hi All, I have a data of all positive and negative values like -400 200 200 -100 100 -500 250 250 300 -150 -150 I have multiple formulas to identify the matching numbers but all i want is modifications I have data in A1:A100 I use the B1...

Morning All, I have tabs “Info”, “Dash”, “Projects”, Dates” and “DatesInfo”. I would like to copy them to a new workbook with the same formatting but values only to remove the formulas. I would like to save the file name as ‘Performance Dashboard - DD/MM/YYYY’ with today’s date in the same...

Hi All - Sort of a conceptual question here but if anyone has thoughts/advice it may save me some time. I'm using the Sumproduct formula below to filter a table for certain rows (base on values from a lookup table), make a calculation, and then sum the results. Typical stuff for Sumproduct...

Hi All Got myself really stuck with something I should know better. I have values in column D of my spreadsheet which will range from 2 to 11 I want to write a formula to return a value in column E along the following lines When Col D cell 3 <= 3.5 then 1 When Col D cell 3 >= 3.6 Or D3 <=...

Hello, I have 2 problems that I am trying to solved. I did my best to search forums but I just cannot seem to find answers (Probably I am not able to interpret the issue properly, been learning excel for more than a month now) 1. trying to use...

Hello! I am struggling with a function to link to a macro that requires me to copy a set of values from one sheet to another, while these values depending on a certain month that I link, and then asking the user a Yes or No question on if they want to replace these stored values for that month...

I have a macro button that opens up an excel template file, calculates it, saves it to a new location, copies all of the cells & pastes values, and then saves the file again. This is done for about 15 files. My issue is that sometimes when I run the macro button I will find one or two or three...

Hello, I'm starting to sweat over something I just discovered. An Excel workbook with a Form as the first worksheet and the values transferred to the second worksheet that I created in Excel 2013 no longer transfers the values from the first worksheet to the second worksheet. What is going...

Issue: Multiple duplicate values in excel cell. I have multi column data A to AA. In some cells I have multiple duplicate values in each cell (contains numbers and alphabets and special characters) separated by comma. How to remove multiple duplicates and keep only the unique values in each...

I need some help with a formula and I've tried searching but not finding an exact match to what I'm looking for. Column A has hundreds of dates, past, present(today), and future. I need a formula that will tell me how many days old (by interval) any past dates are. The intervals would be 0-5...

Hello i need a macro that will Save the current active sheet as a workbook Any help would be greatly appreciated Requirements: Save active sheet as a workbook Values only Save to specific location E.G. "C:\Users\Username\Desktop" Save the file name as "text" & " " Active sheet name

Good day, I am new to the VBA code for excell. I am trying to automate a process for my small business. I am trying to create a macro to find multiple values, one of them is "B00ZL31582". All i came with so far is: Cells.Find(What:="B00ZL31582", After:=ActiveCell, LookIn:=xlValues, _...