pass

Hi I need to put in a SUM formula at the end on some columns of data. The issue is, the range of the columns are dynamic. Based on other code, I have the locations of these columns, however I don't know how to pass them into the SUM formula. I thought using the .formulaR1C1 method would be...

Hii, I'm getting error code 91 object not set while running this sub. while when I debug and go lie by line by pressing F8 it doesnt show any error and run smooth.Please help. i would be really thankful. Sub systemLogin() Dim objIE As Object Dim uName As String Dim pAss As Variant uName...

Anyone can help on how to calculate Column D: <tbody> A B C D 13:00 14:00 01:00 Failed 13:00 13:00 00:30 Passed </tbody> In column A and B, and C, i used MOD, format cells custom 00\:00 in subtracting time. For column D, I tried this formula IF(C1>1,"PASS","FAIL") but it does not give...

Okay, so here's what I'm doing. I'm teaching a class that requires essays to be submitted. The first one, since it was due on class 2, I am doing Pass/Fail - if you turned it in you pass, if you didn't you fail. I've created a monster spreadsheet to do my tracking for me. What I want is to...

Hi Can anyone please help? Really struggling as a novice on VBA to pass a variable between 2 subs... The first sub works fine and counts the number of rows in the data and stores in variable i, which is then used in that sub routine. The second sub that runs from a button click, I need it to...

I need help building a function that.... If the number starts with: 06, 10, 63, 71, 91 That row FAILS! Example: (Wont let me upload photo) ​ <thead style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;"> NUMBERS: First Two Characters: PASS/FAIL: </thead><tbody...

Hello All, I have a data set where an Entry is graded Pass/Fail on a series of inspection points. If any of the inspection points "Fail", the Entry is considered a fail. I'm looking to write a formula that reviews each line and counts each Entry that is a Pass. I have been able to accomplish...

I have the below formula =IF(AND(OR(H2="#N/A",I2="#N/A", J2="#N/A")),"FAIL","PASS") In the results it either brings "PASS" when passed or shows "#N/A" when failed. How can i get this to say PASS when it's passed and FAIL when it's Failed?

Hi Im still wondering with lot many problem's.. Request all board members pls look at this and try to provide me solution.. I really dont understand how to start.. I will start from below... There are 2 sheet's which I dont want to show to user's.. Private Sub Worksheet_Activate() Dim Pass...

Hi guys, I've got this sub that acts like a function, i want to pass another table to it since i want my sub to do the exact same thing to two tablse. A code snippet from my code below. For Each nameRNG In [table8[Employee Number]].Rows emp_num_ser = nameRNG.Value emp_row_ser =...

This function works if I pass it a list of cell addresses, like =Rangesum(C4,D4,E4) Function RangeSum(ParamArray list()) Dim i As Integer RangeSum = 0 For i = 0 To UBound(list) RangeSum = RangeSum + list(i) Next i But it gets a value error if I call it with a range, like "RangeSum(C4:E4)"...

Hello All, Thank you for taking a moment to review and see if you can assist. Attached is a copy of the sample data I am working with in Microsoft Excel 32-bit 2013. * Columns A:AS are my weeks 11-25 data to calculate the Pass %. * Some weeks failed (see Week 11 with 0 out of 3), while...

I'm using MS Office 2010. win7 Somehow I've gotten the selected new rows to focus rather than the most recent one. I need to use FOR Loop to find and select only the last row. so how would i put it in For...Next Statementthis what i have so far: Option Explicit Private Sub...

I have an Excel Sheet with the World Map placed on it as individual Shapes. USA's Shape name is S_USA and when selected I want to pass the Shape's Name to the Pivot Table Filter so I can see a list of Suppliers in That country. I already have the data set up to match the shapes names. Now it is...

I am new to excel and have some issues, i have made a tracking sheet to track student exams and assessments. When a student completes an exam i input there percentage mark into a cell next to their name <tbody> Name 60% 40% 70% 100% 80% Pass RPL Pass </tbody> the pass criteria is 60% or...

I have a performance question on how Power Query works. I'm hoping someone has an answer rather than me having to test on my 12-million row dataset and slow laptop. If I have (say) three Table.AddColumn commands, does PQ iterate through the entire dataset 3 times, or is it "smart enough" to...

If I want to pass ONE argument to a SubRoutine, I can do this: Dim MyArray() as Variant MyArray() = Array("Apples", "Oranges") Dim i As Integer For i = LBound(MyArray(), 1) To UBound(MyArray(), 1) Call SomeSub(Arg:=i) Next i What if SomeSub requires TWO arguments? How can I...

I have a really, really simple vlookup formula that has been working, but for some reason has stopped. The function is to take data validation using "Pass", "Started", "None" and assigning a value to them of Pass = 20 Started = 10 None = 0 The formula is =VLOOKUP(F35,Data!L27:M29,2)...

Have you ever posted here and no one answers your question? Well, people on MrExcel have been very helpful for the many years I've been on this site. So, just to help out, there are some typical issues that may cause people to pass over your question: I'm sure there are other reasons but these...

I need to Tag the first instance based on Criteria I need it to search a all instances and always Tag the first Match if the Item (39576 ) the Table T014 or T011) and if its Passed and Tag the first date of that pass <tbody> ID Station Start Time Result Tagged 39576 T014 10/27/2017 11:59...