inputs

All, I'm beginning to draw up the plans for a budget model I need to build in about a month and am stuck on a rather large piece of it. Hoping to get your best practice guidance as I'm sure many of you have run through similar projects in the past. Ultimately, I will be holding the full...

Referencing the table I have created below. I am trying to get my inputs from column (a) and (b) to reflect in the dates corresponding in the adjacent columns. After the inputs have been reflected, I will change the dates in the input columns and then change the inputs to reflect on the new...

I have a dynamic range (sheet 2 column d) called "category" that is used as the source data for a data validation drop down list (sheet 1 column e). The dynamic range consists of 2 types of data (inputs and outputs). Over time this range will grow as the user adds rows for new 'inputs' or...

I'm trying to sum up columns of data, but the numbers of rows will be different each depending on the inputs that the user puts in. Is there a way to have a adjustable R1C1 formula?

I am trying to figure out the passage of time, with multiple inputs. I have this formula: =text (D2-B2,"h.mm"), which gets me close, and lets me do 2 column inputs. But if I try and add a third column of time input, I end up with a ridiculous span of time. Is there any way to do the same thing...

Hi there, I am looking to use an index match to select the resulting cell. I have two small timelines (periods 1-4) called "inputs.timeline" and "database.timeline" and two rows underneath named "database" and "inputs". I am looking to...

Hello! First time posting, so appreciate your help. I need to restrict input in a cell to EITHER: 1) A Valid Date 2) A short list of text inputs ("Cancelled", "Withdrawn", etc) Ideas? Thanks for your help! Robb

Can a cells formula be that it multiplies a1 X b1 and inputs the closet total to 100 (but under 100)? thanks for any help Juan

Hi -- I've been trying to do this for the better part of a morning and can't get it quite right. I'm simply trying to create a string ("output" below) that inserts inputs from various "input" cells. I know this is easy, but I'm not getting it complete. Any ideas on how to create the cell...

Hi, relatively new to excel and learned a lot here, currently trying to solve a problem I can't seem to figure out. I have automated data input that goes into a new row each time I have new updates from my website, something like this: <tbody> SKUs Quantity A,C,E,D 9,6,3,5 C,D,A 3,2,6...

I am trying to build a data table and on the horizontal and vertical axis, when i use a formula to derive the numbers, it messes up the results. It only works when I use hard values on the axis. How can I do this?

Is there a way to fill rows in excel with given input values? for tens of thousand rows across several different files given over 400 input values: So I need to fill cell A2 with Ander all the way down to next team take that team name fill it all the way down to next team etc, etc, etc...