formuals

I have a column consisting date details. But its just entered as texts. How do I make it to a date format. Thank you very much for your valuable time.. <tbody> July 17, 2015 August 4, 2015 August 23, 2015 July 21, 2015 July 13, 2015 October 18...

Can someone tell me what the symbol ^-1 means as I am trying to work out a formula =IF(ISERROR((((B7*0.48888)^-1)-(371^-1))^-1),0,(((B7*0.48888)^-1)-(371^-1))^-1)

Hello, I have a test I've created for new hires, and I need to identify which questions are answered incorrectly based off an answer column. <tbody> Question: Result: 1 correct 2 correct 3 wrong 4 correct 5 not answered 6 wrong 7 wrong 8 correct 9 correct 10 not answered...

Hi, I am stuck with a data validation problem. I need to validate a cell to allow only characters, numbers and spaces with maximum length of 40 char e.g. My room no is 402. I have this formula =AND(SEARCH(MID(I3,ROW(INDIRECT("1:"&LEN(I3))),1),String),LEN(I3)<=40) but it doesn't allow space...

I am trying to determine how accurate a forecast is. For example, a customer requested 18 items. However, they only pick-up or take 6 items. The forecast of their needs is only 33.3% accurate. 18 forecasted 6 actual 33.3% accuracy Calculating a formula that can handle the reverse scenario...

When i do a drop down Data list, and I create a formula in the name range, it always puts the current worksheet name in the formula. So every new month I have to create a new name range formula. How can I tell the name range formula to always look in the current sheet. Here is my formula...

Hey all, I am trying to get this formula to work properly. I want it to be able to grab the data for the selection of the date that was made. For instance, if I want to show only dates of the driver jake for Jan, then it will only return those dates for that month. Right now, the formula I have...

HI Guys I am looking for a formula that can do this: if row contains the word "center" move it column named "school" if row contains the word "street "move it column named "street" this is the data I have: row1: Miami k-8 center row2: 2301 NW 87 street row3: Miami, Fl 33166 row 4: kendall k-8...

hi, if in the filed you have some text/value and then enter char (it makes 2 lines, but the second one is empty). How we can remove it? Trim isn't work here...

I have attached the google docs for my excel spreadsheet and the list of steps i need to complete, at this point I need help with the first 3 sentances in # 5 and all of #7 https://docs.google.com/document/d/168EFIMexqkv9w4nmMgmzxhjCeSYShuRbcm-QHKUaa-c/edit that is the list of steps and here...

I have a workbook that has several text fields that must be entered. However, there are three special characters which should cause an error message to appear which are <>; I am trying to enter a formula into the Custom Data validation but am having issues with creating one to do what I need...

I am using the following "IF" statement: =IF(AND(TrackingYear=2012,MATCH(TrackingProduct,ProductList,0)>MATCH(Q15,ProductList,0)),"Best Quarter (Pre.)","Runner Up")) I keep entering the above without a double closing parenthesis but Excel keeps adding another one, it seems to me to be a very...

I am using the following "IF" statement: =IF(AND(TrackingYear=2012,MATCH(TrackingProduct,ProductList,0)>MATCH(Q15,ProductList,0)),"Best Quarter (Pre.)","Runner Up")) I keep entering the above without a double closing parenthesis but Excel keeps adding another one, it seems to me to be a very...

Hi Folks, I'm having trouble with how to program a maco that will automate the reference of sequential worksheet names in serveral forumlas in a 'calcs' worksheet The 'calcs' worksheet contains six columns (A to F)... each with a different formula. Each row in the column references a...

hi i am using excell 2008 for mac, I am imputing data into a chart where I have product sku's then number of items recieved on a specific date. I then have a long list of sku's and amounts. Is there a way excell can add up all the amounts or the same sku numbers?? SKU Code Decription...

Hi I had some help earlier off a thread, and just have one more question pls I want to acheive the following: I am using conditional formatting to turn a cell green and want to turn it green under all these conditions: Cell B201 having numbers <!--[if gte mso 9]><xml>...

Hi there, I'm having a little trouble and looking for some assistance. Basically on the top of my worksheet I have a button 'Add Record'. Once clicked I want the spreadsheet to copy the contents of lets say B7:Q7 (including borders and cell colours.) from one worksheet (Sheet 2) to another...

I have the following formula =TEXT('Non Productive Aux'!B25/86400,CHOOSE(MATCH('Non Productive Aux'!B25,{0,60,3600},1),"hh:mm:ss","hh:mm:ss","[hh]:mm:ss")) which I now want to amend and insert the following into the formula above replacing the bits I have made bold =SUM('Opmis MPP...

This is a sample of the data set I am working on. <TABLE style="WIDTH: 184pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=245 border=0 x:str><COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" width=87><COL style="WIDTH: 54pt; mso-width-source...

I have an spreadsheet that is monitoring the productivity of agents, as well as the time that it takes to complete each task. My workforce keeps time as .50 = 30 minutes. So 7 and half hours is actually 7.5. Agents are putting the actual time of it took such as 15 minutes however I would like to...