accomplish

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...

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...

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!

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.

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...

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...

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...

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...

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...

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!

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...

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...

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...

<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...

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

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...

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

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...

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 )...

https://www.extendoffice.com/documents/excel/895-excel-sort-dynamic-data.html#a 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...