## Unique drop down list option for each column

Hey, I am trying to make columns that have one unique option. First check this image: https://i.imgur.com/uxwX57G.png Like you can see there …

Hey, I am trying to make columns that have one unique option. First check this image: https://i.imgur.com/uxwX57G.png Like you can see there …

I’m trying to create a burndown and burnup chart for my team. However, I’m a bit confused as to what formulas I should be using with the data I …

Hello, I am using Excel 2007 and having difficulty creating a graph that calculates the value “y” for several “x” values. Here is the …

Dear reader, The Matrix below shows the distances between different cities in Poland. I have a dataset with courier services where the recipient city and …

Hello, I have a table of values with 7 columns and 3116 row. The table is full of numbers and I would like to find out what are the 10 most recurring numbers …

I have a list of products in my excel sheet1 (A:A contains the product code, B:B contains the color of item) On sheet2, I would like to have a summary table …

Hi, I have used an excel template for my pipeline which has alternate 2x colours rows and that makes it easier to read between rows. I have added filters to …

I am using Excel 2016 on Windows. I wish to extend the following formula indefinitely down through the rows of a column: =SUM(G7*G8 + H7*H8 + …

I have a data form with a submit button that submits data into log in excel. If a certain number of tasks haven’t been completed and the time (now) …

Hi guys. So I’m going to try to explain this as well as I can, but might fail. I have three columns, let’s day A, B, and C. So I tried to kind of …

Hello, I need a formula to sum the values in a range of cells if the content in another range of cells equals the text currently in a cell in a completely …

I’m having the hardest time getting excel 2013 to get all the things I need rolled into one. I need to enter times in military time and know the …

Hello, I am a beginner in excel. I need some help on data validation formula. Due to character limitation, I am not able to add two more IF clause …

Hi all, I’m looking for a solution to my excel problem. I’m not sure whether this can be done by using formulas solely, I hope it can be …

Hello! I have in COL 1 many rows containing simple expressions (addition, substraction, multiplication and division with brackets) and I need to show the …

Making a usage spreadsheet for Housekeeping. Multiple units with different bedding and towel totals. I have each column separated by what the unit has …

Hello, I need help with a formula. There are 4 cells, only one will show a result at a time, I need a formula that will check the 4 cells and return as …

Hello, I am looking to set up a spreadsheet that will allow me to calculate the number of parts to be order for various models of motorcycles. Some of the …

So I was recently tasked to take over an ongoing report by a former coworker. The report is an Excel workbook that consists of 100 different tabs with …

Hi All, I’m attempting to make a spreadsheet for a school at the moment. On one tab I have the Reciepe and Ingredients i.e. – Cottage …

Hello, I need to sum different columns to calculate a share ratio. When i use “SUMIFS” i can calculate the potentials for A and …

you could see my excel example for calculate the bonus from each downline below their level.and tell me how to get the value automatically because it …

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 …

Please see data example below. In the input sheet, I need a formula that would give me the result for ABC’s Session 1, for January 2017. Then for …

Everyday I pull up a report indicating when someone took a course for my work. Instead of pulling up in chronological order, the report shows the Day of the …

Hi im new to excel, cut a long story short i want to make to make a button so that every time i click it, it makes a shape, in this case the shape is a simple …

Dear group below is a table that i’m trying to create a table for. its looking at dependancy ratio’s and giving a weighted score, but i have the …

Hi! I have two columns of data, the first is a group number, the second is a numerical value. Each group has a different number of values in it. (See …

I’m having trouble writing a formula for my excel file. I want the excel to read the Quantity for each model and instead of keeping them separate it …

Hello everyone, First of all I am not even close to a good at excel, so I was thinking maybe you can help me. I have a workseet that has 2 …

Hello, I am making a budget and need to make this formula: =”Variance “&YEAR(A1-300)&”a vs. “&YEAR(A1)&”b” …

I can use the following formula to get a cell value from another excel workbook =’N:GroupNYcurrent[tradingbook.xlsm]summary’!$P$10 Now I try to use …

I can use the following formula to get a cell value from another excel workbook =’N:GroupNYcurrent[tradingbook.xlsm]summary’!$P$10 Now I try to use …

Hi, Please how to I count the number of yes in coloumn are the match dog or car in column b? By:

Hey, I have this data set which includes phone numbers, length of time of call and date of call. So I want to see how many calls did it take before the …

Hi I’ve created a spreadsheet that’s populated on a day-to-day basis with details of various projects as they’re received. I want a cell to …

Hi, A column ‘V’ has data from a process and the value peaks to around 6.0 at multiple times. The time corresponding to each data point is captured …

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.