value =

Hi Everyone I have a sheet contain some product numbers (No duplicate) with blank 9 values needed to be filled as screenshot. Another sheet is the values of each product number but its contain more than 1 value as screen shot. The question is "Can I use VLOOKUP or other function to fill...

Hello- I am very green in Excel and my skills are limited, so pardon me if this question appears very non-trivial. I have two rows of data and I've created a trend line with 2nd order polynomial. I created the spreadsheet with data a while back so I don't recall all of the steps to do it...

Hi, I've just registered with the site and this is my first post, I have various forums and posts as helpful resources in the past so thank you all for that! I have some VB code which basically takes values from an input list and pastes them into a calculation sheets, where the results are...

Hi So I am working on a workbook to track my cars mileage over its finance term. I have developed a sheet that predicts its future mileage and the point where the car will be back on target for its predicted annual mileage. On an area of the sheet there are 4 cells in a column The first is a...

Hi All I am trying to use an If statement to return a particular amount if a corresponding cell, on another table has a date (only - if it contains anything else i need it to be blank. Here are the tables: Table 1: <tbody> Initials Day 0 Day 7 Day 14 Delivery $500 $300 $800 $1500 M001...

Hi VBA ninjas! Is it possible to run a loop based on this? If Activecell = Last Day of Month 1. Excel 2010; Windows 7 Pro 2. PC