Formula for Trun Around Time (TAT) For incident No Weekend
Hi All, I need formula for Trun around Time (TAT) For Incident. For Ex. Start Date Time : 25/2/2018 10:00 AM End time : 28/2/2018 6:00 PM Manual TAT calculation is :- 53:00 Working hours for Sat to thu is 7:00 Am to 10 Pm & For Friday is 9:30 AM to 6:30 PM So I need the Formula as per the Working hours and all days which calculate TAT. So please help me thank youpull multiple rows/columns of info from from one tab into another tab of a template
Hi. Not sure if this is possible. I have an order template that is dynamic based on the info that is pulled into it. Based on D1, B5 & B7 it populates the template from tab called Product List. On the Product lists is column AU called Misc info. The data entered in this column refers to another tab in the workbook. i.e. AU:76 has LG WEST. There is a tab called LG WEST with a bunch of info that is specific for that particular customer. I need to have that info pull into "page 2" of the template for reference I also need it to pull in a picture of the bag. This would be determined by the info populated in G27. There is a tab called BAG PICTURES that has a copy of a corresponding picture of what the bag looks like. I have attached the spreadsheet. For Column D1 choose ROUNDUP.READY from the drop down. For Column B5 choose PRIVATE.LABELrr. For Column B7 choose LG 4R300 CS. For Column B9 put in 100. This will pull in info for one of the orders that has Misc Info and a bag picture. On the sheet to the right of the template in column K2 I have the name of the tab that I would like to pull in the info for. Also down at K37 the name of the bag that I would like the picture to pull in for. These two fields are populated by the info put into the template. If what I am wanting to do isn't possible, please let me know, and I will try to figure out something different. One other thing that is probably something easy. When the template is in its default blank state, is there a way to have it not pull in the False in I10, ##### in G30, #VALUE! in B26 and the 0 in multiple rows? Can it just be blank?
Help with formula
Hello, I am trying to remove the blank selections from a dependent drop list I have created in Excel and I am having a hard time figuring out what the formula would be to get this accomplished. A little background, I have a table with two columns in the first column I have a drop down list feeding off of another sheet to get the manager names, formula is =Sheet1!$A$1:$EO$1. Then in second column I have a dependent drop down list that will populate specific portfolios based off the manager I had selected in the first column, formula is =INDEX(Sheet1!$A$2:$EO$67,,MATCH($A$5,Sheet1!$A$1:$EO$1,0)). The problem I am having is that most of the managers only have about 5 portfolios but one of those has about 65 portfolios, so when I select one of the smaller ones I have a bunch of blank spaces in my drop down list. Any help on how to get this resolved would be welcomed.
coping cells to new worksheet ells
Hi all. I am working with Excel 2016. I have a workbook with 12 sheets in it. I use it my bill paying book. Each sheet is a month of the year. What I am trying to do is the following. Some of the cells have a formula where it calculates a balance on some loans. For example, Cell C3 has a constant value. Cell D3 shows the amount that was paid for that month. Cell B3 has the formula =B3-D3. I want to take the value in B3 (after calculations) to sheet 2 and do the formula over again. Then have sheet 3 take the value of sheet 2 B3 and do the formula, sheet 4 takes the value of sheet 3 B3 and do the formula again. I need this to happen for all 12 worksheets. I have several rows that I would like to do this with. I really am not very good with Excel and even worst trying to use VB. I am hoping to put this in the first sheet, copy all of the 1st sheet and just paste into the other 11 sheets and have the formula properly populate to each new sheet. If this is at all possible, any help would be great full.
Help Creating a Spreadsheet
Hello, I need to create a worksheet that will keep running totals of two different shipments. The spreadsheet will have tabs for each week and will keep a running total. Here is what I need it to have in each column... Item Number (same for each tab) Item Description (same for each tab) Yield (same for each tab - yield it takes to make one unit) Total Units (multiply yield by number of units needed for that week) Sent Units (total units sent for that week) Balance from last week (pulls balance from last weeks tab remaining balance) Remaining Balance (balance from last week + sent units - total units) I have a spreadsheet for one shipment which uses this above but I need to fix it some way that will keep a running total of both shipments but I will be able to pull what remaining balances, sent units, and total units for each shipment. What would be the best way to do this through excel and not be too complicated? Thanks Brenda
TEXTJOIN formula that incorporates a look up?
Hello All, I have a scenario where for example : I have a list of SKU's for inventory in column A, Column B contains the date the SKU/Product was purchased. Column C lists the Client who purchased the SKU/Product. I need a formula that will look up the SKU and then return the names of the Clients which purchased the item within a set date range. For example between July 1st and July 17th for Product SKU 122145 It should return something like " Brian, Steve, Brian, Brian" So Far I have {=TEXTJOIN(",",1,IF(B:B>=H2,IF(B:B<=I2,C:C,""),""))} Which returns : Brian,Steve,Brian,Brian,Dawson,Dawson,Dawson,Dawson I want it to return only : Brian,Steve,Brian,Brian As a Bonus if it could remove duplicates and return : Brian, Steve that would be even better! Thank you so much!
How to copy entire row in a range of data (sheet 1) to Sheet 2 based on the multiple criterias
Hi I am working on a list of new students who applied for finding a friends among students who are currently studying in my college. It is a friendship match. When the new students are matched with the old students, I want these to be copied to new sheet automatically. Basically, In sheet 1 I have a lista of both new and old students. In Sheet 2, I want to write a text that matches with the certain cell value in Sheet 1. If that matches, I want the excel to copy the entire row from sheet one to sheet to. I have attached en excel sheet with explanation on what I want to achieve. I hope it is doable and someone will be able to help me.
