General help please.
General help please.
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: General help please.

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi, I have to sort some data on a spreadsheet with the following column headers;

    Location,Pallet No,Description,Product ID,Qty,Price,Product Code,Comments,Date Returned.

    Many of the items repeat but in different columns, i.e. same product code/description etc but different date, is there a way to filter these please?

    I also need to be able to show on a seperate worksheet three different price %'s depending on the time the stock has been in storage. Some of the stock will also be out of date and i also need to show this on the sheet, is it possible to filter or search dates in some way ?

    I also need to display items worth less then 10.00 after these have been calculated.

    I'm also not allowed to use any macros,

    any ideas or advice would be welcome.

    Thanks.

    [ This Message was edited by: Anx on 2002-04-08 04:16 ]

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Anx

    Sounds like a good job for Excels feature(s)

    1. Data>Filter>Auto Filter
    2. Data>Filter>Advanced Filter
    3. Data>Pivot Table



  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, i'll give it a look.

    Anx

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi, what does advanced filter do please? it doesn't appear to have any effect.

    I've also looked at Pivot Tables but don't really understand their purpose or how to use it to achieve what I want.

    Thanks

    Anx

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ...also how can I create a formula that will display e.g. dates that are over 6 months old onto another sheet please ?

    Thanks again

    [ This Message was edited by: Anx on 2002-04-08 05:36 ]

  6. #6
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-08 05:24, Anx wrote:
    Hi, what does advanced filter do please? it doesn't appear to have any effect.

    I've also looked at Pivot Tables but don't really understand their purpose or how to use it to achieve what I want.

    Thanks

    Anx
    Hi Anx,

    Advanced Filter is an underused feature, in my opinion. It is very powerful when used correctly, but is definitely tricky to understand at first. Check the Excel help and it may get you started.

    Same with Pivot Tables.

    http://www.cpearson.com/excel/pivots.htm

    is another introduction to pivot tables.

    Sorry, I cannot find a good link to advanced filters. David McRitchie's site might help (address not known off hand).

    Will edit post if I find an advanced filter link.

    Bye,
    Jay

  7. #7
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ~Anne Troy

  8. #8
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Excellent, thanks very much for your help.

    Anx

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com