present

I need to have a function to work as follows: Row B3:B11 if the letter D or B are present return Good, If neither are present then return need If I have two D's in the Cells or 2 B's in the cell I need it return Good also. The below formula works if I only have a D in the cells, but if I take...

Hello guys, I hope you can shed some light on this: Looking for a Date in specific ranges There are 4x the same date in two different lookup_area 2x in each area I have a this formula, =MATCH(F61,B4:BK4) which returns the correct column number Date in F61 is present in AR4 & AS4, it returns...

Hi, I am trying to create a SUMIFS formula that will work if a specific criteria is present in either of two cells (B35 OR B36). The following formula works when a criteria is present in a single cell but I'm having trouble adjusting this formula...

Hi trying to get this to work, but returns nothing blank. What am I missing? If name is present return that number ,1 ,2 or ,3 =IF(R2="Yard",1,IF(R2="Yards",2,IF(R2="Tunnel",3,"")))

I'm trying to track usage over several years, for a Santa's Grotto operation. There are several types of present and what I want is one bar graph, with three 100% stacked columns, showing: Presents used/remaining this time last year. Presents used/remaining (based on the number of bookings)...

I am using this formula to tell me if certain text is in cell A1, "mike" in this case. =IF(ISNUMBER(SEARCH("mike",A1)),"approve","") How would I restructure the formula to search for three different variables and return an "approve" if ANY of them is present? For instance, lets say I am...

Hi, I have the following code in use, It is on Sheet1 cell K33 It shows £0.00 when no value is present. Is it possible to not show anything at all until it needs to. =SUM('INCOME (1)'!G32 -'EXPENSES (8)'!K32)-MILEAGE!C32 Thanks

So I need to keep track of staff member's attendance, since we have a goal of 80% to meet for calendar year 2018. I have several workbooks, one for each staff member, since I have other goals I have to track. As a group, I want toadd up all their monthly attendance, for example: Attendance...

I need a MS Excel calculator to find Planetary positions on any given day (past, present or future) as I am a Astrology enthusiast. Can somebody help.

Hi Guys, I have the row number of some values in a sheet (column E) see picture. I need to delete the row where the corresponding value sits. I have used match to give me this as you can see from the picture. The issue is that the value sometimes can be present in the look up column...

Hello everybody. I have the following job. In sheet2 there are a variable number of association column A/B (in this case 5). The goal is matching these 5 associations with the associations already present in sheet1: - if already present, do nothing - if not present, insert a row below the...

Hello everybody. I'm struggling with the following job. Looking for a cell10 value in rng1, if the value is present, then overwrite cell10 with the value next to the left relating to the found value in rng1. Example: cell10 = "abc" If "abc" is present in rng1 (suppose in cell C27), then...

Hi so I am using this below and it works fine. I need update it in a way if I can to sum columns G to K same range if 50 Hud is present =(SUMIFS($G$2:$G$200,$A$2:$A$200,"50 Hud")) <-- this works This is what I tried to do and it returns #Value =(SUMIFS($G$2:$K$200,$A$2:$A$200,"50 Hud"))...

Hi, I have a large workbook tracking the attendance of various employees. I need to count how many people have certain events, ie how many people were late in a month or how many people are ill. I am getting an error whenever I use the following type of countifs, it has something to do with...

I have two workbooks say WB1 and WB2. I need to enter the value in the WB2's new worksheet only if a value is present in both WB1 and WB2. How can I do this using macros. Please help. Thanks!

Hi guys! I need your help once again. I would like to know if it's possible to create a Macro that is going to search a certain value (let's say it that this value is on cell E2). The value that i'm searching is in the middle of a text field (Imagine that I need to find the service order in...

Hi I am trying to do index match Loop through Columns first and then Rows with multiple criteria in VBA My Source data is like: <tbody> Date email ID Attendance Status 22/08/18 Bob22@tiptop.com Present 22/08/18 Milan@tiptop.com Present 22/08/18 Samuel@tiptop.com Present 23/08/18...

<colgroup><col span="3"><col span="3"><col><col><col span="2"><col><col><col><col><col><col span="2"><col><col><col><col><col span="2"><col><col><col><col span="2"><col><col><col><col></colgroup><tbody> 01-Jul-18 02-Jul-18 03-Jul-18 04-Jul-18 05-Jul-18 06-Jul-18 07-Jul-18 08-Jul-18 09-Jul-18...

An organization has provided a loan to an staff. She pays her loan in installments whose principle amount is constant and the interest changes. What is the formula to calculate present value of future inflows if the interest at which the organization is providing the loan and discount factor is...

Hi, I use the the code below:- =IF(G2="y",TEXT(TODAY(),"dd/mm/yyyy"),"") which work great until the next day, when yesterdays day is now the present day. Is there a way to retain the original date ? Many thanks in advance. KR Trevor3007