## Keep Cell Constant, but change after Number

Hi Guys, I would like to keep a value constant for the first cell link in this and then change it to the next 4 automatically from $2 to $3. Then after …

Hi Guys, I would like to keep a value constant for the first cell link in this and then change it to the next 4 automatically from $2 to $3. Then after …

I am looking for a formula to go into G2 that finds the combined sum in column D that is adjacent to the product in column C, but for the choice of product to …

I have a spread sheet that acts as an inspection schedule for Tattoo Artist. I would like to be able to autopopulate fields in a paragraph to send emails and …

Hi Yesterday I am using the excel. My boss gives me a challenging job about excel. I have a List i.e. Sr. No Code No. …

I am trying to create a spreadsheet in excel that will give me the three highest ranked fantasy football players for each position left available in my …

I am looking for how I would find the difference between two sets of numbers with one common factor. Any help is greatly appreciated!! By: LaTrisha

Hiya. I’m trying to make a capacity planner and stuck! I can do part two, but very stuck with part one – It’s probably easier if I …

Hi, I’m trying to find out if I can input a file name such as “file name_123456_2018_NI” into one cell and have just what is before the first …

can i add more point in my array in excel by dragging it By:

can i add more point in my array in excel by dragging it By:

Hi all, (system= windows 7 excel 2013) I’m trying to make a formula that will show me the trend in selling prices. My system shows me everytime a …

I have two Sheets. Sheet 1 name is 01.09.2017. Sheet 2 name is rest In sheet 1 i have 3 columns name QTY price …

Hi. I am looking to create an excel sheet where I enter in a cell (Cell A1) a number, which logs that amount in another cell (B2). Then when I enter in the …

Hi i can’t find a tutorial for this, I am having a problem aligning matching names from column A to column B with 12 columns of data from column B. …

Name Test Result No of Attempt Mike Math Pass Enquiry Mike attempt math test multiple of attempts.When …

Hi Everyone I was wodnering if anyone could kindly help please. I may go on a little bit but please bare with me. I am stuck on how to calculate this …

I have been asked to try and save a member of staff half an hour a day, but creating a rota, which is automatic. I didn’t think that it was possible but …

Hello! I am currently working on a workbook involving inventory on each sheet. On my cover sheet I have a summary of all of the rooms where …

Hello, I am self taught at Excel so this might be a simple fix. I am working with 2 sheets In sheet A i’m creating a dashboard to show weekly score …

I want to create 200 clusters of data from a list of cells. In my case, i have 1900 rows of data and i want to divide them in 200 equal groups. How can i do …

I’ll outline the situation: I’m assigning different prices for energy being consumed within different time periods within a day. 23:00-7:59 is x, …

I want a tool order form list in excel ,the first page would be the order form the second page the tool list I want the seconds sheet (tool list …

I created a macro to search for the 0.00 values in a column and then delete the entire row. however any number in the column with 0.00 in it is deleted also. …

Hello I have a set of values in one column, and i want to multiply values between 0 and 20 by 2 , between 20 and 50 by 1.8 , between 50 and 100 by 1.6 …

Hi There, I am trying to write a formula that says that if logical 1 to 7 is all met then it returns an answer of M and if one entry is not true then equal …

This may sound stupid… But I’m creating something semi-automatic. In short: I have an “=Randbetween(1;100)” to work it’s magic in …

Hey guys, i am just looking to see how i can get a formula that will calculate the following. I Have 5 Rental assets, for each asset there is …

Thank you in adavace, you’ll be saving hours in the day. Ok, so I have a couple hundred items for sale on Amazon. When i try to get any kind of report, …

Hi I currently have a workbook with 3 different sheets which I need to tally up info from. I currently have the sheet self calculating if there is …

Hello, I hope someone can help. I am trying to right a Macro/formula to enable me to transfer certain data from one worksheet to another. There are two ways I …

Hi I got an error called “Object required” when i tried to run this code: Private Sub bizpartsubmit_Click() If natbiz1.Value = False And …

Hi all, I apologize for the vague title. but I could not think of a way to properly explain the problem in a single line with so few characters… So I was …

Hi There, I am trying to create a formula to count the amount of forms returned by a department. The database is set up in a way as such: …

Hi,I would like to populate comments on to an Excel line chart that help annotate the story it tells. The chart has time along the X-axis and the …

If F1 has 16/06/2014 in it and G1 has 29/06/14 in it.. how do I get J1:AN1 to be shaded (numbered one 1-30) Thank you By:

Hi – I am attempting to match a employee’s salary with the nearest value (rounded up) in a range. For example: Employee A — $45,000 — …

Hello, Basically what I am trying to do is determine which batch number to use, by generating a value from a forumla, which will have a similar value …

I am building a spreadsheet that will be populated by different individuals, each individual is using their own pc terminal, and that terminal is registered to …