finding

Hello all, I am trying to figure out what XIRR tells me exactly, I understand that it is a method used to calculate returns for a project, but in terms of what it actually means I am finding conflicting information from research online. Specifically I want to understand the difference between...

Morning, Long time reader, first time poster. Looking for some help with a formula, or If it is even possible. I have a sheet that is a summary overview screen. It pullsdata using drop down list from other sheets to display financial performance. The summary screen shows the 11 key...

I realize this is probably something small that I am overlooking, but currently I have a way to get a total of a certain month and I need to change it to a certain year. Is it possible to change something in this equation so it pulls everything for the year instead of just the month...

Hi, Please help.. I am having trouble finding right code for my project. There are three rows. The third rows is empty. I need vba to evaluate B1, if less than 0, put an X in C1. Repeat on down until there isn't a value in column B. <colgroup><col width="44" style="width: 33pt...

Need help finding "Average cost per square metre". Can't think of how to do this. Any help is very appreciated. Also, the cells labeled "Hallway Total" and "Deck Total", are all their parts added up. <fieldset class="postcontent" style="margin: 5px 0px; padding: 5px 10px; border-width: 0px...

Hi all, I was wondering if someone was able to correct what I a trying to do and help me please. I would like to keep the values >0 but <180 the same, but values >180 and <359 I would like it to find the reverse bearing...

Dim Lrow As Long Lrow = Cells(Rows.Count, "A").End(xlUp).Row Range("A" & Lrow + 2).Select ActiveCell.FormulaR1C1 = "54_TPL_01_02_Summary" Shouldn't this be finding the last row and then selecting two rows lower? Its not. Its finding the last row and selecting one below it to put...

Hi all, I have the following formula, but not working. Currently, the value in G6 is 2018 and H6=P3, so i want the following formula to apply: (P$2-$I6)/P$2*($J6/26*P$1) unfortunately, the last formula after the final column is what Excel is finding, which is the formula to use if G6 DOES...

Cell CF8 = MATCH(Date(Year(CF5), Month(CF5), Day(CF5)), $CG:$CG) Cell CF9 = MATCH(Date(Year(CF6), Month(CF6), Day(CF6)), $CG:$CG) I'm reading dates in CF5 and CF6, and then finding the row number in column CG where these dates can be found. Row 9 is the last appearance of 3/1/2018 and Row 15...

Hi, Can someone help me in finding the way to extract a 2 dimensional array from a worksheet/workbook to another worksheet/workbook? I am trying to extract a range of values by declaring array and then reading cell values and pasting it in another file but I am finding it difficult. Thanks.

<colgroup><col></colgroup><tbody> =MATCH(BC$5,INDIRECT("A"&SUM(BB$15:BB15)+1&":$A$10000"),0) This formula works when finding skips between numbers. Is there a formula for finding skips between letters? </tbody>

Hi - I would like some help in finding duplicate names in the same column then highlighting them and if possible counting them. Names are formatted like Surname then Initials - Smith P or Smith AR Can anyone help please

Hello everyone, I need help in finding some data in excel table, I have a table as follows:- <tbody> L1 L2 L3 L4 17700 17900 18200 19200 18200 18400 18700 19800 18700 19000 19300 20400 19300 19600 19900 21000 </tbody> So all i want to do is find a particular column (L1 OR L2 OR L3...

i am getting error,can i get some help here.how to collect the worksheet names in listbox by using macro? i have around 20 sheets..i am planning to add few more sheets instead of finding all the sheets i want to find it through list box.. by using command buttons and listbox.

Hi all, I have duplicated in a column, how do I match the two values that duplicate. Thanks

I need to remove duplicates from rows in excel sheet and also find the no of duplicates found in the current row. <tbody> 1 2 5 1 3 6 5 4 6 5 6 9 5 4 9 </tbody> Output: 1 2 5 3 6 5 4 6 9 5 4 Can it be achieved using an arrays. Dim ArrItem(100,50) as Integer ArrItems(1) =...

Hello all, I'm having this problem with our company's products and what combinations are possible. The following is the situation: <tbody> CUSTOMER_ID PRODUCT_ID 1 A 1 B 1 C 1 D 2 B 2 C 3 A 3 B 3 E 3 F 3 G </tbody> I have specified for each customer what products they...

Hello, I am trying to match Phone numbers from Customers sheet to the records in Calls_Logs sheet. I want the name in Call Logs sheet to get updated according to matching phone number. I have close to 300000 records so it is impossible for me to do it manually. I tried using this code...

I have an order number such as 012, 013 in a separate sheet with details like <colgroup><col><col><col></colgroup><tbody> Order No 012 Status UserName Action Process Tom Await Approval Process Richard Await Approval Process Swetha Await Approval Process Michael Rejected Process...

I am trying to write a Macro that will identify a particular column by its field header (i.e. first row) and will run a specific set of code on that particular column. My current code looks like this, coverting New York to NY:- Cells.Replace What:="New York", Replacement:="NY", LookAt:=xlPart...