Search:

Type: Posts; User: MOSTATE; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    17
    Views
    283

    That is so much easier and more accurate...thanks...

    That is so much easier and more accurate...thanks so much!
  2. Replies
    17
    Views
    283

    Thanks so much for the ISTEXT tip, it worked...

    Thanks so much for the ISTEXT tip, it worked great. The Pivot Table still would not group on hours for me so I used the VLOOKUP to assign hour values then used those in the pivot table. I have...
  3. Replies
    17
    Views
    283

    Thanks to all the replies. When I try the Group...

    Thanks to all the replies. When I try the Group option on the Pivot table I get an error that states I can't group. I am attaching a more thorough example of what they are working with. Thanks!
  4. Replies
    17
    Views
    283

    It is based on 24 hour day...see sample data...

    It is based on 24 hour day...see sample data below:
    05-01-2015 12:53
    05-01-2015 13:07
    05-01-2015 13:26
  5. Replies
    17
    Views
    283

    Thanks for the quick replies, they want to know...

    Thanks for the quick replies, they want to know the total transactions per hour per day.
  6. Replies
    17
    Views
    283

    Sorry the sample didn't paste the first time,...

    Sorry the sample didn't paste the first time, here it is
    Date Time (Local)
    05-01-2015 07:04
    05-01-2015 07:10
    05-01-2015 08:21
    05-01-2015 08:37
    05-01-2015 08:47
    05-01-2015 08:52
  7. Replies
    17
    Views
    283

    Count Time Entries

    Hello,
    I have a user that enters in a date in Column A and a time in Column B. They want to be able to count transactions per hour, per day. The worksheet looks like the sample below:


    Date...
  8. Replies
    7
    Views
    531

    That is Wonderful!...Thanks so much!!:D

    That is Wonderful!...Thanks so much!!:D
  9. Replies
    7
    Views
    531

    Yes, I did that and it works I just thought there...

    Yes, I did that and it works I just thought there might be another way. I could create a macro for the Find and Replace piece but just wondered if there was an easier way. Thanks so much for your...
  10. Replies
    7
    Views
    531

    Excel Formatting

    Hello All,
    I have an Excel worksheet that has a column of data with various data entries for phone numbers. Some of the users have entered in the data as (123) 456-7890 while other have entered...
  11. Thanks Steve, I think that's the solution I will...

    Thanks Steve, I think that's the solution I will go with!
  12. That works great for the Axes but not the data...

    That works great for the Axes but not the data table. Is there a way to format the number format to % in the data table?
  13. Yes, they are linked to the source. So, would...

    Yes, they are linked to the source. So, would the only resolution be to break the link? I would like to keep the link between the 2 workbooks if possible...
  14. The entire worksheet was copied to another...

    The entire worksheet was copied to another workbook. Thanks for the response!
  15. When Copying Worksheet to another Workbook Percentages convert to Decimals

    Hello All,
    I have a worksheet that contains charts I copied to a different workbook. When the source workbook is open the Percentage formatting on the charts display properly, when I close the...
  16. Replies
    11
    Views
    509

    Works Great...Thanks so much!

    Works Great...Thanks so much!
  17. Replies
    11
    Views
    509

    I receive a syntax error on the following line of...

    I receive a syntax error on the following line of code
    zAddToName = Format(Month([D4],"##") & Format(Day([D4],"##") & Format(Year([D4],"##")

    The date in D4 is formatted as mm-dd-yy, if that...
  18. Replies
    11
    Views
    509

    This works great, thanks so much. How would I...

    This works great, thanks so much. How would I change the code if I wanted to copy the TestData worksheet with the same naming convention of NewData_090214 (NewData plus the contents of D4 which will...
  19. Replies
    11
    Views
    509

    No, TestData will not be the only worksheet.

    No, TestData will not be the only worksheet.
  20. Replies
    11
    Views
    509

    Name Worksheet based on Cell entry

    I am trying to create a macro that will copy an existing workbook and then rename that copy with Text joined with the contents of a cell address which will be a date. For example my worksheet I want...
  21. Replies
    13
    Views
    1,676

    No, there are about 10 categories and 10 percent...

    No, there are about 10 categories and 10 percent fields along with other fields. I would like for the query to create a field based on the criteria in the RPTGCat fields and group all the % for...
  22. Replies
    13
    Views
    1,676

    I am attaching a workbook that shows a sample of...

    I am attaching a workbook that shows a sample of what is actually entered in the database on the first worksheet and how they want the report to look on the second worksheet. I don't have access to...
  23. Replies
    13
    Views
    1,676

    Yes, but ABC and DEF are separate fields with the...

    Yes, but ABC and DEF are separate fields with the percents being the records.
    ABC DEF
    0.5 1.2
    1.1 0.75
  24. Replies
    13
    Views
    1,676

    Based on the original data there will be several...

    Based on the original data there will be several records that have ABC as the Category with a percent, some may have the same percent. I would like a field created based on the Category data i.e.,...
  25. Replies
    13
    Views
    1,676

    The original source table will stay intact as I...

    The original source table will stay intact as I would like the new object, table or query, to be based on the query results so that each like Category can be summarized with just the CategoryName and...
Results 1 to 25 of 105
Page 1 of 5 1 2 3 4