+ Post New Thread
Page 1601 of 5615 FirstFirst ... 1601 ...
Threads 80001 to 80050 of 280706

Forum: Excel Formulas & Functions

Post and discuss Excel Formulas & functions.

  1. Thumbs up Sticky Thread Sticky: Excel Useful Links (see last post for new additions)

    Started by gopi_excel‎, 12-22-2006 08:14 PM
    • 19
    • 156,907
    VBA Noob
    10-10-2007, 11:36 AM Go to last post

  1. Dissecting an Array Formula

    Started by bsm726‎, 09-08-2016 12:18 PM
    array formula, frequency
    • 5
    • 733
    joeu2004
    09-08-2016, 03:55 PM Go to last post

  2. Question Drop Down List Using Vlookup

    Started by Jess709‎, 09-07-2016 06:02 PM
    drop down, vlookup 1 Attachment(s)
    • 6
    • 1,136
    Jess709
    09-08-2016, 03:42 PM Go to last post

  3. Question Duplicate Worksheet but still reference it in new sheet

    Started by 1Stacy‎, 09-08-2016 03:07 PM
    1 Attachment(s)
    • 0
    • 302
    1Stacy
    09-08-2016, 03:07 PM Go to last post

  4. populate from one worksheet to another

    Started by leemc1985‎, 09-08-2016 10:47 AM
    • 2
    • 391
    dluhut
    09-08-2016, 02:55 PM Go to last post

  5. [SOLVED] concentration formula calculation

    Started by mazan2010‎, 09-07-2016 02:56 PM
    1 Attachment(s)
    • 8
    • 5,402
    mazan2010
    09-08-2016, 02:45 PM Go to last post

  6. Question [SOLVED] Find out the year

    Started by meus‎, 08-30-2016 03:20 AM
    1 Attachment(s)
    • 6
    • 425
    Tony Valko
    09-08-2016, 02:39 PM Go to last post

  7. [SOLVED] Conditional formatting based on multiple criterias

    Started by anghicole‎, 09-08-2016 02:03 PM
    2 Attachment(s)
    • 3
    • 540
    JieJenn
    09-08-2016, 02:36 PM Go to last post

  8. Need to update spreadsheet on local machine via links to a document in a OneDrive folder.

    Started by rdomingue‎, 09-08-2016 02:21 PM
    edit links, excel, onedrive
    • 0
    • 662
    rdomingue
    09-08-2016, 02:21 PM Go to last post

  9. Need formula to return certain cell based on the current date

    Started by Meggo12‎, 09-08-2016 01:09 PM
    1 Attachment(s)
    • 6
    • 533
    AlKey
    09-08-2016, 01:46 PM Go to last post

  10. Formula to multiply value in one column by amount dependent on value from another column

    Started by kornstalker‎, 09-08-2016 12:45 PM
    • 3
    • 413
    Glenn Kennedy
    09-08-2016, 01:37 PM Go to last post

  11. [SOLVED] Leaving cell blank with formula in it

    Started by adrenom‎, 09-08-2016 01:20 PM
    • 1
    • 332
    Glenn Kennedy
    09-08-2016, 01:27 PM Go to last post

  12. Count specific character in range if cell is not colored

    Started by jh51745‎, 09-08-2016 09:21 AM
    • 2
    • 410
    jh51745
    09-08-2016, 01:21 PM Go to last post

  13. How do I transfer select info from an old excel sheet into a new simple table?

    Started by kellykellz‎, 09-08-2016 12:54 PM
    • 1
    • 466
    Pete_UK
    09-08-2016, 01:08 PM Go to last post

  14. [SOLVED] Complex count of min and max matches,checking data against multiple rows

    Started by sans‎, 08-17-2016 02:26 PM
    14 Attachment(s)
    • 56
    • 2,672
    sans
    09-08-2016, 12:31 PM Go to last post

  15. [SOLVED] IFAND Function with positive and negative conditions

    Started by jeptik‎, 09-08-2016 11:31 AM
    • 2
    • 583
    jeptik
    09-08-2016, 12:30 PM Go to last post

  16. Have excel auto populate day of week #/name when month and year are entered

    Started by anthony.webb‎, 09-08-2016 12:07 PM
    • 2
    • 699
    anthony.webb
    09-08-2016, 12:23 PM Go to last post

  17. Summing a list based on last 10 workdays from a rolling 30 day report.

    Started by Bulvers‎, 09-08-2016 09:20 AM
    4 Attachment(s)
    • 24
    • 923
    Glenn Kennedy
    09-08-2016, 12:15 PM Go to last post

  18. [SOLVED] Extracting prices from a string of text

    Started by loll_l‎, 09-07-2016 06:47 PM
    • 13
    • 687
    FlameRetired
    09-08-2016, 11:17 AM Go to last post

  19. [SOLVED] Add up total amount of occurrences of zero per month

    Started by jonodillieono‎, 09-08-2016 09:30 AM
    2 Attachment(s)
    • 1
    • 438
    Kaper
    09-08-2016, 11:06 AM Go to last post

  20. how to delete duplicate values from a range of cell in excel 2007

    Started by Aslam4015‎, 09-02-2016 12:30 AM
    2 Attachment(s)
    • 5
    • 528
    JeteMc
    09-08-2016, 10:42 AM Go to last post

  21. VLOOKUP not working

    Started by chilledmalt‎, 09-08-2016 06:14 AM
    4 Attachment(s)
    • 13
    • 650
    chilledmalt
    09-08-2016, 10:26 AM Go to last post

  22. Sum function

    Started by ajl‎, 09-08-2016 09:22 AM
    • 1
    • 301
    Olly
    09-08-2016, 10:12 AM Go to last post

  23. Question Calculating years of membership based month they joined

    Started by ChelleMyBelle‎, 09-07-2016 02:33 PM
    • 4
    • 510
    6StringJazzer
    09-08-2016, 09:31 AM Go to last post

  24. [SOLVED] Monthly schedule sum letter values

    Started by mamm0th‎, 09-08-2016 07:06 AM
    #count, #sum, #vlookup 1 Attachment(s)
    • 8
    • 620
    Jonmo1
    09-08-2016, 08:09 AM Go to last post

  25. Extrating Data From One WS based on Criteria

    Started by Kyhosa‎, 07-26-2016 09:14 AM
    2 Attachment(s)
    • 7
    • 561
    Kyhosa
    09-08-2016, 07:53 AM Go to last post

  26. Combine Vlookup different tables (sheets)

    Started by sab128‎, 09-07-2016 08:35 AM
    2 Attachment(s)
    • 5
    • 632
    southward
    09-08-2016, 07:04 AM Go to last post

  27. [SOLVED] how to get the weighted score out of the target score

    Started by Mharvz‎, 09-08-2016 03:03 AM
    1 Attachment(s)
    • 10
    • 795
    Mharvz
    09-08-2016, 05:49 AM Go to last post

  28. [SOLVED] VLOOKUP formula

    Started by zaahideen‎, 09-07-2016 11:28 PM
    populate, total, vlookup 1 Attachment(s)
    • 3
    • 667
    zaahideen
    09-08-2016, 05:45 AM Go to last post

  29. Subtracting Duplicates

    Started by kiminai‎, 09-07-2016 06:43 PM
    1 Attachment(s)
    • 2
    • 633
    Glenn Kennedy
    09-08-2016, 05:10 AM Go to last post

  30. [SOLVED] Counting list of specific texts inside the cells

    Started by Sekars‎, 09-07-2016 03:19 AM
    1 Attachment(s)
    • 6
    • 581
    Sekars
    09-08-2016, 04:08 AM Go to last post

  31. Pivot not showing %

    Started by Keshypops‎, 09-08-2016 03:36 AM
    1 Attachment(s)
    • 1
    • 289
    xlnitwit
    09-08-2016, 03:51 AM Go to last post

  32. [SOLVED] Formula like MAX to find the highest value (contains text and numbers)

    Started by Nero_slk‎, 09-05-2016 02:45 AM
    4 Attachment(s)
    • 24
    • 1,002
    Nero_slk
    09-08-2016, 03:50 AM Go to last post

  33. delete empty rows

    Started by naeemdotcom‎, 09-08-2016 02:38 AM
    • 1
    • 346
    David A Coop
    09-08-2016, 03:35 AM Go to last post

  34. [SOLVED] Formula to phase sales based on start week

    Started by shrijan‎, 09-08-2016 12:01 AM
    3 Attachment(s)
    • 6
    • 563
    mangesh.mehendale
    09-08-2016, 03:21 AM Go to last post

  35. [SOLVED] "AND" in a formula?

    Started by AdamW328‎, 06-11-2016 01:26 PM
    • 3
    • 486
    zbor
    09-08-2016, 02:46 AM Go to last post

  36. [SOLVED] Lookup formla to allocate a calendar date to a week based on a table

    Started by shrijan‎, 09-07-2016 10:19 PM
    1 Attachment(s)
    • 3
    • 566
    azumi
    09-08-2016, 02:42 AM Go to last post

  37. [SOLVED] Adding totals from daily receipts.

    Started by marcel12‎, 09-08-2016 12:10 AM
    2 Attachment(s)
    • 2
    • 342
    marcel12
    09-08-2016, 01:08 AM Go to last post

  38. Combining multiple excel files

    Started by Rajendra_kodavaty‎, 09-06-2016 04:04 AM
    3 Attachment(s)
    • 2
    • 393
    Rajendra_kodavaty
    09-08-2016, 12:00 AM Go to last post

  39. Error function not working when i drag cells across

    Started by samuel kelly‎, 09-07-2016 11:36 PM
    1 Attachment(s)
    • 1
    • 367
    samuel kelly
    09-07-2016, 11:43 PM Go to last post

  40. How to use LEFT formula with currency?

    Started by unley‎, 09-07-2016 08:59 PM
    1 Attachment(s)
    • 4
    • 368
    unley
    09-07-2016, 09:45 PM Go to last post

  41. IF Command comparing multiple cells

    Started by Bill6981‎, 09-06-2016 10:32 PM
    1 Attachment(s)
    • 7
    • 448
    JeteMc
    09-07-2016, 09:33 PM Go to last post

  42. Return Peak Time Period

    Started by whiskeybravo91‎, 09-06-2016 11:47 AM
    2 Attachment(s)
    • 9
    • 870
    Phuocam
    09-07-2016, 08:26 PM Go to last post

  43. [SOLVED] Arranging two column's based on one column's details

    Started by papusale‎, 09-07-2016 12:44 PM
    arrange and sort data, duplicate cell contents 3 Attachment(s)
    • 11
    • 598
    JeteMc
    09-07-2016, 07:05 PM Go to last post

  44. Display summary of last 10 items on tab

    Started by snuffnchess‎, 09-07-2016 04:42 PM
    2 Attachment(s)
    • 5
    • 355
    mikeTRON
    09-07-2016, 05:56 PM Go to last post

  45. [SOLVED] Unable to identify formula error

    Started by chrismc94‎, 09-06-2016 04:53 PM
    • 6
    • 517
    JeteMc
    09-07-2016, 05:08 PM Go to last post

  46. [SOLVED] Need a formula for SUM from ranges based on date and approval flag

    Started by CratylusATL‎, 09-07-2016 02:20 PM
    5 Attachment(s)
    • 5
    • 454
    mikeTRON
    09-07-2016, 03:55 PM Go to last post

  47. [SOLVED] Consolidating identical data to new sheet and showing different values attached

    Started by dlevisay‎, 09-07-2016 02:18 PM
    2 Attachment(s)
    • 2
    • 328
    dlevisay
    09-07-2016, 03:39 PM Go to last post

  48. Inserting rows without affecting top rows in each page

    Started by naga‎, 09-07-2016 02:06 PM
    2 Attachment(s)
    • 3
    • 367
    Olly
    09-07-2016, 03:38 PM Go to last post

  49. Header Setup

    Started by naga‎, 09-07-2016 01:44 PM
    • 1
    • 278
    6StringJazzer
    09-07-2016, 02:47 PM Go to last post

  50. combine row to paragraph

    Started by donglimyong‎, 09-03-2016 09:58 AM
    • 1
    • 474
    EchoPassenger
    09-07-2016, 02:18 PM Go to last post
+ Post New Thread
Page 1601 of 5615 FirstFirst ... 1601 ...

Forum Information and Options

Users Browsing this Forum

There are currently 79 users browsing this forum. (7 members & 72 guests)

  1. FireDept,
  2. FrancisM2411,
  3. MubiJazz,
  4. Pete_UK,
  5. Phuocam,
  6. rav43k,
  7. windknife

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1