ifthenelse

Hey Everyone, I'm getting a little confused on writing this formula. This is what I have: =SUMIF(F9:F25,"*BMO*",K9:K25)+SUMIF(G9:G25,"*BMO*",K9:K25) This is what I need to add: My range is currently set to K9:K25, however I want the sumif range to use the value in J9:J25 instead when there is...

Hi everyone, I'm attempting to use VBA to change the filters on two pivot tables according to current month and quarter according to a broadcast calendar. The logic for the month filter was very simple, and my code works. However, our quarters are represented on this other pivot table by...

ve four points (x1,y1), (x2,y2), (x3,y3), and (x4,y4). The first two points define line 1 and the last two points define line 2. I'm trying to use a user defined function to determine the status of the two lines, so either Parallel, Perpendiculr, or Neither. This is what I have for the code...

Intent: Display the Message Only once AND only for John Doe When counter and username are used separately, works fine, but not for both ========================================================== Option Explicit Sub Macro5() Dim MsgCounterJul05 As Long 'a zero will be placed in e5 (aka...

Hi All, I have been trying to figure this out for the past hour and I don't understand what I am doing wrong. I have a userform with a textbox. This textbox is grabbing a value from an excel spreadsheet only when a cell in an excel sheet says yes. Otherwise if the cell says no I need the user...

Hello, I am slowly building my knowledge up by trial and error and tons of money on books. However, I cannot seem to figure this out. I have a workbook with 4 sheets, Home, Team 1, Team 2, and Team 3. On the Sheet "Home" I have a simple 4 cell system. "C9" is a drop down box with 18...

Hi, Im trying to achieve the following. There is a table with 2 columns: groupID and limitvalue. For each groupid, I want to check if there are multiple, meaning more than one row (so checking if the next cell has same value) and if there are multiple IDs for that groupID number, check if...

Hi, I have a small query regarding if then Else. I need VBA to read a certain cell and depending on the value run through two different lines of code. I'm having problems getting VBA to read the underlined code. My code below is Sheets("Sheet2").Select myFileName =...