## Complex Formula

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 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 …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.