result

Hi guys. I need go to a cell from the address showing in another cell which have CELL("address"...) formula. For example, In cell A1 I have CELL("address"...) formula giving a result $CD$450, I need to jump to cell CD450. The value of A1 change several times. Thanks

Hi all, Formula in cell AN1 if cell T5 is blank return last value in column AL, otherwise use user defined function to get result <Dim lr As Long lr = Cells(Rows.Count, 38).End(xlUp).Row Range("AN1").FormulaR1C1 = _ "=IF(R5C20="""",RC[-2] & lr,'abc def...

Please can someone advise me the best way to go around this scenario. To help ease calculations for a mileage report I want to put together. I am thinking I will have 2 lists that generate a result (you maybe able to advise a better way?) – a list of clients (going from) and a list of clients...

Hi, how to subtract continuously but the first result will not change for example row F2 will minus all the row in G2 that have match and the result will come up to row H2,H3 respectively and I will subtract again row F2 to row H3 and the result will come up to row H3 but the first result that...

I have a problem I'm not sure if I can explain it well. Here goes: I have a sheet that has continuous data going from row 2 to row 142, row 1 is a header row. I try to sort and it only sorts through row 113 and leaves 114 on unsorted. I use the keyboard shortcut ctrl-down in any column from row...

what is the formula to match automatically the second value if the result of the first match is n/a or zero? thank you!

Hi, I’m trying to create a formula that involves using IF and OR. The problem is that the columns the formula references have a lot of #N/A errors in them, so the result of the formula ends up being #N/A if there is an #N/A in either column H or column I. It just seems to disregard what is in...

Hey community, I want to use Application.ScreenUpdating = False in my VBA code to improve calculating time. I can't see difference between false/true I get result in both option. Can anybody explain me that please?

HI Everyone, I need a macro to align my results in same sheet according to last maximum used rows from multiple columns. I have given image link that how am expecting result that will give exact idea. Please check and do the needful your support will be very helpful for me. Image link given...

=IF(I2="Weld Rod","A",IF(I2="Flame Spray Poweders","B",IF(I2="Special Applicate Coatings","C",IF(I2="Liquid Pen Materials","D",IF(I2="Assorted Glues","E",IF(I2="Powders Blasting MTRL","F",IF(I2="Materials","G"))))))) If I2 is blank the result is: FALSE. How do I get it to display a blank cell...

Hi all, I have two columns of data in excel with the headings - Reference and Result the first cell (A2) in column 1 is a unique identifier the second cell (B2) is the result the issue is that the data in B2 are multiple results delimited by either a tab, quotes, space, asterisk, comma...

Hi everyone! I have stumbled upon a problem while trying to extract the address of the formula's result. Namely, I am talking about the formula that calculated minimum value from the matrix based on the different criteria. The matrix that I have created is simplified just for the purpose of...

Hi, How can i get the first line value of the collumn with "1" value and print the result on the last column like in example above: <img src="https://i.ibb.co/R9WBhzq/Capturar.png" alt="Capturar" border="0"> Thank you very much.

Hello, I need to count numbers in a column, which contains different values, example 0.00, 2.30, 1.02, 0.23 ,0.04 ,0.000042 and 2 blank cells I am trying to use "Countifs" function to provide me the result and it is helping me by not counting "0" and blank cells, and provides me the result...

Hi there everyone, First to mention, my knowledge and skills on Excel are really poor and going through some practice/research I got to a point I can't figure out a solution for this issue. So, I need to basically get what the most common word between some cells. I've checked many solutions...

Hi everyone, Need help with a function/vba I have the following 5 numbers from 1 to 30 in ascending order: Notice below adding all the results would equal 5 (1-1-1-1-1 =5, 2-2-1-0-0 = 5, 5-0-0-0-0 = 5, 4-1-0-0-0 = 5, etc) 7 Possible Results 1-1-1-1-1 2-1-1-1-0 2-2-1-0-0 3-1-1-0-0 3-2-0-0-0...

Hello, I've got an array Countifs function that should return array as result: Dim ws_Test As Worksheet Dim Result_Array As Variant Set ws_Test = ThisWorkbook.Worksheets("Sheet1") Result_Array = ws_Test.Evaluate("COUNTIFS(I1,A:A,I2,B:B,I3,C:C,I4,D:D,I5,E:E,I6,F:F)") But instead...

Hi. What is a formula to calculate the sum for the 4 most recent values based on a date value in a cell (E2)? The result that I am looking for is in (E5) <tbody> A B C D E 1 Date Value Valuation Date 2 04/22/2018 2 07/22/2019 3 07/22/2018 5 4 10/22/2018 10 Result 5...

Hello to everyone Pleas help me I use this vba code to create a loop Sub Loop() For i = 1 To 250 Step 6 For j= 1 To 60 Cells(i, 1) = j Next j Next i End Sub The result is <tbody> 60 60 60...