YB
BannerBanner

Any Excel wizards in the house today ?

Author
Dundee_Stokie
Senior Member
  • Total Posts : 148
  • Reward points: 2747
  • Joined: 2006/07/03 00:25:32
  • Status: offline
2008/05/21 15:38:36 (permalink)
0

Any Excel wizards in the house today ?

How do I enter a number in a cell that will return a list of records that all use that same number ?

E.G.

1427 - Quality Control - 258
1427 - Business Development - 487
1427 - Customer Service - 312
1427 - Supply Chain - 245
1428 - Human Resources - 687
1428 - Key Accounts - 214
1428 - Finance - 141
1429 - Converting - 878
1429 - Process Management - 336
1429 - Waste Management - 995

I want the formula to return whats to do with say 1427 without any of 1428 or 1429 coming up. Anyone any good with formulae ? A simple VLOOKUP here will only return the first line "Quality Control - 258"

"And sometimes you close your eyes
and see the place where you used to live
When you were young....."
#1

3 Replies Related Threads

    Osagi
    Moderator
    • Total Posts : 15174
    • Reward points: 12834
    • Joined: 2001/10/28 19:28:40
    • Location: 'Nam
    • Status: offline
    RE: Any Excel wizards in the house today ? 2008/05/21 15:56:35 (permalink)
    0
    Click on the first row and select Data > Filter > AutoFilter.

    You're spread sheet will then be equipped with a number of drop down boxes, which you can use to filter relevant entries.

    Osagi
    #2
    sl
    Pro-Member
    • Total Posts : 7633
    • Reward points: 11199
    • Joined: 2005/04/25 23:57:48
    • Status: offline
    RE: Any Excel wizards in the house today ? 2008/05/21 16:28:42 (permalink)
    0
    Sorry to hijack this thread.

    Does anybody know how to find the total of all the numbers in the column. I need to add them all up.

    thanks
    #3
    Osagi
    Moderator
    • Total Posts : 15174
    • Reward points: 12834
    • Joined: 2001/10/28 19:28:40
    • Location: 'Nam
    • Status: offline
    RE: Any Excel wizards in the house today ? 2008/05/21 16:43:43 (permalink)
    0

    ORIGINAL: sl

    Sorry to hijack this thread.

    Does anybody know how to find the total of all the numbers in the column. I need to add them all up.

    thanks


    Click on the next empty cell directly under the column of values you want to sum up and then click on the 'sigma' button on the tool bar, looks like this;



    Osagi
    #4
    Jump to:
    ©2018 All content is copyright of MuscleTalk.co.uk and its use elsewhere is prohibited.
    (posting guidelines | privacy | advertise | earnings disclaimer | contact us | supported by)
    © 2018 APG vNext Commercial Version 5.5