result

Long time reader, first time caller, I want to look for a value in two tables(columns in sperate worksheets) and have the result come back of which table the value was found in. I have tried with If and Vlookup, and can return the result of the first table search, but does not work when...

I have a workbook with over 20 worksheets, plus a summary sheet. The summary sheet needs to grab results from each of the worksheets and the results are in the exact same cell on each worksheet. I am using the INDIRECT function to do this. The INDIRECT function works for the first cell, but...

Hi everybody, I need a VBA code to concanate cells with the sign "|" to the last row. Exemple with only 4 rowsbut i ca be more : Column A: 30602 70012 70311 85244 The result should be i cell B1 : 30602|70012|70311|85244 Thanks i advance :-) Patrice

<tbody> 1 Find Found 2 2 Red Clare Walker 3 3 Black Paul Binns 4 5 Purple Sharon Codd Result 1 <tbody> Blue </tbody> <tbody> John </tbody> <tbody> Smith </tbody> 2 Red Clare Walker 3 Black Paul Binns 4 Pink David James 5 Purple Sharon Codd...

I am attempting to combine 2 countifs formulas and then divide them by another countif and am getting 240% and I cant figure out what I am doing wrong. Below are the countifs that I am trying to combine and the third is the one I am trying to divide by. For reference the first set of formulas...

Multiply the value of B2 by 1.5%, then multiply that result by 56 and then paste the result in D2(i need only result in the cell no formulas) note- 1st row contains headers so ignore the first row The file will be located in C:\Users\sk\Desktop and file name is sample.xlsx file is not opened so...

calculate and add all the data in column G and paste the result in K4(only the result not formula) note- 1st row contains headers so ignore the first row The file will be located in C:\Users\sk\Desktop and file name is sample.xlsx file is not opened so we have to open the file by vba and do the...

hi guys i would like to make a 2 buttons.The one will result 0 and the other one 1 at A7:A47.so when i press the zero button for examplle will result a zero at A7,then when i press again any of both will result at A8..then A9 and so on.can you help me on that?thank you!

<tbody> 1 1 #N/A 2 #N/A 3 2 4 3 #N/A 4 </tbody> I have a bunch of #N/A values in columns. what's the easiest way to get the desired result (1234) in the adjacent column with no empty cells in between?

I need to set a mask (cell number format) to do this: Phone number can be with area code (lenght): 10 (2+8), 11 (2+9) or, without area code: 8 or 9. (non-us format) Some aleatory (non real) numbers just for example: 12345678 result "1234-5678" 1212345678 result "(12) 1234-5678 123456789 result...

Could someone please help me to add multiple functions in a search string? =IF(MID(B18,2,8)="01330701","11-13 hours","") is giving me the desired result for that one formula. I need to check B18 for 5 different number sequences which would return the same, "11-13 hours" result if met. For...

Hi all I have two formula but one have result, one have result = 0. I can;t find out the mistake of wrong formula: formula have result =+SUMPRODUCT((('ky1'!$E$2:$E$9999="0101")*(LEFT('ky1'!$A$2:$A$9999;6)="G03654"))*('ky1'!$F$2:$F$9999:'ky1'!$G$2:$G$9999)) formula result = 0...

I am trying to determine the number of active months for personnel on a rolling 12 month basis. This is the formula I'm currently using but am getting an incorrect result value. I'm new to offset so I know I must be missing something simple. =COUNTA(OFFSET(D2,0,COUNTA(D2:AA2),1,-12))

I need a formula or VBA, which can find corresponding row 0 value in the header C2:K2 and result in the column M</SPAN></SPAN> For an example... </SPAN></SPAN> Of the row 8 cell F8=0 so the value of header C2:K2 F2=4 result in the column M8=4 </SPAN></SPAN> Of the row 9 cell I9=0 so the value...

is it possible to search by date range and the result will show in textboxes without using datagrid/listbox? i have two rows of 3 textboxes first row should show only the result for the first person, and in the second row of textboxes will show only the result for second person. if date person...

On my worksheet, cells A1 through to B6, I have the values 1,2,3,4,5,6 from A1, A2, A3, etc. In cell D1, I type: =SUM(A1:A3*B1:B3) and enter it as an ARRAY formula to get the result of: 32 I understand how this is arrived. It is multiplying cell A1 with B1, then A2 with B2 and then...

Hello All, I encountered a situation that I need your help with a formula to get the result as shown “result” range row J1:X1. The calculation based on weekly updated table on the left. If found a MATCH number from the “numberID” row J2:X2 in the Category row “A, B, L1A, L2UA, and T” , then...

I have the values a,b,c in cells A1 through to A3. I have the value a in cell C1. In cell C4, I type: =MATCH(1,(C1=A1:A3)) and enter it as an array function. I get the result of #N/A. Why is that? I thought the logic is as follows: It compares the value in cell C1 (ie a) with the...

concatenate if cells (col) is not blank anyone can help me :) <tbody> H K L (Result) ABC no result due to K is blank. Formula here ABC D ABCD </tbody>

Hi all, I have this code which used to verify a value from a range of cells and that of my input. It used to work until yesterday when I did a few updates. I get the else alert for any item I feed the input box, except I feed it with the first item in the range – that is cell B4, where I get...