formulae

Hi, I need a formulae to calculate Due Date including Week-end and Excluding Holidays only Input = Start Date and No. of Days Output = Due Date Logic = Start Date+No.of Days-Holidays (include Saturday and Sunday)

I want to delete contents of some cells and then shift the cells up without modifying formulae in the same rows of the deleted cells. Currently when I delete the cells and move the cells up to replace the deleted cells, any formulae in the rows of the deleted cells are modifed and reference...

Hi Guys, is there anyone know modulus 11 excel formulae to generate 7th digit. Please see below formulae that i tried and it didn't work. =MOD(SUM(B1:G1*B2:G2),11)=0 Below is Actual calculation. Example: find the check digit for the number 036532 <tbody> 3 6 5 3 2 x7 x6 x5 x4...

Good Morning Hope you can help. Formulae required for looking at multiple business classes and labelling them in another cell. I have a spreadsheet has about 10,000 rows. Each row has two fields Column A = Company Name Column B = Business Type Now the Column B is one field which is...

Hi,I have a problem i'm trying to solve and I expect it will take someone 5 minutes to figure out,But not me, I am just learning Excel and its wonderful ways it can automate so much. =IF(TODAY()>E12,"Overdue",IF(TODAY()<e12,"ok",if(today()=e12,"due today="" "))) continues...

Dear All, I do have a sample data set across A1:E4. The data represents the NO Of BINs in which the SKU is kept at the DC. I would like to figure out the dates on which the no of BINs is more than the Modal no of BINs across a given period. The formulae put in F2=COUNTIF(B2:E2,"<>"&MODE(B2:E2))...

I have been a long time lurker and this forum has been a huge help. However, I have now come across a problem which I can't seem to fix. A quick explanation of my problem: In column A I have a list of names, the length of which changes every week. In column B and C I have 2 formulae and in...

Hi, I was wondering if somebody could help. I'm trying to identify apply an embedded IF formula to identify whether a date in a one cell is before or after another cell. The two date cells my formula is referring to are loss date and renewal date. The IF function reads: if the loss date is...

Hi I hope you can help. I can't get my head around how to do this. Column T I enter a date value. Once I enter a value, formulae in columns S and V calculate a figure. This all happens on the same row. I would like to run a command to convert every cell in columns S and V from their formulae...

I have a large table with names and numerical values. The names appear more than once and so I want to create a second table which summarises the first so that each name appears once with the total value for that name. I will want to apply a filter to order them alphabetically. However, I also...

Hey all, Total Excel newb here. I'm a photographer and trying to trying to make a spreadsheet where I can enter in the amount of product we shoot in a day, the amount of hours worked and have it spit out minutes per item column. I've Googled and found a few formulae but none seem to work, or...

Hi, I want to do a vlookup with 2 different criterias. I am able to achieve the result by either using a helper column or by using array formulae. Is there any way, this can be done without either of the two (without additional column or array formulae) E.g. Here is my data set: A 1 Ash B...

Hi, I have a column of values which are either R, A or G. I want to search the column(range) and if any cells contain R to return R, otherwise if any cells return A to return a A otherwise to return G. I want this is one formulae which I can place in a cell. Any assistance would be greatly...

HI ALL Is there a way to simplify this formulae =SUMIFS(R_conveyor_table!$D:$D,R_conveyor_table!$B:$B,'COUNTRY P&L'!D$6)+SUMIFS(R_vacuum_table!$C:$C,R_vacuum_table!$B:$B,'COUNTRY P&L'!D$6)+SUMIFS(R_Jetwash_table!$C:$C,R_Jetwash_table!$B:$B,'COUNTRY...

Hi All, I have an If Statement that searches for 2 elements. Formulae: =COUNTIFS(AB!J:J,"LOCAL",AB!R:R,"U") In column J it looks for the Letters Local In Column RR it looks for The letter U. I would like to add another Statement that says if 'No' Is found in column S it should calculate...

Hi All, Hopefully i wont confuse this matter. I have for example a bus timetable. <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> 2 3 4 5 2 60 70 80 90 3 70 80 90 90 4 80 90 90 10 5 90 100 110 120...

Is there any facility in Excel (I'm using Excel2010), whereby you can look at part of a complex formula, and immediately see what value that part equates to? Regards, TS

Dear All, I have a large number of Spreadsheets contained in a Workbook Approximately four Spreadsheets are linked to all the others using formulae. What I would like to know is what is the best\easiest way to link all these Spreadsheets rather than inputting each individual formula manually...

I use a spreadsheet at my workplace to record meter readings. However. One of the meters has just reset to zero after surpassing its max of 9999999. So this now shows of course in the overal total as a minus figure. E.g -9877607. Is there a way to tell the spreadsheet that when it goes back to...

Hi all, This may be too general of a question but I am trying to understand the syntax for chopping together multiple references within a formula using ampersands. I'll give a quick random example. I have a list in column A and I want to sum some portion of that list. The portion I want to sum...