+ Post New Thread
Page 203 of 5615 FirstFirst ... 203 ...
Threads 10101 to 10150 of 280712

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

  1. 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

  2. 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

  3. 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

  4. TextJoin Formula Suggested Solution

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

  5. [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

  6. [SOLVED] Coffee Bean Inventory and Roasting Tracker

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

  7. Power Pivot - concatenating fields

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

  8. [SOLVED] My spreadsheet has been compromised

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

  9. 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
    • 333
    HansDouwe
    12-11-2022, 08:12 AM Go to last post

  10. [SOLVED] Function, formula or Macro help

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

  11. [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

  12. [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

  13. 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
    • 392
    52779
    12-10-2022, 06:23 PM Go to last post

  14. Keeping rows hidden when using a toggle button

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

  15. 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

  16. [SOLVED] filter numbers only

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

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

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

  18. 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

  19. [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

  20. 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

  21. Issues With Decimals When Adding Text To Formula

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

  22. 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

  23. 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

  24. [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

  25. [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
    • 248
    Fluff13
    12-09-2022, 03:20 PM Go to last post

  26. [SOLVED] Grouping numbers

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

  27. 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

  28. 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
    • 217
    bsalv
    12-09-2022, 12:58 PM Go to last post

  29. [SOLVED] Row to Row Look Up

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

  30. [SOLVED] Count fields based on Month

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

  31. 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

  32. [SOLVED] Problems with IF and AND formula

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

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

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

  34. 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

  35. 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

  36. 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

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

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

  38. [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

  39. Question Mirroring Workbooks

    Started by ItzMeAllieBee‎, 12-09-2022 10:06 AM
    data pull, formula, mirroring, workbook
    • 0
    • 176
    ItzMeAllieBee
    12-09-2022, 10:06 AM Go to last post

  40. Post [SOLVED] Find string containing

    Started by mvcp007‎, 12-09-2022 07:23 AM
    • 6
    • 224
    Fluff13
    12-09-2022, 09:29 AM Go to last post

  41. [SOLVED] Adding a blank space to an concatenated If statement

    Started by Ade_68‎, 12-09-2022 07:55 AM
    3 Attachment(s)
    • 10
    • 230
    sandy666
    12-09-2022, 09:20 AM Go to last post

  42. How to match a row in a table and check if it contains a given value (COUNTIF + VLOOKUP)?

    Started by MoldyBread‎, 12-08-2022 05:37 AM
    countif, vlookup 3 Attachment(s)
    • 12
    • 405
    MoldyBread
    12-09-2022, 09:18 AM Go to last post

  43. insert graph for the data series of wanted years and months

    Started by fakhteh‎, 12-02-2022 04:52 PM
    2 Attachment(s)
    • 2
    • 282
    JeteMc
    12-09-2022, 08:24 AM Go to last post

  44. [SOLVED] Using Ifs and Vlookup formula, with multiple condition

    Started by sansan88‎, 12-09-2022 04:47 AM
    • 10
    • 383
    TMS
    12-09-2022, 06:34 AM Go to last post

  45. [SOLVED] Formula to extend to next day in an Excel Table

    Started by pnasir‎, 12-08-2022 08:44 AM
    3 Attachment(s)
    • 4
    • 213
    pnasir
    12-09-2022, 06:24 AM Go to last post

  46. select and extract data of wanted years and months

    Started by fakhteh‎, 12-03-2022 11:28 PM
    2 Attachment(s)
    • 2
    • 277
    fakhteh
    12-09-2022, 05:55 AM Go to last post

  47. [SOLVED] Formula to subtract today date from lookup value

    Started by telhearne1‎, 12-09-2022 04:20 AM
    • 4
    • 220
    TMS
    12-09-2022, 05:43 AM Go to last post

  48. Pair 2 people based on tiered criteria

    Started by codu123‎, 12-08-2022 12:08 PM
    function, pairing, random criteria, tiered calculations 2 Attachment(s)
    • 1
    • 345
    Kaper
    12-09-2022, 04:30 AM Go to last post

  49. [SOLVED] PC Asset Tracker - Get value in new sheet

    Started by Ferry Wils‎, 12-06-2022 10:59 PM
    3 Attachment(s)
    • 6
    • 262
    Ferry Wils
    12-09-2022, 04:03 AM Go to last post

  50. Smile [SOLVED] Calculate average and max values by looking up values

    Started by hasan mougharbel‎, 12-09-2022 02:35 AM
    3 Attachment(s)
    • 4
    • 177
    kvsrinivasamurthy
    12-09-2022, 04:01 AM Go to last post
+ Post New Thread
Page 203 of 5615 FirstFirst ... 203 ...

Forum Information and Options

Users Browsing this Forum

There are currently 115 users browsing this forum. (4 members & 111 guests)

  1. alansidman,
  2. bitiy74906,
  3. Fluff13,
  4. swdude12

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