1. A

    Generating Sign In Sheets from a Master Schedule

    I'm usuallypretty good about self-learning/teaching myself enough to do what I need to,but today I'm at a standstill. Two reasons why, one, I can't seem to think ofthe best way to approach what I need to do, and second, trying to google thequestion in my head doesn't translate well at all. So...
  2. H

    MINUTE’s calculation

    I am looking for formula (in a cell F2) to get difference in MINUTES from D2 (system’s time being regularly getting updated) & B2 with a limit in C2 F2=0 IF EITHER D2 < B2 OR D2 > C2 How to accomplish? Thanks in advance I am using Excel 2007 Sheet1 <colgroup><col style="FONT-WEIGHT...
  3. J

    Return Positive Value of SUMIF

    I am using the following sumif formula: =sumif(U5:U91,"2",N5:N91) N5:N91 contains all negative numbers, and I need to make them positive. How can I accomplish this? Thank you!
  4. S

    How to add spaces to the both sides of text in a cell

    I need to add spaces in the beginning and end of a text. e.g Text is John. I need 4 spaces before J and 7 spaces after n. How to accomplish this.
  5. H

    Non Zero Value from a range

    Input Range C2:C8…ONLY 1 cell contains Non Zero value Output in D2 as Non Zero Value from C2:C8 How to accomplish? Thanks in advance Sheet1 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody> C D 2 0 588 3 0 4 0...
  6. R

    Filter function with wildcards

    Hello, I'm trying to figure out how to use the new filter function in Office 365 Insiders. =FILTER(tblCourses[Name],tblCourses[Name]=B1) works perfectly fine if the text in B1 explicitly matches the text in the Name column of the tblCourses table. What I'm trying to do is incorporate a loose...
  7. J

    Consolidate and Sum the Rows

    I have tried the basic 'Data' then select 'Consolidate' then 'Sum' etc.....looking for some help to sum up the QTY and SYM and get rid of the dups...I have attached (2) images...the 'Before' and what I'm looking to accomplish with the 'After'...any help with this would be very much appreciated...
  8. J

    Running VBA Code From Text in Excel

    Hello, I'm not sure how to accurately provide a summary of what I'm trying to accomplish. I'm trying to create a user form that builds a "text template" based off of what a user inputs into the form. In short, the excel sheet would read: "Testing One Two Three" & vbnewline & vbnewline & "Did...
  9. E

    incorporate date in IF/VLookup

    Hi there, I have a formula below that is working great so far. However, I wanted to add a date reference to it. For example if D1="03/29/19"....then apply the current formula below, if not just "" =IF(ISNA(VLOOKUP($B4,MARCH,10,FALSE))=FALSE,"NO","YES") It is not doing what I wanted to...
  10. D

    Calculating specific columns

    I am attempting to calculate if column H has a specific name in it ex. John Smith and then sum column O which has numbers in it. Not sure the best way to accomplish this or what formula to use. Any help would be appreciated!
  11. Y

    VBA to copy values down and removed excess rows

    When I export my payroll to include employee's pay for the entire year, the software includes each pay period but only lists the employees name once. What I would like to accomplish is to copy their social, EID, Name and locations down to each non blank rows. Also, I need to remove the blank...
  12. J

    I've entered too many arguments for function

    Can someone please take a look at this formula and help me figure out what is wrong or maybe a better way to accomplish this? Thanks. =IF(AND(D13<$A$5, Recruitment_Package!$I$9={"In Bank Footprint"}), (D13*$B$5)/10000, (D13*$D$5)/10000, IF(AND(D13<$A$6, Recruitment_Package!$I$9={"In Bank...
  13. E

    Nested IF?

    I am setting up a work schedule and I am trying to create a formula that will check to make sure that each day at least has a day (D) and a grave (G) shift assigned to an employee. If it does not have one of the two shifts, I would like for the missing shift to appear only in row 4. I think I...
  14. charlesstricklin

    Dynamically filter to another worksheet using Excel: Mac 2011

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #003ecc}</style>I have a worksheet of all of my students in A:H. In column D I have the class period for each student. I'd like to dynamically filter each class period to its own separate...
  15. L

    Excel vba combobox and mysql

    Hello, Can someone please help me I need to populate a combobox with data from mysql via vba how can i accomplish that. I'm not using a userform just a simple combobox. Thanks
  16. G

    VBA Replace

    Hi Guys, Suppose I have a list on text that I want to replace a specific part of it with something. Column A 11346 XZ Alpha 91970 XZ Alpha 113974 YP Alpha 1135 YP Alpha 99786 XY Alpha 99786 XY from XZ to ZZ from YP to MS from XY to JA In my current code, I recorded a find/replace code...
  17. H

    Time Difference in SECONDS required

    A2=6/27/2018 9:59:32 B2=6/27/2018 10:58:38 In C2 TIME difference in seconds is required. How to accomplish? Thanks in adv
  18. E

    Creating a Loop and Output table in Access

    Hello, I am new at creating Loops in Access. I want create a new column for each new occurrence of a ID using a loop. If there is a better way to accomplish this I am open to ideas. Below is what I want to accomplish. Table A <tbody> ID Exception Id Exception Date ABC 55576 7/4/19...
  19. detweiler

    Conditionally formatting a date time cell

    I have a Created Date Time column ( A ) and the cells are formatted mm/dd/yy h:mm AM/PM. I have tried using variations of date and time functions in of / and / or statements with no joy and am looking to highlight those cells whose value is greater than a specified time ( close of business )...
  20. N

    Vlookup for sorting I've been trying to accomplish something in Excel for about a week. After many Google searches, I was led to the link shown above. Although the type of data shown in this link is different, it is essentially...

Some videos you may like

This Week's Hot Topics