Search results for query: *

Skip I think I am understanding the formula, but I need the formula to pull the numbers from the worksheet called DETAILED LIST. How would the formula look as the data is from the worksheet DETAILED LIST and being calulated in worksheet SUMMARY. Would I not have to incorporate the name of...

I was able to cut and paste but I need the worksheets to link up as it was before the spreadsheet was protected. Based on my info below how can I re create the formulas I have the data below from the worksheet DETAIL LIST Technician Name - Debra Moak Week Beginning - 5/18/2009 Region...

I have a spreadsheet that a previous employee did withthe same info, but the employee is no longer with the company. The spreadsheet is write-protected. When i tried to unlock it; it asked for a password. Unfortunately that employee refuses to give up the password. How to break the password...

No, I have not tried using a pivot table. Could I not create formulas to get the totals from one worksheet to another?

Skip, Another question, I have the data below from the worksheet DETAIL LIST Technician Name - Debra Moak Week Beginning - 5/18/2009 Region - SW Georgia Agency - GDC Metro Manager - Jeff Myers Date Event TimeTask DriveTime Total Miles 5/18/2009 Ticket...

I have a spreadsheet in place. I have a coulmn with the field name Event Descirption. I would like to know how do I create a box or a note that will show what type of info will be that particular column. In other words when anyone highlight that coulmn (Event Description)I want a box that...

Another Higgins/SkipVought - I was able to use Data Validation>Settings>List (not Customs) and that allowed me to add the items and see the items in the drop down list. What I would like to do is inj a cell type in DELL PFS and in the next cell have the same drop down list with the items to...

I am a little confused. Maybe this will help me. In my spreadsheet this is how it is set up: M N RCA 1 RCA 2 In cell M I want to type in DELL PFS and in cell N I have the option of picking one of the item from a drop down box: Tools Process Training Late Part Additional Parts...

I need help ASAP! I have two cells as follows: Cell A Cell B Dell PFS Tools Process Training Late Part Additional Parts Required Bandwidth If can write a formula as follows =IF(A1 = "DELL PFS"...

I have about five cells in a spreadsheet where I want to create a fraction. For instance I want to know how to write in a cell in this format 10/10 or 5/10 etc.?

Thanks that worked fine. One more question in addition to IF [SITE STATUS]="ON" Then display "Conflict w/ FA Master | Site Status ON" Otherwise display [FA Status] NewFAStatus: IIf([SITE STATUS]="ON","Conflict w/ FA Master | Site Status ON",[FA Status]) If want to add IF [SITE STATUS]="OFF"...

Is this for the Expression Builder in the query?? This is what I have FA STATUS: IIf([ZZ_DuplicatedFADeleteOutput(971)]![Usid(css)] In ([FA_Master_11i_FB]![SITE_CODE]) = "ON", "No Confllict w/ FA Master | Site Status ON", [FA Status] And [ZZ_DuplicateFAManualDeleteOutput]![Usid(css)] " "))

I have another question for you. In Access I have a query and I am trying to add a field. basically I am trying to write a code for the following scenario. I have a field name called SITE STATUS and it may be ON- OFF- PENDING or NO STATUS. I am trying to write a code in a Access query 1) If...

If Cell A is displaying street directions and I want Cell B to give me a value of true if there is anything in cell A how would I write the formula? So far I have =ISBLANK(A2). When I type that in I want to get back the value "TRUE" If there is nothing in CellA then I want to get the value...

How to create a formula in Excel that will give me certain characters? For instance if I have the city Alpharetta and I want to see the last 6 characters only how would I wirte the formula?

Thanks for your assistance...I wanted the end result to show in column F Under Dup FA 100663-A, Under Dup USID 51065-A. That means that they both matched. If it does not match (as the last entry show in coulmn B and D then the end result in column F will say Under Dup FA 102286-A, Under Dup...

Column A Fa Location Code(css) - Field name 10068082 10068651 10068760 10068788 10076550 10090280 10090940 10094492 Column B DupFASiteNumber - Field name 100663-A 99965-A 103039-A 101289-A 80994-A 99952-A 93735-A 99173-A Column C Dup FA Action - Field name In CSS Surviving Record In CSS...

Look at the attached list below. I have this list in Excel and I was asked to create a formula so that MEDICAL, VISION and DENTAL can be known as MED, VIS and DEN respectively. How would I create a formula to reflect that? In other words i need to create a formula in this manner if cell A1 =...

I appreciate your quick response but I am lost...You said for me to do the following: To get an average, I would add two variables to your formula (I'd probably rewrite your formula, but if it ain't broke...): NumberVar Allts:= ts; NumberVar cnt:= cnt+1 Why would I rewrite the formula if it is...

This is the formula I used to get the MTTA in this time format DD:HH:MM:SS DateTimeVar dt1:= {SLM_SE_ServiceEvents.dt_Creation Date}; DateTimeVar dt2:= {SLM_SE_ServiceEvents.Status History.Accepted.TIME}; If dt2 >= dt1 Then ( NumberVar ds:= (Date({SLM_SE_ServiceEvents.Status...