results

Hello, I run a dart league that runs for 30 weeks. I have a weekly worksheet that I enter the scores and the column Z (starting from 2 all the way down) calculates the average =IFERROR(AVERAGE($B2:$X2),0) and the player's name is on A2 of the sheet Then I have my results worksheet that gets...

Working with a file of 65mb - a bit over 317,000 rows. Trying to get some Pivot Table data, and three times it is coming up with different results as to the number of items being reported. (Working with a 'Merch Number' - there are 1667 unique ones after removing duplicates, but the Pivot Table...

HelloI need to do no calculations in the Grand Total section when the results are the same in the Pivot Table. And calculate only when the results are different. As in the figure below: [/URL][/IMG]

Just looking for a little help with this formula as I cant seem to get it to work. Basically I'm looking to return an F if the "PP - 3" is greater than 0. Returning a P if "pp - 1" + "PP - 2" is greater than 0 and if when you add all three together it returns a 0 then leave the cell bank. If...

Hi I have this formula that i have managed to get to return the results i need, but it is a it long-winded. Is there a way this could be simplified...

hI guys!,i have at A1:A36 a random generator of 1-36 numbers.i need to extract the results every time of change at B1:B36, then after the next change(every spin) the new results to be extracted at C1:36 and so on.is there any formula for that?thank you so much!

Hi All, I am using SUMIFS if the results in my list are met. I have either Y or N. I am wondering if I can add another drop down that would be ALL. I am looking to be able to filter our all the Y, N, or ALL if I want to sum all of the results. My formula is as follows; the bold is the part...

I want to create a recordset that contains only a single result from a larger recordset, how can I do this? I have a recursive algorithm that calls itself many times, passing a single record in, and getting a new set of results where one entry will be used in the next step and then passed on...

Hi I need to sum all the results from the column and understand SUMPRODUCT may be the answer. Any help would be appreciated :)

Hi, I have used iqy files for excel on mac. It loaded the table results and i was able to format it but it left the hyperlink as needed. I decided to try power query and used my windows version of excel and I am able to make the connection and pull the data. Much easier to deal with. But the...

I’ve got a loop that puts an ID number into a cell and thencopies the results from another cell to an output sheet based on formula on thesheet, however the vba code doesn’t wait for the formula to update the results cells and so copies whatever was in the result cells at the start of the...

Hi all. I need Excel to count lines that include the phrase "test & 10", but not to count other lines that only have the word "test" without the & 10 I'm finding that I get zero results for "test & 10" as the keyword 'test' is filtered out in the 1st argument. The formula I've tried is...

An extension to this problem: https://www.mrexcel.com/forum/excel-questions/1107696-approximate-match-vlookup.html I want to amend this formula: =IF(C3>INDEX($I$3:$I$7,MATCH(A3&"|"&B3,INDEX($G$3:$G$7&"|"&$H$3:$H$7,0),0)),"Y","N") to this...

I am currently working through middle size data sets, around 1000 recordings, and want to be able to work through them quicker. My main problem is that if I have a column marked "test" with results from the tests in a different column marked "results" with the values, is there a shortcut to lets...

Hello Team, I an encountering this error regularly. I tried to debug the code but unable to resolve the error. Request you to guide me to resolve the issue. I have similar file with this code and it is not showing any error. Here is the code for your reference. Please share your response with me...

Hello, I am dividing a cell by a set value in excel, but I would like to return 1 if the results are 0 or <1. I'm having trouble writing the formula correctly. This seems pretty simple, but I am goofing. I have tried If functions. Thank You for your time.

Hi Excel Masters! I have a situation here. I've created a search function where I can search a data set by typing in a client name (or partial name), and my table will return all entries with at least a partial match. I.e. search "Ohio" and it returns Ohio State, Ohio State University, Ohio...

Hello, So I will try and explain this as easily as I can using an example. Lets say I have this data in 3 rows: 0 0 0 0 0 0 5 8 0 9 4 1 5 0 0 0 0 1 5 6 7 9 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 7 9 The formula I would need would return the following results in 3...

Hello everyone, I need help finding the location of rows from 2 different criteria that are in 2 different columns. and here is an example of the data that I have which is located in sheet1 <tbody> A B C D 1 Data-1 Data-2 FIND : 2 ec x ec 3 ec z1 v7 4 dh r 5 ec v7 6 dh kr...

I'm having issues with the last part of my formula. I have two sheets, a results page (where the formula is written) and the Database page where all results will be stored. When I write this formula out on the database page, it works exactly how I want it to, just need it to work on my results...