determine

Greetings, I am trying to determine the absolute difference between a reference and a number. I have a formula that I need to use to determine the specifications of a given test on temperature sensitive material. I have a meter that records a temperature mark from two different areas every...

Set arg1 = Workbooks("COMM_COMBINED_INDEPENDENTS.xls").ActiveSheet.Range(Cells(7, a), Cells(e, a)) I have been looking at this line for a while now and I can't seem to determine why I am receiving the error "Application Defined or Object Defined Error". I have all the variables on a watch...

Say I'm looping through rows 1-50, columns 1-10 and I want to determine if a cell is using data validation. How can I determine that? I tried .validation but that must not be it. Thanks NEVERMIND -- look like validation.type = 3

OK, so I have a bunch of microfilm rolls storing records of old newspapers. Each roll is numbered, but we're missing some and I'd like to determine what we're missing. Here is what my data looks like. A is the number of the microfilm roll, B is the start date of that roll, C is the end date of...

Hello, [Sheet 1] <tbody> Type Number Item Is this number within Range? Red 12354 Apple N Red 6549866 Orange N Green 13216 Apple Y Blue 894 Banana Y </tbody> [Sheet 2] <tbody> Start End 123 129 880 990 13200 13300 8979 8980 </tbody> What I am...

Hi! I'm designing a new promotion and i'm thinking how to determine the quantity for each tier as well as how to determine what tiers i should create? e.g. Tier 1 = 1 to 5 units purchase = 2x bonus points Tier 2 = 6 to 50 units purchase = 5 x bonus points Tier 3 = 51 units and above = 10 x...

I am using the following array function to look up data matching several criteria: {=INDEX('Inst Data'!$A$1:$H$1500,MATCH(1,('Inst Data'!$A$1:$A$1500=$B7)*('Inst Data'!$D$1:$D$1500=AA$1)*('Inst Data'!$F$1:$F$1500=""),0),8)} In order to minimize the number of calculations the spreadsheet has to...

Hello, I'm just getting started with understanding the process of importing external information from an XML file into Excel. I'm working with some older files that were created several years ago. I was wondering what the best approach is to determine what source XML file the import process is...

I have a worksheet that I'm currently viewing as page break. I want to loop through all print-area pages and on each page determine how many chart objects are on each page. Any suggestions? -- VBA obviously. Thanks

Hi everyone! On my Excel workbook, I am attempting to determine doctor's name based on patient ID and the Date of Service(DOS). I have three sheets at the moment: main, Doc1 and Doc2 All three sheets contain patient ID and DOS. They may appear multiple times , especially on Doc1 and Doc 2...

Hello! I'm hoping someone can advise me how to create a condition format for the following: If the text of a certain cell equals to "apple", or "oranges", then the cell would be highlighted yellow. I've tried to use the "Use a formula to determine which cells to format", but i can't seem to get...

I have a table with approximately 200 rows of data and 50 columns. I am consistently hiding/unhiding columns to view/print the needed information. I would like to be able to have a list of all of the column rows with a checkbox beside of it and it determine whether that entire column is hidden...

I know how to use the SMALL function to determine the nth smallest figure; however, when you have a table like this, how do I determine the 3rd smallest figure from the GROUP? For example, if I could $25,000 as a single group, $30,000 as another group, and so forth. In this case, $35,000 would...

Good morning all, I'm trying to build a lending price model for my boss. Basically one that can determine the interest rate based on some inputs. Here are the criteria - 1. Credit score - which I have defined as 720+, 719-690, etc 2. The year the vehicle was made - 2015-2017, 2012-2014...

(i) Develop an algorithm to determine whether a graph represented by a node-node incidence matrix is connected or not. Provide a clear algorithm statement. (ii) Code your algorithm in any programming language you prefer, run your code on the node-node adjacency...

I have a macro obtained from this forum (THANK YOU!) which allows me to print a list of pdfs. However, in order for this to work, I have to hard code the filepath (and hence version) of adobe acrobat being used on my system. How do I build into the macro a routine which will search a given...

I wish to analyse a number series and determine if the latest number is higher or lower when compared to previous number values...

Hello, Some help with the following problem would be much appreciated! I have a formula which will determine the CURRENT month and Year in the following format: if today = 12/09/2017 result = AP9 2017 ="AP" & MONTH(TODAY()) & " " & YEAR(TODAY()) I would like a formula, whereby I can drag...

Background: Every week or so I need to adjust pricing on all of my vehicles. This is a cumbersome task so I have been trying to approve it. Current: I wrote a simple formula in Column E to determine if a stock # had activity with in a certain time frame...

Hi I have a number and I need to find out which range it is in between. So for example I need to determine is the number equal to or more than 95 but less than 102 and if it is the answer is "X" or else determine if the number is equal to or more than 102 but equal to or less than 110 then the...