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

## Dynamicly populate lists based of conditions of other cells.

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 …

## Help

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 …

## Formula help

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

## Capacity planner

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 …

## Auto Populate Some Info

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 …

## Excel array

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

## Excel array

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

## Find first not blank, then the next?

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 …

## Excel formula, remove QTY , from another sheet

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   …

## Data Entry Logger

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 …

## aligning two columns

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

## Enquiry

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

## Challenging Question bugging me to death

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 …

## Stuck at work!

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 …

## Formula help :)

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 …

## Averageif with text and date range

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 …

## Help with clusters

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 …

## if and and time

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

## Excel Millwright tool list

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 …

## search for 0.00 to delete and it deletes 160.00

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

## Excel PROBLEMMM

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 …

## Can You Help Fix Error

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 …

## How do I count up a single cell?

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 …

## Excel Formula for Multiple items and correlating prices

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

## interval calculation across several sheet over a range of cells help!!

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 …

## Macro Help – Transferring columns or cells to a new worksheet based on specific conditions

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 …

## Object required error

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

## How can I conditionally format a cell, base on the contents of a different cell

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 …

## SUMPRODUCT text/vs populated cells

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

## How to link comments to a particular point in an excel chart

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 …

## Excel 2010 HELP

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:

## Find Salary in Range

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

## Matching a formula value to a value in a table

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 …

## Get User ID Tag of Person Logged into Computer

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 …