excel formula 2013

Hi. I need some help with a formula, please. see the below formula: =IF(OR(J$13="",J$13<$Q$8,$A14=""),"",IF(NETWORKDAYS.INTL(J$13,J$13,weekend,holidays)=0,0,IFERROR(INDEX(daysoff_type,MATCH(J$13&"...

Hi I have a spreadsheet with factory name, review date and overall evaluation. Some factories may have multiple entries and reviews. I would like the overall evaluation to return based on the latest review for each factory. Therefore if i have a duplicate factory on two review dates and the...

Hi All Master, Greeting from Indonesia :cool: I am Edo, after a long time become silent user fan:hammer::hammer: MrExcel today I joined in this forum and need to share some issue that I can't find the similar issue from any thread. I have an excel table and some formula for sum as below ...

So this formula works great. It looks for apple in a range and returns yes if it finds it. However, I would like to be able to look for multiple things and return yes if any of the items are found. If possible I would like it to return the value of the first one found...

Hi, I am struggling a bit to get my date formulas working. In a sense it is a 2 pt question. I basically have a date of which I need to add X amount of days which may go into into the next month at times. Then if that target date after getting added x days is a weekend or holiday it needs to go...

Dear all, I have been doing the following problem: I have a table <colgroup><col span="5"></colgroup><tbody> Name Training welcome day night mark welcome 1 mark two mark day 1 mark some Polyak day 1 Polyak night 1 Polyak one Polyak two...

I have two worksheets in my workbook. Sheet 1 is called Front and sheet 2 is called Details. Cells A5-A57 contain events and Cells B5-57 contains the next date of the event in Column A. Column B gets the data from the Details Sheet. The formula I used to get the date of the next (future)...

Hi All, Is it possible to create a formula with two "IF" but referencing two cells? =IF(B39>=65,($G$32+($G$32*$G$26)),0)*12, IF I38>1,I38+(I38*$G$26),0 I'm trying to improve on a spreadsheet I found online. It is a retirement cash flow and I'm trying to add CPP (OAS eventually). Column "B"...

I work in entertainment and media field and here there is something called Broad Cast Calendar which is very different from ISO standard calendar. Here they make changes to calendar such that every month has almost same number of weeks and every week starts with a Monday and ends on Sunday. I...

<tbody> Hi All while calculating the average balance for my working I need to use the last working day of the month, however If the month end does not fall on the last working day, the average balance is not correct. For example, if 29th is the last working day of a 31-day month, the average...

Can I MATCH a single character that may or may not be the only character in the cell? For example, =MATCH(BA10,BC10:BC12,0) Cell BA10 = B Cell BC10 = B Cell BC11 = Bldkfhghj Cell BC12 = FGB Cells B10:B12 could be in any order and their content could be random as well. In this case, this...

Given a number in Cell A1 say 4 I am looking for a formula to sequentially create numbers from 1 to 9 and subsequent values should be 0's in column B Values is Column B should be 1 2 3 4 0 0 I am using below two formulas (first in B1 and then I copy the second in subsequent cells)...

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 to find the partial match between two column. If there is the match from column C with Column A then in column B it will show " changed". <tbody> A B C 1382001001 1362002002 1382002002 1362002003 1382002003 1362002004 </tbody> Tried this formula but it return #N/A...

Hello, I need help with IRR formula. I have several loan ID-s and for cash flows and date of payment for each loan ID. I want to calculate IRR for every Loan ID. I need formula sort of SUMIF, but for IRR calculation.

Hi, I am looking for multiple criteria lookup/max date. I have two different sheets, Sheet 1 contain main data and Sheet 2 contain Terminal and i want to extaract the (Terminal id Max date and transaction with branch) <colgroup><col><col><col><col><col><col></colgroup><tbody> Sheet 1 A B...

Hi I am looking for some one help..my data is as below. <colgroup><col><col><col><col><col></colgroup><tbody> DATE Dept BRANCH Transaction Terminal ID 8-Oct-15 TT MCT IN 21666446 8-Oct-15 TT NIZ OUT 21666434 8-Oct-14 TT MCT OUT 21666446 26-Mar-11 TT MCT OUT 21666760 26-Mar-11 TT MCT...

I am trying to lookup the Location of an employee and their Manager from the most recent month (largest month number) in a particular Quarter. So, if I know the name of the employee and the quarter I'm looking up, the results should display who their last manager was and the location they were...

Anybody shed some light on Excel formula "IF". I have two columns: "Date Trained" and "Current". The end state is to have "Current" populate with True/False if the date entered in "Date Trained" is over a year old. I was working with this: IF(A2<=TODAY()-365, TRUE, FALSE)) Thoughts?

I would like the look for value and assigned a flat% based on value: for example: columnA. Column B tier name. A+ flat%. Lookup formula if column b says "A+" then flat is 1%, if only "A " then 1.5% and so on.