excel & if

We need only Visible,"Deskboard" Sheet, When I click Deskboard After Hide All other sheet Also, I will Making Purchase Order Tracking System I was Jump Sheet Using Hyperlink Also. Pleased Need VBA Coding When I click Deskboard After Hide All other sheet Also = "Deskboard" Sheet is Trigger...

I have a number set input to excel by number is 165.78 to 166 or 164.32 to 164 Dim cRow Sheet1.Cells(cRow, 7) = Trim(Mid(Textline,1,6)) If Len(Sheet60.Cells(cRow,7)) = 10 Then ---> Else ---> End If Please help me to answer

Hi I have a formula that works perfectly but instead of returning FALSE and would like to be blank. Can anyone please help =IF(F7=0,MAX(INDEX((Append1[Compliance_Officer]=Sheet1!C7)*Append1[Date_Assessed],))) Many thanks

Can anyone assist with figuring out a way to write out this function to where it takes both hour and minutes into consideration when comparing the NOW time? Details: This is the formula I have under John Smith 1 row...

I am making an index of a large number of files with a very long path, and I need that for each "/" each cell moves to the right. That is, if there are 3 "/" in a cell, that same cell must be moved 3 times to the right. is there a way to apply this to all my excel sheet? All help is welcome.

Hello Gurus, Good day! Could you possibly help me tweak the code below? Scenario is I have to delete the data that is below 500 including blanks and zeroes in Column E. Headers is located in Row A Sub DeleteRowIF() Dim zlr As Long zlr = ActiveSheet.UsedRange.rows.Count With Range("A2:AZ"...

Looking to populate the ID with the largest nth Value in L15 :P15 based on the following conditions. Date is 10/17 location is North =INDEX(A:A,MATCH(LARGE(IF(AND(D:D=L13,B:B=K15),C:C),1),C:C,0)) formula does not work, looking for the appropriate formula ABCDEFGHIJKLMNOP1IDLocation Value...

Hello Good People, Just wanted to seek assistance regarding the below formula. Whenever the cell J2 is blank it returns a Value of 1. What I wanted to, is whenever J2 is blank, it will return the value as Blank.. Hoping someone could help me on this =( =IF(J2<2.51,"1"...

Hello, I'll start by saying I'm a little past novice with the power of Excel, but also not super intricately skilled—so hoping someone with more knowledge can assist! I am trying to have excel create a tracking link based on which carrier an employee selects in Column G and the tracking # in...

Hi, I have two PowerPivot table that I want to combine and copy information to a third table, however the search criteria is empty as the two PowerPivot tables' amount of data changes from month to month. 1) I want the formula in column K for table 3 to be able to copy values from column B...

I am creating a system for Product log which has 3 sheets. 1st sheet is Batch card register which contains batch no. and quantity. 2nd sheet contains product log_In where input for dispatch, rejection and product -In is entered. 3rd sheet is a FG REGISTER which has list of rejection, dispatch...

Good morning, I'm making a report with a summary sheet where the data must be displayed, I already made 1 column that works perfectly fine and other one that is not working properly. I have this formula...

All Question And Answer to save in "Sheet1) We Need Reference "Question" Sheet1 to Sheet 2 , Also need four Option reference data from Sheet 1 According Question Kindly make solution this query

(1) How to get reference Sheet 1 to Sheet 2 (2) We Need four Option Reference According Match Question on Sheet 1 *Kindly make this formula for "sheet2" Condition 1 :- i will change Serial Number After Change Question in "sheet 2" (match Serial no. and question to "sheet1") Condition...

I'm breaking my head on this one and I can't find a logic way to resolve this. I have an excel worksheet with a table containing work records for all my technicians. The records are grouped by technician / device relation using an id code in the first column (column A). I need to filter or...

Hello, I need some help with coding in Excel VBA. I have a file with 2 worksheets, and I have to code a macro in VBA, but I do not know how this works... In WS 1 there is data being added by some formulas that extract data from WS 2. I have to operate in WS1. In column F there is added, what...