+ Reply to Thread
Results 1 to 12 of 12

To What Purpose

  1. #1
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    To What Purpose

    Just a quick poll on what people think are the top 3 real life specific functionalities that appear over and over in OP Questions.
    I'd say #1 is Time sheets
    Another I see over and over (although it might not make the top 3) is Golf handicapping. Maybe if we group that together as Sports tracking.
    What do you think?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,400

    Re: To What Purpose

    Golf handicapping is quite specific and we've seen a few, but I wouldn't say it's a top 3.

    One of the top three I would say is producing a list of values from an array - the question about why VLOOKUP only pulls the first value it finds is very frequent.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: To What Purpose

    Ali,
    I would agree. People trying to pull multiple duplicates, either SKUs or Invoices for example, from their data is a huge one.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: To What Purpose

    Hide and unhide rows/columns based on whatever ...
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: To What Purpose

    Send emails, maybe?

  6. #6
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: To What Purpose

    and then there's always the gambling posts (lottery, horse racing, any sort of system to beat the system)

  7. #7
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: To What Purpose

    1. Vloookup / Index Match with several criteria
    2. Date/Time Calculations
    3. Outlook Email
    4. Coloring Cells / Conditional Formatting
    5. Search for duplicates

  8. #8
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: To What Purpose

    Anecdotal but I see quite a few of...
    1. Extract Unique values from list
    2. Web scraping (especially Forex and Ticker info)
    3. Date/Time value conversion/calculation
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  9. #9
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: To What Purpose

    Lookup multiple criteria
    Unpivot data
    Calculate the speed of light in furlongs per fortnight.


    One of the above is a red herring...
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,400

    Re: To What Purpose

    Sum or count with conditions - it's staggering how many people do not know that SUMIF(S) and COUNTIF(S) exist.

  11. #11
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: To What Purpose

    Trivia point: Do you know that furlongs per fortnight is equivalent to cm per minute (to 2 decimal places)?

    So the speed of light in furlongs per fortnight is the same as the speed of light in cm/min.

  12. #12
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: To What Purpose

    How about Rotas--Work Schedules.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. For those who still need a purpose in life
    By MrShorty in forum The Water Cooler
    Replies: 7
    Last Post: 10-24-2014, 12:17 PM
  2. Introduce myself and purpose here
    By starryjazz in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 05-01-2014, 04:40 AM
  3. Value or purpose of ChDir
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-01-2010, 11:56 PM
  4. What is the purpose of the .lst file
    By mkinsella in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-20-2009, 07:53 AM
  5. What is the purpose of IF
    By excel_beginner in forum Excel General
    Replies: 3
    Last Post: 09-18-2006, 06:49 PM
  6. explain purpose of {}
    By cereldine in forum Excel General
    Replies: 1
    Last Post: 04-04-2006, 08:10 AM
  7. Purpose of the Microsoft MVP
    By ExcelMonkey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-19-2005, 08:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1