research

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

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

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

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 :)

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.

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

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

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

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

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

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

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