+ Post New Thread
Page 61 of 5613 FirstFirst ... 61 ...
Threads 3001 to 3050 of 280642

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

  1. Formula to identify non alphanumeric characters within a name

    Started by Livelife23‎, 11-16-2023 08:13 AM
    5 Attachment(s)
    • 11
    • 542
    Rick Rothstein
    11-17-2023, 10:51 AM Go to last post

  2. Auto Sort

    Started by Coly88‎, 11-17-2023 10:07 AM
    • 1
    • 137
    oEx
    11-17-2023, 10:29 AM Go to last post

  3. vLookup + Sum function

    Started by Glado‎, 11-17-2023 09:26 AM
    1 Attachment(s)
    • 3
    • 134
    Limor_OP
    11-17-2023, 09:53 AM Go to last post

  4. [SOLVED] If function returns incorrect value

    Started by jankrulak‎, 11-17-2023 08:39 AM
    3 Attachment(s)
    • 2
    • 165
    6StringJazzer
    11-17-2023, 09:09 AM Go to last post

  5. [SOLVED] Formula to take the worst/largest data from the same accounts

    Started by dolphino‎, 11-16-2023 11:05 PM
    column, formula 1 Attachment(s)
    • 6
    • 171
    Sam Capricci
    11-17-2023, 07:45 AM Go to last post

  6. Xlookup advanced

    Started by Michael Lerena‎, 11-17-2023 05:48 AM
    3 Attachment(s)
    • 4
    • 188
    Michael Lerena
    11-17-2023, 07:24 AM Go to last post

  7. [SOLVED] serial payments problem

    Started by forpgroup‎, 11-15-2023 07:35 PM
    2 Attachment(s)
    • 5
    • 239
    AliGW
    11-17-2023, 07:01 AM Go to last post

  8. Optimal Resource Allocation

    Started by Mahmoudelnemr‎, 11-17-2023 03:47 AM
    5 Attachment(s)
    • 6
    • 190
    AliGW
    11-17-2023, 06:18 AM Go to last post

  9. [SOLVED] Zero days formula support required

    Started by jimsenthil‎, 11-17-2023 12:13 AM
    zero days tracker 1 Attachment(s)
    • 4
    • 140
    alansidman
    11-17-2023, 04:12 AM Go to last post

  10. Question Complex auto calculation for sheet metal usage

    Started by JPdt‎, 11-10-2023 06:50 AM
    excel calculation problem, excel calculations
    • 6
    • 375
    JPdt
    11-17-2023, 03:57 AM Go to last post

  11. [SOLVED] Formula to drag and copy to compute Quarterly payments

    Started by samyraj‎, 11-17-2023 03:01 AM
    2 Attachment(s)
    • 4
    • 171
    AliGW
    11-17-2023, 03:33 AM Go to last post

  12. [SOLVED] Help Needed Plz with If + OR + SUMIF

    Started by tRAt‎, 11-17-2023 01:56 AM
    2 Attachment(s)
    • 5
    • 150
    AliGW
    11-17-2023, 02:49 AM Go to last post

  13. If any date in range is between two dates

    Started by Brennen81‎, 11-16-2023 06:01 PM
    1 Attachment(s)
    • 5
    • 181
    MrShorty
    11-16-2023, 08:02 PM Go to last post

  14. Avoiding circular reference - formula based approach vs. VBA?

    Started by skitheast13‎, 11-16-2023 06:09 PM
    1 Attachment(s)
    • 1
    • 159
    alansidman
    11-16-2023, 07:58 PM Go to last post

  15. Looking up values with different rules

    Started by Bobberman1993‎, 11-16-2023 05:58 AM
    1 Attachment(s)
    • 2
    • 127
    TMS
    11-16-2023, 07:15 PM Go to last post

  16. [SOLVED] Looking at two columns Return Unique names in a 3rd column

    Started by asternga‎, 11-16-2023 03:56 PM
    1 Attachment(s)
    • 6
    • 168
    TMS
    11-16-2023, 05:12 PM Go to last post

  17. [SOLVED] Find data left of st, nd, rd, of

    Started by I need excel help‎, 11-15-2023 06:57 PM
    3 Attachment(s)
    • 10
    • 285
    TMS
    11-16-2023, 05:09 PM Go to last post

  18. [SOLVED] NA affecting IF OR formula

    Started by RookA1‎, 11-16-2023 02:51 PM
    2 Attachment(s)
    • 4
    • 143
    Fluff13
    11-16-2023, 03:45 PM Go to last post

  19. Sumifs with several criteria, when I add dates criteria the sum goes to 0

    Started by radoii‎, 11-16-2023 06:15 AM
    dates, sumifs multiple criteria 2 Attachment(s)
    • 14
    • 247
    JohnTopley
    11-16-2023, 03:18 PM Go to last post

  20. [SOLVED] Data from 1 column to "extract" into multiple columns

    Started by dluhut‎, 11-16-2023 02:23 PM
    2 Attachment(s)
    • 0
    • 123
    dluhut
    11-16-2023, 02:23 PM Go to last post

  21. [SOLVED] Formula to Sum Values based on a range on Account Numbers

    Started by Howardc1001‎, 11-15-2023 10:17 PM
    2 Attachment(s)
    • 11
    • 247
    Rick Rothstein
    11-16-2023, 12:46 PM Go to last post

  22. Using a CheckMark On A Sheet That Has A DropDown Feature

    Started by tammy4423‎, 11-16-2023 09:09 AM
    1 Attachment(s)
    • 15
    • 272
    AliGW
    11-16-2023, 11:57 AM Go to last post

  23. [SOLVED] Show an explanation based on the value of a drop-down list.

    Started by NewBee_HS‎, 11-16-2023 08:56 AM
    4 Attachment(s)
    • 8
    • 155
    AliGW
    11-16-2023, 11:19 AM Go to last post

  24. Conditional Formatting

    Started by KristenL‎, 11-16-2023 09:30 AM
    • 2
    • 111
    AliGW
    11-16-2023, 10:00 AM Go to last post

  25. grouping by multiple condition and extract value

    Started by abduldedysubhansyah‎, 11-16-2023 08:51 AM
    formula and functions 1 Attachment(s)
    • 2
    • 157
    HansDouwe
    11-16-2023, 09:40 AM Go to last post

  26. [SOLVED] Holiday Hours Into Days

    Started by DharmeshChauhan‎, 11-16-2023 07:54 AM
    1 Attachment(s)
    • 4
    • 121
    DharmeshChauhan
    11-16-2023, 09:30 AM Go to last post

  27. [SOLVED] AverageIFS to return dynamically across the columns and down the rows

    Started by dluhut‎, 11-15-2023 05:02 PM
    2 Attachment(s)
    • 2
    • 166
    dluhut
    11-16-2023, 09:19 AM Go to last post

  28. Formula Help with Multiple Criteria and two data sets

    Started by Mds83‎, 11-15-2023 05:24 AM
    2 Attachment(s)
    • 6
    • 154
    AliGW
    11-16-2023, 08:00 AM Go to last post

  29. How to count only unique values? I cannot delete duplicates

    Started by sos_xlsx‎, 11-13-2023 01:46 PM
    count unique values 1 Attachment(s)
    • 6
    • 150
    Fluff13
    11-16-2023, 07:49 AM Go to last post

  30. [SOLVED] Help with Data Validation on a cell containing a formula

    Started by suni_eka‎, 11-15-2023 07:31 AM
    data validation, duplicate, error 2 Attachment(s)
    • 6
    • 248
    AliGW
    11-16-2023, 07:28 AM Go to last post

  31. Index/Row/Table error that I cannot figure out.

    Started by offfoo182‎, 11-16-2023 07:23 AM
    • 2
    • 103
    Jacc
    11-16-2023, 07:26 AM Go to last post

  32. [SOLVED] Using countif on a range where numbers in that range have to be altered

    Started by wonderdunder‎, 11-14-2023 11:40 AM
    • 5
    • 125
    AliGW
    11-16-2023, 07:18 AM Go to last post

  33. [SOLVED] Stuck with SUM using Index Match or Vlookup

    Started by mohdabrar‎, 11-16-2023 01:01 AM
    index and match, sum, vlookup 2 Attachment(s)
    • 5
    • 231
    windknife
    11-16-2023, 02:32 AM Go to last post

  34. Talking [SOLVED] Sumrange with criteria using SUMPRODUCT

    Started by Sultan1994‎, 11-15-2023 10:01 PM
    #excel #formula, #sumproduct 2 Attachment(s)
    • 1
    • 162
    6StringJazzer
    11-15-2023, 10:09 PM Go to last post

  35. Find Average If

    Started by lteikwei‎, 11-14-2023 12:51 AM
    1 Attachment(s)
    • 2
    • 147
    lteikwei
    11-15-2023, 09:21 PM Go to last post

  36. Question Working out a % value from a figure and a drop down

    Started by Bdayboom‎, 11-15-2023 01:16 PM
    • 3
    • 213
    6StringJazzer
    11-15-2023, 08:20 PM Go to last post

  37. [SOLVED] Populate 15th of the month -1 each and roll it when the month moves forward

    Started by Megatronv‎, 10-26-2023 06:23 AM
    3 Attachment(s)
    • 39
    • 435
    HansDouwe
    11-15-2023, 04:41 PM Go to last post

  38. Basic filter question (array, include)

    Started by More Cowbell‎, 11-11-2023 05:09 PM
    1 Attachment(s)
    • 7
    • 205
    TMS
    11-15-2023, 03:57 PM Go to last post

  39. Conditional formatting an entire row

    Started by Smashsmash‎, 11-15-2023 03:17 PM
    1 Attachment(s)
    • 5
    • 154
    TMS
    11-15-2023, 03:56 PM Go to last post

  40. [SOLVED] Formula to compute the contributions from Net wages

    Started by samyraj‎, 11-14-2023 04:19 AM
    1 Attachment(s)
    • 5
    • 198
    AliGW
    11-15-2023, 02:02 PM Go to last post

  41. [SOLVED] How do I extract data from a table where it meets certain criteria

    Started by LC77‎, 11-13-2023 01:02 PM
    3 Attachment(s)
    • 4
    • 192
    Estevaoba
    11-15-2023, 01:09 PM Go to last post

  42. [SOLVED] concat dynamic arrays via IDs

    Started by guillaume0314‎, 11-15-2023 10:56 AM
    3 Attachment(s)
    • 5
    • 228
    HansDouwe
    11-15-2023, 12:46 PM Go to last post

  43. [SOLVED] End date based on known start date and hours worked

    Started by RichFer‎, 11-13-2023 10:54 AM
    3 Attachment(s)
    • 18
    • 351
    JohnTopley
    11-15-2023, 12:13 PM Go to last post

  44. Help with data validation

    Started by HGBEALE‎, 11-14-2023 02:37 PM
    • 5
    • 161
    HGBEALE
    11-15-2023, 12:10 PM Go to last post

  45. [SOLVED] Help Request for Two accurate Formulas for a Report of PIVOT Table Data in Excel

    Started by Shahmeer‎, 11-15-2023 07:48 AM
    3 Attachment(s)
    • 25
    • 230
    Shahmeer
    11-15-2023, 12:05 PM Go to last post

  46. I forgot how to rearrange cells

    Started by Cortinarius‎, 11-15-2023 09:20 AM
    4 Attachment(s)
    • 12
    • 201
    Cortinarius
    11-15-2023, 10:42 AM Go to last post

  47. Dependent drop down lists containing unique values

    Started by GLewis14‎, 11-14-2023 04:55 PM
    2 Attachment(s)
    • 4
    • 195
    AliGW
    11-15-2023, 10:05 AM Go to last post

  48. Excel formula to cpoy image

    Started by sunboy‎, 11-15-2023 05:47 AM
    1 Attachment(s)
    • 4
    • 152
    AliGW
    11-15-2023, 09:24 AM Go to last post

  49. [SOLVED] Formula to copy data from one cell if not blank if not return another value

    Started by nsmjc‎, 11-13-2023 01:29 AM
    1 Attachment(s)
    • 5
    • 244
    AliGW
    11-15-2023, 08:11 AM Go to last post

  50. Auto Populate other Cells

    Started by stu_C‎, 11-15-2023 06:18 AM
    1 Attachment(s)
    • 6
    • 124
    Glenn Kennedy
    11-15-2023, 07:14 AM Go to last post
+ Post New Thread
Page 61 of 5613 FirstFirst ... 61 ...

Forum Information and Options

Users Browsing this Forum

There are currently 80 users browsing this forum. (4 members & 76 guests)

  1. AlonCarri,
  2. Gregb11,
  3. krishnapg

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