+ Post New Thread
Page 801 of 5614 FirstFirst ... 801 ...
Threads 40001 to 40050 of 280684

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,904
    VBA Noob
    10-10-2007, 11:36 AM Go to last post

  1. Formatting All Cells Within a Column Based On Day of Week in A1 Row

    Started by denioc‎, 12-30-2019 11:49 AM
    4 Attachment(s)
    • 5
    • 208
    AliGW
    12-30-2019, 12:13 PM Go to last post

  2. [SOLVED] Pull back column heading based on ranking

    Started by CoachK88‎, 12-28-2019 12:27 PM
    4 Attachment(s)
    • 7
    • 373
    CoachK88
    12-30-2019, 12:02 PM Go to last post

  3. [SOLVED] Extract unique sub-list from repeated list based on criteria

    Started by Mohamed Elgammal‎, 12-24-2019 06:34 AM
    6 Attachment(s)
    • 16
    • 715
    AliGW
    12-30-2019, 11:27 AM Go to last post

  4. [SOLVED] Maximum (highest) frequency of cells between two values in row

    Started by litodj‎, 12-29-2019 06:26 PM
    frequency, max 2 Attachment(s)
    • 3
    • 556
    Ron Coderre
    12-30-2019, 11:10 AM Go to last post

  5. [SOLVED] Different date formats in same source

    Started by deemo‎, 12-30-2019 06:13 AM
    3 Attachment(s)
    • 14
    • 473
    deemo
    12-30-2019, 10:16 AM Go to last post

  6. Moved: GOOGLE SHEETS: countif with dynamic range

    Started by Headburst‎, 12-30-2019 06:37 AM
    •  
    •  

  7. Serial numbering and auto number change when date changes.

    Started by mss31‎, 12-27-2019 09:21 AM
    • 3
    • 326
    AliGW
    12-30-2019, 08:39 AM Go to last post

  8. [SOLVED] Formula to calculate Rank based on number of failures

    Started by avijit74‎, 12-30-2019 06:14 AM
    2 Attachment(s)
    • 3
    • 354
    Ace_XL
    12-30-2019, 08:01 AM Go to last post

  9. Converting an index match formula from .Numbers to Excel

    Started by Bobbo Jones‎, 12-29-2019 10:44 PM
    2 Attachment(s)
    • 9
    • 334
    Sam Capricci
    12-30-2019, 07:50 AM Go to last post

  10. How to Count Periods of Activity

    Started by andyporter1975‎, 07-11-2019 05:39 AM
    1 Attachment(s)
    • 5
    • 373
    andyporter1975
    12-30-2019, 07:18 AM Go to last post

  11. [SOLVED] Help fix a formula to return unmatched values

    Started by FierceExcel‎, 12-26-2019 03:03 AM
    5 Attachment(s)
    • 7
    • 1,184
    FierceExcel
    12-30-2019, 04:55 AM Go to last post

  12. [SOLVED] Suppress error for cell that should be blank

    Started by acmac1962‎, 12-30-2019 01:34 AM
    1 Attachment(s)
    • 3
    • 293
    FDibbins
    12-30-2019, 01:58 AM Go to last post

  13. Moved: Insert automatic row based on text

    Started by wirata‎, 12-29-2019 10:28 PM
    •  
    •  

  14. 2 planar angles from the origin

    Started by masterjebbi‎, 12-29-2019 08:49 PM
    • 6
    • 444
    masterjebbi
    12-29-2019, 11:17 PM Go to last post

  15. IF - AND not working properly?

    Started by bward138‎, 12-29-2019 07:57 PM
    2 Attachment(s)
    • 1
    • 752
    jeffreybrown
    12-29-2019, 08:14 PM Go to last post

  16. Split Last word into separate column.

    Started by ankit_9090‎, 12-28-2019 04:09 AM
    • 5
    • 1,567
    AliGW
    12-29-2019, 06:52 PM Go to last post

  17. Obtain the latest date using criteria from another column

    Started by johnlee60‎, 12-29-2019 08:21 AM
    5 Attachment(s)
    • 23
    • 535
    Bob Phillips
    12-29-2019, 06:47 PM Go to last post

  18. [SOLVED] Data Sort From Copy Paste Data in Separate Column

    Started by rif‎, 12-29-2019 02:54 PM
    data sort formula, glenn kennedy 1 Attachment(s)
    • 4
    • 309
    JLGWhiz
    12-29-2019, 05:10 PM Go to last post

  19. [SOLVED] Finding Missing Number from Sequence

    Started by Bwhit86‎, 12-29-2019 10:39 AM
    1 Attachment(s)
    • 4
    • 1,480
    Glenn Kennedy
    12-29-2019, 02:07 PM Go to last post

  20. [SOLVED] index and aggreate formula to extract first / second getting NUM error

    Started by JEAN1972‎, 12-28-2019 03:45 PM
    3 Attachment(s)
    • 11
    • 667
    JEAN1972
    12-29-2019, 01:52 PM Go to last post

  21. Question formula to automatically print the number of skids based of the total

    Started by gweitzel81‎, 12-29-2019 11:48 AM
    1 Attachment(s)
    • 5
    • 454
    AliGW
    12-29-2019, 01:15 PM Go to last post

  22. How to split multiple rows within a cell to multiple cells

    Started by mi2slick‎, 12-28-2019 08:01 PM
    5 Attachment(s)
    • 12
    • 868
    AliGW
    12-29-2019, 01:00 PM Go to last post

  23. [SOLVED] Compare cells with words

    Started by pansovic‎, 12-29-2019 12:36 PM
    1 Attachment(s)
    • 5
    • 277
    Fluff13
    12-29-2019, 12:50 PM Go to last post

  24. Question [SOLVED] How to use the same formula for all cell (excel file is attached).

    Started by aybid‎, 12-29-2019 09:36 AM
    4 Attachment(s)
    • 9
    • 455
    Gregb11
    12-29-2019, 10:46 AM Go to last post

  25. Picklist Query - relationship with other cells

    Started by SLAMExcel‎, 12-24-2019 08:20 AM
    1 Attachment(s)
    • 2
    • 277
    JeteMc
    12-29-2019, 10:16 AM Go to last post

  26. Excel functions and how to

    Started by mi2slick‎, 12-29-2019 10:03 AM
    1 Attachment(s)
    • 1
    • 221
    Pepe Le Mokko
    12-29-2019, 10:06 AM Go to last post

  27. [SOLVED] COUNTIF() help I do not know how to make it working

    Started by MaxDp2020‎, 12-26-2019 12:13 PM
    8 Attachment(s)
    • 19
    • 790
    Fluff13
    12-29-2019, 08:56 AM Go to last post

  28. Post LOOKUP and Filter Based on Combined Condition

    Started by Steave‎, 12-10-2019 06:23 AM
    functions and formula 28 Attachment(s)
    • 66
    • 1,236
    Glenn Kennedy
    12-29-2019, 05:16 AM Go to last post

  29. [SOLVED] conditional formatting based on system time

    Started by mtouhig‎, 12-28-2019 11:13 AM
    1 Attachment(s)
    • 3
    • 270
    saravnepali
    12-29-2019, 03:36 AM Go to last post

  30. Find a value in a column based on a pre defined set of values

    Started by bsrivatsa‎, 12-28-2019 02:24 PM
    1 Attachment(s)
    • 5
    • 327
    6StringJazzer
    12-29-2019, 01:40 AM Go to last post

  31. [SOLVED] Selecting multiple cells, and adding the values automatically

    Started by nkitchen31‎, 12-28-2019 04:27 PM
    1 Attachment(s)
    • 6
    • 301
    JLGWhiz
    12-28-2019, 11:23 PM Go to last post

  32. Excel formula for timekeeping

    Started by hbroson‎, 07-12-2017 03:41 AM
    2 Attachment(s)
    • 2
    • 1,688
    hiro22
    12-28-2019, 11:10 PM Go to last post

  33. If statement using a list and displaying data from column in second sheet

    Started by jimigisme‎, 12-28-2019 05:01 PM
    • 2
    • 262
    saravnepali
    12-28-2019, 07:47 PM Go to last post

  34. if vlookup formula

    Started by mi2slick‎, 12-28-2019 12:10 PM
    2 Attachment(s)
    • 4
    • 318
    AliGW
    12-28-2019, 07:07 PM Go to last post

  35. [SOLVED] Adding to existing formula

    Started by J.McQ‎, 12-27-2019 08:36 AM
    1 Attachment(s)
    • 11
    • 592
    J.McQ
    12-28-2019, 12:55 PM Go to last post

  36. Angry [SOLVED] Get date/date with text, from the set range

    Started by przeziom83‎, 12-25-2019 05:27 PM
    countif, date, vlookup 2 Attachment(s)
    • 2
    • 448
    przeziom83
    12-28-2019, 11:49 AM Go to last post

  37. SUM IF not working as expected

    Started by koalamotorsport‎, 12-27-2019 09:56 PM
    • 5
    • 554
    AliGW
    12-28-2019, 11:42 AM Go to last post

  38. [SOLVED] data validation with multiple lists

    Started by JPRICH16‎, 12-27-2019 03:29 PM
    2 Attachment(s)
    • 7
    • 684
    AliGW
    12-28-2019, 11:18 AM Go to last post

  39. [SOLVED] Countif with Index and Match formula not working

    Started by katieshields‎, 12-28-2019 08:42 AM
    3 Attachment(s)
    • 9
    • 41,810
    katieshields
    12-28-2019, 10:41 AM Go to last post

  40. two cirteria sumifs formula problems

    Started by chriswrcg‎, 12-28-2019 10:20 AM
    1 Attachment(s)
    • 3
    • 273
    jeffreybrown
    12-28-2019, 10:34 AM Go to last post

  41. [SOLVED] Excel Function to disable printing

    Started by meetgilbert‎, 12-28-2019 09:59 AM
    • 3
    • 4,784
    meetgilbert
    12-28-2019, 10:30 AM Go to last post

  42. [SOLVED] Dynamically select tabbed form range.

    Started by HillTJ‎, 12-04-2019 10:51 PM
    8 Attachment(s)
    • 32
    • 977
    JeteMc
    12-28-2019, 10:23 AM Go to last post

  43. Placing information on same line when key is the same

    Started by pansovic‎, 12-26-2019 09:34 PM
    1 Attachment(s)
    • 6
    • 329
    pansovic
    12-28-2019, 08:59 AM Go to last post

  44. [SOLVED] Highlight Rules Based on Selection in Cell

    Started by crazyforexcel‎, 12-28-2019 07:43 AM
    1 Attachment(s)
    • 2
    • 318
    crazyforexcel
    12-28-2019, 08:14 AM Go to last post

  45. [SOLVED] Fill Range Based on Cell Selection

    Started by crazyforexcel‎, 12-28-2019 07:05 AM
    1 Attachment(s)
    • 5
    • 298
    Glenn Kennedy
    12-28-2019, 07:39 AM Go to last post

  46. Question [SOLVED] Show a negative number

    Started by toddp2‎, 12-23-2019 04:01 PM
    1 Attachment(s)
    • 4
    • 1,160
    toddp2
    12-28-2019, 07:21 AM Go to last post

  47. Data from next tab

    Started by goodboy‎, 12-28-2019 06:50 AM
    1 Attachment(s)
    • 1
    • 248
    boopathiraja
    12-28-2019, 06:59 AM Go to last post

  48. How do sum up multiple items for the same field using cell references in GETPIVOTDATA

    Started by rahul83‎, 12-28-2019 05:30 AM
    getpivotdata with sum 1 Attachment(s)
    • 1
    • 1,702
    Pepe Le Mokko
    12-28-2019, 06:41 AM Go to last post

  49. [SOLVED] how to fix hyphen delimited numbers which became in date-month format

    Started by jilaba‎, 12-28-2019 05:32 AM
    1 Attachment(s)
    • 2
    • 215
    jilaba
    12-28-2019, 06:15 AM Go to last post

  50. [SOLVED] Fuel tank consumption

    Started by nickpas‎, 12-27-2019 01:42 PM
    2 Attachment(s)
    • 7
    • 573
    samba_ravi
    12-28-2019, 04:53 AM Go to last post
+ Post New Thread
Page 801 of 5614 FirstFirst ... 801 ...

Forum Information and Options

Users Browsing this Forum

There are currently 67 users browsing this forum. (4 members & 63 guests)

  1. cwwazy,
  2. etaf,
  3. Phuocam

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