returns

Hi, I'm trying to calculate monthly returns from daily returns using geometric mean. I would like to be able to check the date array in column A of the attached document and locate the corresponding return array if the month and the year of the dates in question are equal to the month's returns...

Hi, I'm trying to calculate monthly returns of a stream of returns using an ongoing set of daily returns. So what I was trying to do was something of the sort: A4:A10000 column = WORKDAY(daily dates) B4:B10000 column = daily returns % S2:S61 column = end of month dates (Jan 2019 to Dec 2023)...

=VLOOKUP returns b37 into c2 not into c37. why?

Hi, I have a series of dates that include the day and the date: <tbody> Mon, 3/4/2020 Tue, 3/12/2020 Wed, 3/20/2020 Thu, 3/28/2020 </tbody> I need to calculate the number of says between the dates, but to do that need to get the date out of the cell and keep it as a date. I tried...

I have a sheet where column P has text like "Two Highways ~folk vinyl" (no quote marks). the formula =MATCH(P2, P:P, 0) returns an #N/A error. But removing the ~ has an odd effect: with Two Highways ~folk vinyl (in P2) Two Highways folk vinyl (in P3) =MATCH("Two Highways ~folk vinyl" ...

Is there a limit to the number of columns or rows you can use? I have table that is 16 rows deep and 81 columns wide. For the Row lookup I have =MATCH(H22,B4:B19,0) (which returns the row number) H22 being the cell where I enter my first query. For the Column lookup I have =MATCH(H23,C3:CE3,0)...

Thanks to all for your work on this site - learned a lot here in a short time. I am stumped by what looks so simple… I have a formula =vlookup(index, namedrange column, false) In one case, with the namedrange written in the formula no problem, returns correct value. If I put the named range in...

i was to place a yes in a cell if K2's text has and *RD* in it at any point. i had the following but it returns a false. =if(K2="*rd*", "yes", "No")

I made a formula which consists of multiple IFERRORs with LOOKUPs and INDEX MATCHes. Basically, if th formula doesn't find the info, look it up on another workbook. The thing is... Inside the third (the last) IFERROR, the "value_if_error" part returns an information, if I press the F9 key on it...

Good Afternoon :) I am hoping someone might know the answer to my conundrum - I have a source of data which is a list of client returns/values, this list is provided by an external source and is in the same format every time, however the number of clients might increase or decrease, and there...

Dear Sir or Madam: My name is Robert, and I am very proud of myself as I am gaining more knowledge about creating complex Excel formulas to help me become a better middle school teacher. I am extremely close to creating a formula that will return a "2" provided a student's answer consists of...

In cell Z6 I have the following formula =IFERROR(INDEX(Input_Events,data!K3,2),"") that returns a formatted date (MM/DD). In cell AC6, I am performing the following test: =IF(Z6=TODAY(),"CALL","") When I have the current date (todays) in Z6, it returns a false test (""). If I change the...

Hi there, I have created the following formula but it does not return the correct row number: MATCH(INDEX(List!G1:G1000000,MATCH(P4,List!H1:H1000000,0)),Ref!W1:W1000000) In sheet Ref, the row number that it should return is 38748 but it returns 38866. The value is a number that is in row...

I have just "upgraded" to office 365 and having some problems with some old work books. I use a lot of SQL lookups that are automated by macros. i have found, if the query returns no results any formula that refers to is is broken, with a #REF error. I fixed this by changing refresh option...

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...

Hello, I am trying to count the number of word occurrences for a specific word within arange, but only if it matches a specific month. <tbody> 05-Jan-18 OPS 12-Jan-18 OPS 19-Jan-18 QA/OPS 26-Jan-18 OPS 02-Feb-18...

Hi, I am currently building a Rota in excel in which each colleague has their own "holiday" sheet. If there is an entry on the users sheet (want to reference the sheet by the name in cell D5 for example) and if there is an entry on their sheet or within the date in cell G3 for example then it...

I'm using the following array formula to create a text string that joins all numbers in a range, allowing me to compare two such ranges to see if all totals are the same: =TEXTJOIN("|",FALSE,ROUND(M27:M38,0)) which by default I expect to return the values 0|0|0|0|0|0|0|0|0|0|0|0 I have two...

Right now I have code that creates a table in PowerPoint 3 rows x 2 columns. This is created from a worksheet in Excel, by copying a 2x3 range of cells. Within each cell are multiple lines of text. The problem I face is that the text in PowerPoint needs to be bulleted. I used the following...

I have the following formula: =OR(isna(C8), C8="None") When C8 matches neither condition it returns False When C8 = None, it returns True However, when C8 is #NA it returns #NA - and not True =OR(isna(C8)) returns True when C8 is #NA Can anyone offer any insight, am I doing something...