excel formuals

I am trying to build the logic in Excel where the value gets updated based on the Load criteria. I have attached an example where the row should update once the total of the cells in row 2 is in multiples of the load value. The logic should then take the difference i.e Total - Load and then...

Howdy all, I would like to find a way to have my excel sheet automatically produce a new row of formulae with a new file reference to reflect the new month. i.e. I would like the below formula to be replicated in the cell below and have the name for the document referenced changed from 'June...

I have the below data set when i select the Department I want to get a table wih all the employes working in thhat department like this Only Vlookup formula can be used to obatain the result table. Kindly advise. Thanks for the Help in advance

I have a dataset like below when I select Department from the Dropdown I need to return multiple matches in atable format like below Which Formula can i use to get these multiple matches in a table format....Thanks in advance

Here i paste one excel report. In this, In need to make a report form a Master data with search keys.. please find the attached file and help me please... thanks in advance.. <tbody> Master Data Item No. Name Code Price Cat. 245 Apple Red UK 1.50 10 4157 Orange Naval USA USA 1.30 11...

There are five particulars in summary sheet, and i want data accordingly from RCU MIS Sheet. Particular: 1. Date (C2) - I want data here as per data from RCU MIS, let's say if i select 03-03-2017 then No. and Value should be populated as per RCU MIS data. 2. MTD Sum (E2) - Here MTD stands for...

I would like to have a formula that will show the progress of days in a specific month. Example: On 10 Jan 2017 the formula would create the number 10. The tricky part is I would like it to stay at the total days in the given month when it goes to the next. Example: On 01 Feb 2017 it would...

I am trying to create a formula that will count the number of results that fall within a certain range with text. For example all Canine results that are greater than 1 but less than 7 the formula I am looking for would return a value of 2 in Cell H2. The formula I have returns an error...

<tbody> Hello Ladies and Gents I have been tasked to do the below but have no idea where to start, very grateful for any help in solving this issue I have populated the spreed sheet as below with the timings Column A = Time car should have arrived Column B = Time car actually arrived...

Hi i want to make this sentence (Red Color) by formula. Please any one help me how do i make it. <tbody> Channel Tips - July 5th – Redefining Channel Management Through A Unified Lens Newsletter Blast Sent Delivered Delivery % Email Open Email Open % click through click through%...

How do I parse a cell that contains the company name and address? The previous cell has the company name if that helps? <tbody> Customer Ship to 100% KIDS 100% KIDS 485 CENTRAL AVE CEDARHURST, NY 11516 24 HOUR FITNESS UPS-SCS: 24 HOUR FITNESS 11991 LANDON DR MIRA LOMA, CA 91752 2 HOT...

I have an Excel spreadsheet that has each month reporting website visits. I also have next to each month last year website visits. I want to have a YTD column to see how the same months last year and this year are in comparison. What formula can I use that compares the same months from last year...

Hello, I have a program which spits out data formatted like the table shown below (the real table is hundreds of lines long). I want to find the frequency of certain headings such as "Pears a", however I am having trouble as the 2 variables 'pears' and 'a' are in the same column. And to make...

Hello I have a data as shown below. I need to Check Column B at what value it goes above zero.At C i need to enter the corresponding A Value. <tbody> A B C 0 0 5 1 0 2 0 3 0 4 0 5 0.1 6 0.2 7 0.3 8 0.4 9 0.5 10 0.6 </tbody> <tbody> A B C 0 0 7 1 0...

I have two columns called 1ST column Calendar Date:16/02/2015 2nd Column Previous Day:Yes(Formula I am currently using if([calendar Date])=today1,"YES","NO").The 2nd column returns value based on the 1st column. However , the problem I am getting is when I run the data on monday when we...

I have a leave calendar which is highlighting as per the start and end dates using conditional formatting formula =SUMPRODUCT((B3<=$I$19:$I$150)*(B3>=$E$19:$E$150))=1 I want to show name mentioned in cell in front of start date and end date instead of Green highlight in...

Hi Everyone, i have macro code that calculate excel sheets and paste answer in dashboard row, each new excel sheet data paste in new row after calculation. i want to short this code and will be working lot of sheet and row. i means it continue when any new sheet create its done calculation and...

Hi All, I am trying get a value which is on column c, based on conditions. Where I have 3 values (0,1,2) I want formula to return. I have tried using IF, OR, AND functions. but, I feel like I am missing something. I would appreciate if you could help/ suggest towards getting my solution...

Hello, I'm hoping someone can assist. I have run into another issue. I have a workbook that has several sheets. The sheets are created based on a named range. What I am trying to do is with the main worksheet ("Project Tracker"), I am trying to enter a formula in the Due by date. If the...

Hello, How should I create Gini index in excel for this table? no. outcome venue A B C 1 W H y y y 2 L A y n y 3 4 . .