results

  1. A

    Week to week averages

    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...
  2. N

    File size issue

    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...
  3. A

    how to Changes in the calculation and display of the Grand Total in 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]
  4. T

    Help, i'm stumped

    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...
  5. P

    Simplify If Formula

    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...
  6. A

    Extract data from rng

    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!
  7. T

    Data Validation List (Yes, No, ALL)

    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...
  8. baitmaster

    extract single record from recordset

    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...
  9. H

    SUMPRODUCT with INDEX and 2x MATCH

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

    I want to include the hyperlinks from the table I am Importing using Power Query

    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...
  11. P

    Need vba to allow sheet formula to update before continuing

    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...
  12. D

    Count If with same keywords

    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...
  13. T

    Workday

    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...
  14. E

    Shortcutting equations on larger datasets

    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...
  15. V

    Run time error 1004 in VBA Code - the password you supplied is not correct

    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...
  16. A

    Divide but keep minimum value

    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.
  17. D

    Search function + results based on results of search

    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...
  18. S

    Formula to grab the first non-zero value in a row of data, and then every value after that.

    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...
  19. K

    Macro VBA to find row from two different column

    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...
  20. C

    Indirect Function to reference another page

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top