Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dwayne94
  • Content: Threads
  • Order by date
  1. dwayne94

    Excel Question

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

    Excel Formula

    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"...
  3. dwayne94

    Excel Help

    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.?
  4. dwayne94

    Excel Formula

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

    Formula

    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?
  6. dwayne94

    Writing a code in Expression builder in an query in Access

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

    Creating Formulas in Excel

    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 =...
  8. dwayne94

    MTTA average

    I created a report in Crystal Reports that gave me the MTTA (Mean Time To Accept). I was able to group together tickets that have the MTTA in the desired time format DD:HH:MM:SS. Is the a way to calculate the AVERAGE of the grouped MTTA? When I exported the data to Excel with the MTTA already...

Part and Inventory Search

Back
Top