results

Hi, I'd really appreciate if you can please help me construct the formula needed to bring multiple results from many rows. (I know that a regular VLOOKUP will only bring the first result but here it's possible that there will be up to 6 required results). I received a file "Current", which lists...

hello everyone i just found this forum from google i was trying to find statistic tool to predict soccer results and people told me that i should use Excel what i want is to input the previous results and the software show to me -the possibility of the X outcome to happen -the tendencies...

Hi Guys, I'm hoping you can help me.... I'm trying to create a simple spreadsheet in excel to keep track of my daily conversations. I have the spreadsheet laid out horizontally which I guess is not ideal (I can transpose this if it makes life easier). I'm hoping to put the date in each week and...

I need to adjust this formula C21+($I3+($I3*$D11)) so itwill either display the results of this calculation OR the value in J3, whicheveris lower. Thanks in advance

I have three columns with names. The first column contains members of team A, the second contains member of team B and the third contains the results. I want to count the number of winners from each team in the results column but I can't. Please help me.

Hello, I am trying to trim down the results of and index match. The results from my current formula have dates with time stamp information: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>2014-02-07 14:00:09 PST I would like to remove...

1. The webmaster needs to code a control in the "Tags" field that COUNTS the number of characters being used up and display the number of characters dynamically AS WE TYPE to help us optimize the words we choose when creating a NEW Post. Also, switch the characters to the color RED when we've...

Hi could anyone help me with this i'm going number blind! https://1drv.ms/x/s!Aszg_mMOoSFEgSM203OyZbldchOt?e=LLq6Ur When I select TU1 in C7 I get the correct results from the table $J$14:$O$20, but when I select TU2 from the dropdown in C7 I'm not getting the results I need? Can someone...

Lets say I have a worksheet consisting of 3 columns and 3 rows row a1=NY row a2 =Tex row a3 =Tex row b1=1 row b2=2 row b3 =3 row c1=Tex c2=Fla row c3= NY my question is I would like to use a vlookup or match or an idex formula in D1 to return multiple values if I use...

Hello folks, I'm hope that you can help me. I have the results of two cells, one is an integer and the other is the result of using the Dollarfr formula. How may I show both results in one cell as, for example 6.4? Many thanks. Mel

I am looking to get all possible outcomes from columns A to P to be listed in cell Q. I will try to upload the excel document but the results should be displayed in the following format, with no spaces between: <tbody> XLM0YTNN1NN1R1NNN0000A2 </tbody> In addition, I would...

Hi All, This is a formula I used =IF(C11<=2;"1";IF(C11=3;"2";if(C11>=4;"3"))), I now want to conditionally format the cells based on the results of this formula like if I get 1 the cell must be red, if 2 the cell must amber and if I get 3 then the cell must be green.

Yes I understand that the total number of possible outcome results is 6561. But how can I get there? Any formula in excel? Kindly assist. Thank u

Hi - I have a number of tabs detailing team results in month order Jan in A2 Feb in B2 etc Then an on another tab I have the monthly results in month order team 1 team 2 team 3 etc for Jan in Cells A2 B2 C2 etc However each month I have to copy the formulae into the monthly results tab or...

I have a workbook that has about 38000 rows of data and about 20 columns. The workbook contains a custom view with about 6 custom views on the dialog list. The custom views filters the data. A typical filter may involve 2 to 6 columns. The workbook has a formula to count the rows...

Hi All, new to vba coding and have been wrestling with an issue. I have a large workbook with multiple worksheets. Each spreadsheet has information in it contained in option buttons (I think they are the Form Control type and not the ActiveX type). I am attempting to write code that extracts...

Hi, I created a vlookup(B2,"Report'!$A$1:$D$20,16,0) and these are the results I get in Column B. Except that I would like to replace my #NA's with text. So something like, NA=Employee not found and 0=Intentionally Left Blank. However, I don't want it to affect my vlookup results that return...

Given the following with expected results: <tbody> Point Pm10 Rank 1 .12 2 2 .13 1 3 .12 3 4 .12 4 1 .12 3 2 .15 1 3 .13 2 4 .11 4 </tbody>

Good afternoon. As basic as possible: I have a field (Response) with 5 different possible results (V Likely, Likely, Neither, Unlikely, V Unlikely), coming in by month (01/mm/ccyy). In a pivot table, I am representing these as percentages of parent column (month), so for example I have those 5...

I have many sales pivot tables showing columns of Current year, last year and plans. Last year and plan data is from Jan to Dec and actuals pasting each month. Now when I refresh to get YTD Apr results for example I need to select Apr manually in each pivot to change the YTD result Is there...