research

  1. D

    Calculating statistical significant change in ordinal data

    Hi! I would appreciate help with calculating whether there has been a significant change in physical activity levels between two assessment periods. Question I'm trying to answer: Has the sample become more or less physically active (subjectively assessed) between two tests and is the change...
  2. J

    APA Assistance

    Hello incredible people. Below, you will see APA citations for articles I have to read. Journal articles end with a number and a parenthesis but only some have page numbers. Books have state names or abbreviation and the end of the citation. I would like a column to identify it I am citing a...
  3. gheyman

    Select data (Row) in one table and have it load/add to abother table

    I have data in an ODBC table. What I need to do is when someone selects a record in that table, have it automatically load data from that record to another table. Not sure where to even start or what to research. Any advice/direction is appreciated
  4. H

    COUNTIFS, LEN (and SUMPRODUCT?)

    Hi All, I'm looking to do a countifs formula with one of the criteria being a cell length of 9. I've done some research and found the following: Can you help with how I can combine this with my countifs: Many thanks :)
  5. K

    Nested IF x50

    Hi all, Since learning about IF functions, I was successful in writing a nested IF changing 50 values for a different (but similar) 50 values. Is there a better way that you could direct me to research please. Thank you.
  6. E

    Link to Workbooks in Separate File Excel 2016

    Hi all! I am being asked by a co-worker if this can be done. She wants to create a file that will contain links to workbooks in 3 separate files. One main file with active links to several workbooks in 3 others. I've done research and currently use ASAP Utilities but I am not finding anything...
  7. O

    How to write a drug accountability formula?

    I work in clinical research and would like a program to calculate a patient's medication compliance between visits and to share with the whole team. This would make a lot of people happy and it's something we can print and place in the chart. Formula Calculate the percentage difference between...
  8. C

    2 arguments help

    Hi I have column K which if the word 'research' is in there, then I want column G to then be looked at and if the word 'medical' is in there, then I want the sum of those research/medical figures in column M to be added. The red bit below works on it's own just for adding up all the medical...
  9. S

    ISEMPTY does not want to work properly. Someone help me out of this.

    I am looking to fill in blanks in the selected range with the word "Research" IF the cell is blank then cell = "Research" Simple enough, yet my mind is drawing a blank. The code below puts the word "Research" in the Header (U1), instead of in the blank cell. Something is missing, what...
  10. E

    Resizing individual cell in a row/coloumn

    Hi, I've searched for an answer for a while now. And according to my research it is not possible to resize an individual cell, without resizing the entire row/coloumn. I'm posting here to validate my research, which is telling me that it is in fact not possible. :) Thanks in advance
  11. L

    Query to identify non-implicit relationship

    Hello everyone, First of all thanks in advance for reading this post. Recently, I am exploring Power Pivot and its multiple options and relations with Traditional pivot Tables. I would like to know if this request can be resolve through a formula or query. I am looking to identify a...
  12. D

    Research problem in excel

    Hi guys, I am doing retrospective research in liver enzyme's elevated patients . I am have two columns of ID's ( around 30,000-50,000) which i want to compare and see if there is a match. I do want a partial match between the numbers in each column of 5 digits . A is the premanent group. C...

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