+ Post New Thread
Page 201 of 5613 FirstFirst ... 201 ...
Threads 10001 to 10050 of 280623

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

  1. [SOLVED] Using IF AND function within a UNIQUE

    Started by CCoups‎, 12-12-2022 01:31 PM
    if and, textjoin, unique 1 Attachment(s)
    • 5
    • 256
    Fluff13
    12-12-2022, 02:21 PM Go to last post

  2. [SOLVED] Using string in table to decide if a value should be taken from table header

    Started by ExcelDropper‎, 12-12-2022 08:42 AM
    2 Attachment(s)
    • 3
    • 211
    Glenn Kennedy
    12-12-2022, 12:44 PM Go to last post

  3. Summary Pivot Table from More Extensive Data

    Started by TeresaBarney‎, 12-08-2022 11:47 AM
    6 Attachment(s)
    • 7
    • 493
    Glenn Kennedy
    12-12-2022, 12:39 PM Go to last post

  4. [SOLVED] Looking up two cells to find result in another cell - Match and Index?

    Started by kayjay46‎, 12-08-2022 02:27 PM
    5 Attachment(s)
    • 8
    • 345
    JeteMc
    12-12-2022, 12:31 PM Go to last post

  5. Question [SOLVED] VLOOKUP depend on dropdown list in another column

    Started by rlopikx‎, 12-01-2022 09:09 AM
    dropdown list, vlookup & 4 Attachment(s)
    • 12
    • 472
    rlopikx
    12-12-2022, 11:01 AM Go to last post

  6. [SOLVED] Data Validation List Error when using end of month and sequence formula as source

    Started by smullie‎, 12-12-2022 06:42 AM
    1 Attachment(s)
    • 6
    • 399
    Fluff13
    12-12-2022, 10:07 AM Go to last post

  7. Lightbulb [SOLVED] Need a formula for comma seperated values with special case...

    Started by Muhammad Fraz‎, 12-11-2022 08:19 AM
    comma seperated values 2 Attachment(s)
    • 4
    • 253
    JohnTopley
    12-12-2022, 07:08 AM Go to last post

  8. Sumifs formula to calculate the total number of days

    Started by viewotst‎, 12-09-2022 06:54 AM
    2 Attachment(s)
    • 15
    • 289
    Gregb11
    12-12-2022, 07:01 AM Go to last post

  9. Increase range of cells based on value of 1 cell and respective percentages

    Started by nschepp‎, 12-12-2022 05:30 AM
    3 Attachment(s)
    • 6
    • 182
    Glenn Kennedy
    12-12-2022, 06:10 AM Go to last post

  10. Named Range using Dynamic Range

    Started by TeacherWart‎, 12-11-2022 05:28 PM
    dynamic range formula, named range
    • 10
    • 370
    Glenn Kennedy
    12-12-2022, 04:49 AM Go to last post

  11. Formula to count days that meet two conditions

    Started by viewotst‎, 12-10-2022 01:31 PM
    3 Attachment(s)
    • 4
    • 219
    HansDouwe
    12-12-2022, 04:21 AM Go to last post

  12. IFvalue is >3, then startyear can't be later than 25% from the cyclus from begin inspectio

    Started by Ne0k‎, 12-12-2022 03:09 AM
    formula, formula if, need help 2 Attachment(s)
    • 1
    • 234
    AliGW
    12-12-2022, 03:16 AM Go to last post

  13. Apply different penalty rates over a 24 hr period

    Started by Mike Geraghty‎, 11-21-2022 11:53 PM
    6 Attachment(s)
    • 18
    • 518
    Mike Geraghty
    12-11-2022, 09:18 PM Go to last post

  14. Talking Calculate after subtracting figures from adjacent columns

    Started by shangela‎, 12-11-2022 11:36 AM
    2 Attachment(s)
    • 8
    • 321
    FlameRetired
    12-11-2022, 02:31 PM Go to last post

  15. TextJoin Formula Suggested Solution

    Started by CRJ42‎, 12-10-2022 03:43 PM
    5 Attachment(s)
    • 15
    • 426
    Glenn Kennedy
    12-11-2022, 12:12 PM Go to last post

  16. [SOLVED] FILTER Function | How to Condense the ?Include? Argument?

    Started by Nevanox‎, 12-10-2022 07:55 PM
    5 Attachment(s)
    • 12
    • 446
    HansDouwe
    12-11-2022, 11:24 AM Go to last post

  17. [SOLVED] Coffee Bean Inventory and Roasting Tracker

    Started by mehdi_154‎, 12-10-2022 12:58 PM
    5 Attachment(s)
    • 8
    • 1,188
    mehdi_154
    12-11-2022, 10:48 AM Go to last post

  18. Power Pivot - concatenating fields

    Started by calem‎, 11-24-2022 06:05 PM
    2 Attachment(s)
    • 5
    • 449
    JeteMc
    12-11-2022, 09:34 AM Go to last post

  19. [SOLVED] My spreadsheet has been compromised

    Started by Grahamfeeley‎, 12-10-2022 02:04 AM
    2 Attachment(s)
    • 6
    • 360
    AliGW
    12-11-2022, 09:30 AM Go to last post

  20. Question COUNTIF or COUNTA + Centre across selection?

    Started by jimjimminy‎, 12-10-2022 05:56 PM
    centre across selection, counta, countif 5 Attachment(s)
    • 4
    • 331
    HansDouwe
    12-11-2022, 08:12 AM Go to last post

  21. [SOLVED] Function, formula or Macro help

    Started by wwolf‎, 12-11-2022 02:45 AM
    2 Attachment(s)
    • 3
    • 183
    AliGW
    12-11-2022, 05:35 AM Go to last post

  22. [SOLVED] looking for formula for dates

    Started by Souled‎, 12-11-2022 02:25 AM
    2 Attachment(s)
    • 6
    • 250
    Glenn Kennedy
    12-11-2022, 04:26 AM Go to last post

  23. [SOLVED] Using Data from a table to create a List that ignores any rows with a value of zero.

    Started by ELKHUNT‎, 12-10-2022 05:51 PM
    3 Attachment(s)
    • 5
    • 204
    tanasedn
    12-10-2022, 06:43 PM Go to last post

  24. Extract rows from an array by highest value in Column A for a unique Column B

    Started by talazar‎, 12-09-2022 05:04 PM
    array, criteria, filter 2 Attachment(s)
    • 4
    • 389
    52779
    12-10-2022, 06:23 PM Go to last post

  25. Keeping rows hidden when using a toggle button

    Started by EDM_173‎, 12-09-2022 11:27 AM
    • 1
    • 261
    JeteMc
    12-10-2022, 02:02 PM Go to last post

  26. How to return a fixed value from a cell which keeps changing its value

    Started by kate999‎, 12-09-2022 05:09 AM
    1 Attachment(s)
    • 13
    • 295
    kate999
    12-10-2022, 01:41 PM Go to last post

  27. [SOLVED] filter numbers only

    Started by asad.ermo‎, 12-10-2022 09:10 AM
    1 Attachment(s)
    • 2
    • 280
    asad.ermo
    12-10-2022, 10:38 AM Go to last post

  28. [SOLVED] Bank account balance for each account in one table

    Started by TomazJ‎, 12-02-2022 03:32 AM
    12 Attachment(s)
    • 28
    • 765
    JeteMc
    12-10-2022, 09:19 AM Go to last post

  29. Extract first 4 numbers from string of 9 with varying leading zeros

    Started by SAB1987‎, 12-07-2022 02:32 PM
    4 Attachment(s)
    • 3
    • 296
    tanasedn
    12-10-2022, 06:19 AM Go to last post

  30. [SOLVED] Need formula to fill multiple fields at same time

    Started by Fred Houck‎, 12-09-2022 02:12 PM
    1 Attachment(s)
    • 1
    • 231
    AliGW
    12-10-2022, 02:34 AM Go to last post

  31. Lightbulb excel if statement multiple conditions range

    Started by satyanarayana‎, 12-09-2022 02:05 AM
    if condition with or, multiple if and 2 Attachment(s)
    • 5
    • 243
    FDibbins
    12-10-2022, 02:13 AM Go to last post

  32. Issues With Decimals When Adding Text To Formula

    Started by IMPACTCORY‎, 12-09-2022 08:20 PM
    • 2
    • 192
    HansDouwe
    12-09-2022, 09:06 PM Go to last post

  33. linest only positive number results

    Started by thisandthat‎, 12-09-2022 08:12 PM
    • 1
    • 187
    MrShorty
    12-09-2022, 08:30 PM Go to last post

  34. shortening data in cell

    Started by chrisz1059‎, 12-09-2022 04:53 PM
    1 Attachment(s)
    • 2
    • 188
    chrisz1059
    12-09-2022, 05:08 PM Go to last post

  35. [SOLVED] Need 2 formulas where they lookup values from a different spreadsheet

    Started by thematrix05‎, 12-08-2022 03:46 PM
    3 Attachment(s)
    • 9
    • 338
    HansDouwe
    12-09-2022, 05:08 PM Go to last post

  36. [SOLVED] Index match 2 cells, then drag formula to return unique results w/o leaving blank results

    Started by billrogers184‎, 12-09-2022 02:07 PM
    1 Attachment(s)
    • 3
    • 246
    Fluff13
    12-09-2022, 03:20 PM Go to last post

  37. [SOLVED] Grouping numbers

    Started by Gulya‎, 12-09-2022 01:00 PM
    • 6
    • 211
    AliGW
    12-09-2022, 01:31 PM Go to last post

  38. Formula to match partial data from another tab

    Started by sansan88‎, 12-09-2022 12:28 PM
    2 Attachment(s)
    • 2
    • 161
    Glenn Kennedy
    12-09-2022, 01:27 PM Go to last post

  39. Question Randomly distributing a quantity over columns

    Started by NOA56‎, 12-09-2022 10:07 AM
    automate, distribute cell data, randomize values 2 Attachment(s)
    • 5
    • 214
    bsalv
    12-09-2022, 12:58 PM Go to last post

  40. [SOLVED] Row to Row Look Up

    Started by leebird‎, 12-08-2022 02:52 PM
    1 Attachment(s)
    • 2
    • 271
    leebird
    12-09-2022, 12:44 PM Go to last post

  41. [SOLVED] Count fields based on Month

    Started by Shifty58‎, 12-06-2022 01:38 PM
    3 Attachment(s)
    • 19
    • 402
    JeteMc
    12-09-2022, 12:11 PM Go to last post

  42. Calculate commission rates based on different criteria

    Started by Alan Hero‎, 12-09-2022 07:53 AM
    1 Attachment(s)
    • 1
    • 205
    JohnTopley
    12-09-2022, 11:39 AM Go to last post

  43. [SOLVED] Problems with IF and AND formula

    Started by peterderrington‎, 12-09-2022 08:33 AM
    2 Attachment(s)
    • 5
    • 246
    etaf
    12-09-2022, 11:32 AM Go to last post

  44. [SOLVED] Filter Data With Multiple Drop-Down Boxes and Multiple Criteria

    Started by Nevanox‎, 12-08-2022 09:31 AM
    2 Attachment(s)
    • 3
    • 283
    JohnTopley
    12-09-2022, 11:22 AM Go to last post

  45. Post Produce duplicate rows with partial data from existing rows

    Started by ShcreeminEagle‎, 12-07-2022 04:16 PM
    2 Attachment(s)
    • 1
    • 203
    JeteMc
    12-09-2022, 11:14 AM Go to last post

  46. Question Adding the sum of products from a table

    Started by minszki‎, 12-07-2022 07:28 AM
    1 Attachment(s)
    • 6
    • 230
    wk9128
    12-09-2022, 11:09 AM Go to last post

  47. Capture response time for orders received but subtract non-business hours

    Started by georgezdpt‎, 12-08-2022 05:47 PM
    2 Attachment(s)
    • 3
    • 194
    georgezdpt
    12-09-2022, 10:39 AM Go to last post

  48. [SOLVED] How to change cell format so that numbers add up

    Started by DimitrisPap‎, 12-09-2022 07:18 AM
    2 Attachment(s)
    • 5
    • 166
    AliGW
    12-09-2022, 10:31 AM Go to last post

  49. [SOLVED] How to calculate result by skipping blank cells

    Started by nskatoch‎, 12-08-2022 07:17 AM
    6 Attachment(s)
    • 21
    • 587
    Glenn Kennedy
    12-09-2022, 10:18 AM Go to last post

  50. Question Mirroring Workbooks

    Started by ItzMeAllieBee‎, 12-09-2022 10:06 AM
    data pull, formula, mirroring, workbook
    • 0
    • 175
    ItzMeAllieBee
    12-09-2022, 10:06 AM Go to last post
+ Post New Thread
Page 201 of 5613 FirstFirst ... 201 ...

Forum Information and Options

Users Browsing this Forum

There are currently 101 users browsing this forum. (6 members & 95 guests)

  1. dobracik,
  2. finallymint,
  3. kvsrinivasamurthy,
  4. Nithya24!,
  5. oneblondebrow,
  6. weishida

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