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 strongm 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: *

  1. quig699

    Need Help pulling specific info from a cell

    Andy, Thank you so much for taking the time to share this with me. It is very much appreciated. You are AWESOME!! It worked first time out. Have a great day!!![smile] Thanks, Amy
  2. quig699

    Need Help pulling specific info from a cell

    Hi Andy, Thanks for helping. I was thinking of just adding a column and putting the quantity ordered there if I could find a formula to do it. As far as VBA, I have never used it before, but if it gets me what I need I will try. Thanks again Thanks, Amy
  3. quig699

    Need Help pulling specific info from a cell

    Hi, I have been trying to find something on google to help but for the life of me can't track down anything. I have data in this format in a cell. 0101-6,0110-6,0101-6,0110-6,0181-1,0182-1 The data represents SKUs and the quantity our customer ordered. Depending on the order it could just...
  4. quig699

    Trying to pull specific data/text from a cell in Excel

    Hi, I am trying to find a formula to pull specific text from a cell in Excel. My company's ordering system lists our skus in the followng way when we pull our orders, the sku-quantity. Example 0101-3, meaning 3 of the sku 0101. When multiple items are ordered the text for items orders looks...
  5. quig699

    Filling in the blanks

    yes!! Thanks, Amy
  6. quig699

    Filling in the blanks

    You are correct, we are looking for a start date, end date and then by the day of week. With the raw data example I provided I have a separate colum for the day of week extracted from the date with =Text(A2, "DDDD"). Easy enough to add to the data. That is all the criteria that we would need...
  7. quig699

    Filling in the blanks

    The reason is because I am trying to get averages for each our on specific days. If I don't have the days/hours where 0 calls were taken the methods I have come across to average divide by the number of hours that show a value. So lets say I have four Saturdays I am looking at and only three...
  8. quig699

    Filling in the blanks

    Hi, I have been researching this and I am either not wording my searches correctly or I have been staring this for far to long. I have a spread sheet that outlines the calls my company gets in hour increments. But it only lists the hours in which we receive calls. Here is an example...
  9. quig699

    Displaying Records Horizontally

    Hi, that is it exactly!!! Any ideas? Thanks!!! Thanks, Amy
  10. quig699

    Displaying Records Horizontally

    Hi, I need to create a report where the records display vertically instead of the traditional horizontal. The query the report needs to be based off of is something like this. Date Sales Orders Calls Rec Calls Abd 4/1 $12 2 13 3 4/2...
  11. quig699

    Adding Data Conditionally

    Thank you all so much!!! Your advice pointed me in the right direction. It is much appreciated!!!! Thanks, Amy
  12. quig699

    Adding Data Conditionally

    Hi, I am looking for a way to take spread sheet and pull totals in a cell if certain conditions are met from the data and I am hitting the wall. My spreadsheet will have the columns of Agent Name, Issue Code and Amount. Assuming the issue codes are letters and I only want a sum of the 'Amount'...
  13. quig699

    Formatting Data in Excel

    Hi, I was looking for an efficient way of convering data in excel that looks like this Bob Smith Calls Talk Work Total ATT AWT Monday 10/21/13 50 16827 7719 24546 337 154 Tuesday 10/22/13 59 18199 9405 27604 308 159 Wednesday10/23/13 57 19500 8206 27706 342 144...
  14. quig699

    Averageing accross tabs in excel.

    I did try that but kept getting error messages. What would the prper syntax be? Thanks, Amy
  15. quig699

    Averageing accross tabs in excel.

    Hi, I am trying to average data over several tabs in Excel 2010 without averging in zeros. I have tabs Monday, Tuesday, Wednesday, etc and need to average mutiple fileds on a totals page. I can average them like this =AVERAGE(Monday!C4,Tuesday!C4,Wednesday!C4,Thursday!C4,Friday!C4) But this...
  16. quig699

    Is VLOOKUP and HLOOKUP the answer?

    Hi, here is the example. Thanks!! Calls Orders Issues James Smith 18 16 30 James Bond 98 54 509 Sally Star 76 33 323...
  17. quig699

    Is VLOOKUP and HLOOKUP the answer?

    Hi, I was looking for a way to pull information from a report that exports to an Excel spreadsheet. The spreadsheet is ugly and was looking for a way to pull just the data I needed. The report has the agent’s name on row 1 column 2. The data I need for the rep is two rows down in column 3. I...
  18. quig699

    Consolidate function

    Hi, I am trying to use the consolidate function in excel to pull data from mutiple identical spreadsheets into a master sheet. If I use the consolidate function it works fine. If I try to make a macro of it I keep getting error messages that there are too many data sources. I am trying to link...
  19. quig699

    Excel and Time

    I have an assignment to find a way to take an employees schedule and see how much time they are logged into our phone system taking calls for every two hour period. I know it sounds simple but our schedules change daily so it is never a constant. I have the representatives start and end time, as...
  20. quig699

    Displaying Network ID in Excel

    Hi, I am looking for a way to display the current user of a spreadsheet in one of the spreadsheet's cells. I have seen some code and I think I understand where to put the code. What I am not sure about is what goes in the cell to have the name appear??? I can get buy with some of this but alot...

Part and Inventory Search

Back
Top