+ Post New Thread
Page 441 of 5614 FirstFirst ... 441 ...
Threads 22001 to 22050 of 280690

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

  1. [SOLVED] Formula to Sum with last 3 digit

    Started by shiva_reshs‎, 08-22-2021 11:16 AM
    • 3
    • 227
    Rick Rothstein
    08-22-2021, 11:41 AM Go to last post

  2. Formula repeating same results when applied to all rows

    Started by OzarkFan‎, 08-22-2021 09:41 AM
    1 Attachment(s)
    • 1
    • 191
    Roel Jongman
    08-22-2021, 10:00 AM Go to last post

  3. Excel - Updating a datasheet with new data list

    Started by INOXI‎, 08-21-2021 12:56 PM
    excel & formula 2 Attachment(s)
    • 5
    • 307
    JohnTopley
    08-22-2021, 09:57 AM Go to last post

  4. Use a value from sheet 2 to find the matching value in a string in sheet 1

    Started by gerdgoebel‎, 08-22-2021 08:22 AM
    1 Attachment(s)
    • 3
    • 283
    AliGW
    08-22-2021, 09:05 AM Go to last post

  5. Question [SOLVED] Return MAX (or LARGE) for each 2D array's row with only ONE "spill" formula

    Started by leolapa‎, 08-21-2021 11:09 AM
    4 Attachment(s)
    • 6
    • 487
    Fluff13
    08-22-2021, 08:50 AM Go to last post

  6. If blank leave blank, If conditions met 1 if not met 2

    Started by eggselent‎, 08-21-2021 11:26 AM
    formula, if statement 1 Attachment(s)
    • 3
    • 444
    AliGW
    08-22-2021, 07:49 AM Go to last post

  7. [SOLVED] Array formula not matching

    Started by geniusufo007‎, 08-22-2021 12:24 AM
    3 Attachment(s)
    • 7
    • 256
    geniusufo007
    08-22-2021, 05:17 AM Go to last post

  8. [SOLVED] Vlookup N/A error

    Started by exceluniprojecthelp‎, 08-22-2021 03:01 AM
    error, vlookup #n/a, vlookup n/a 1 Attachment(s)
    • 10
    • 615
    exceluniprojecthelp
    08-22-2021, 04:41 AM Go to last post

  9. [SOLVED] Updating formula for report based on pivot table

    Started by sunboy‎, 08-20-2021 08:38 AM
    2 Attachment(s)
    • 2
    • 235
    sunboy
    08-22-2021, 04:37 AM Go to last post

  10. [SOLVED] Trial balance using pivot table

    Started by sunboy‎, 08-20-2021 03:55 AM
    4 Attachment(s)
    • 11
    • 1,315
    sunboy
    08-22-2021, 04:27 AM Go to last post

  11. [SOLVED] Start Index/Match from a specific cell reference

    Started by Ian McPherson‎, 08-20-2021 03:08 AM
    2 Attachment(s)
    • 9
    • 502
    Ian McPherson
    08-22-2021, 01:11 AM Go to last post

  12. [SOLVED] lookup, with word substitution and matches it to a value

    Started by g3xer‎, 08-21-2021 11:54 PM
    match & index, xlookup 1 Attachment(s)
    • 4
    • 307
    g3xer
    08-22-2021, 01:06 AM Go to last post

  13. Join two IF formulas or alternative formula?

    Started by ShadowHash‎, 08-21-2021 11:54 PM
    1 Attachment(s)
    • 4
    • 234
    ShadowHash
    08-22-2021, 12:54 AM Go to last post

  14. [SOLVED] Re: countIFS/ calculate how many plus numbers based on in-between values in another column

    Started by ARNIEBUN‎, 08-21-2021 10:21 AM
    1 Attachment(s)
    • 3
    • 230
    wk9128
    08-21-2021, 09:20 PM Go to last post

  15. Semi Automated Ordering Catalog

    Started by imazack97‎, 08-21-2021 03:39 PM
    • 6
    • 285
    janmorris
    08-21-2021, 08:43 PM Go to last post

  16. Multiple options in a cell

    Started by thompsonathan‎, 08-21-2021 08:11 PM
    • 1
    • 156
    Pete_UK
    08-21-2021, 08:20 PM Go to last post

  17. [SOLVED] Ignore the blank cells

    Started by parbynat‎, 08-21-2021 03:32 PM
    • 4
    • 242
    Haluk
    08-21-2021, 04:18 PM Go to last post

  18. [SOLVED] I can pivot what I need, but i can't write the formula

    Started by rkalloo‎, 08-20-2021 08:20 PM
    3 Attachment(s)
    • 6
    • 285
    JohnTopley
    08-21-2021, 03:09 PM Go to last post

  19. [SOLVED] Unique values to return as 1 and rest as 0

    Started by nr6281‎, 08-21-2021 10:52 AM
    1 Attachment(s)
    • 4
    • 347
    nr6281
    08-21-2021, 12:37 PM Go to last post

  20. Red face Excel Project comparing two files

    Started by wenli352‎, 08-18-2021 10:02 AM
    3 Attachment(s)
    • 1
    • 315
    JeteMc
    08-21-2021, 11:16 AM Go to last post

  21. [SOLVED] Missing Insert function BeepME

    Started by Str|ker‎, 08-21-2021 09:42 AM
    1 Attachment(s)
    • 3
    • 275
    Str|ker
    08-21-2021, 10:52 AM Go to last post

  22. [SOLVED] Carrying data from one sheet to another index compare

    Started by Berna11‎, 08-21-2021 06:32 AM
    2 Attachment(s)
    • 2
    • 211
    Berna11
    08-21-2021, 10:14 AM Go to last post

  23. [SOLVED] SUM cells contains text

    Started by Undo‎, 08-21-2021 05:41 AM
    2 Attachment(s)
    • 3
    • 337
    Bo_Ry
    08-21-2021, 10:13 AM Go to last post

  24. [SOLVED] Finding maximum of column totals by dates

    Started by josephteh‎, 08-20-2021 06:28 AM
    4 Attachment(s)
    • 19
    • 355
    wk9128
    08-21-2021, 10:08 AM Go to last post

  25. Thumbs up [SOLVED] index and match/ LOOKUP TO FIND the last number over 50

    Started by ARNIEBUN‎, 08-05-2021 09:39 AM
    index match, vlookup, xlookup 9 Attachment(s)
    • 22
    • 877
    JeteMc
    08-21-2021, 10:04 AM Go to last post

  26. [SOLVED] AVERAGEIFS/ calculate the average change in column based on in-between values in another

    Started by ARNIEBUN‎, 08-21-2021 09:14 AM
    1 Attachment(s)
    • 7
    • 208
    TMS
    08-21-2021, 10:04 AM Go to last post

  27. [SOLVED] Display only filtered values from sheet 1 to sheet 2 (text and numbers)

    Started by perko121‎, 08-20-2021 08:02 AM
    3 Attachment(s)
    • 11
    • 492
    perko121
    08-21-2021, 07:54 AM Go to last post

  28. [SOLVED] Formula Aggregate or index and compare

    Started by Berna11‎, 08-20-2021 11:26 AM
    1 Attachment(s)
    • 5
    • 342
    Berna11
    08-21-2021, 06:25 AM Go to last post

  29. [SOLVED] Timesheet that calcs time in, time out, lunch used, reg hours, ot hours, double hours

    Started by noobface‎, 02-09-2013 12:00 AM
    2 Attachment(s)
    • 12
    • 3,572
    AliGW
    08-21-2021, 03:45 AM Go to last post

  30. Return a specific string in text without using text functions.

    Started by wdguitar‎, 08-19-2021 06:24 PM
    1 Attachment(s)
    • 9
    • 393
    menem
    08-21-2021, 03:22 AM Go to last post

  31. Two Date Range Lookup based on Index Formula

    Started by mannyz8‎, 08-20-2021 01:43 PM
    date and between, date and lookup, date and range, index & aggregate
    • 1
    • 308
    Pepe Le Mokko
    08-21-2021, 02:10 AM Go to last post

  32. Unhappy Variance Percentage

    Started by mannyz8‎, 08-19-2021 05:03 PM
    percentage, variance analysis
    • 8
    • 433
    josephteh
    08-20-2021, 08:35 PM Go to last post

  33. [SOLVED] 'Unique' Formula Based on Two Columns

    Started by Denise0618‎, 08-20-2021 01:29 PM
    formula, formula and functions, unique 1 Attachment(s)
    • 1
    • 289
    Metoo7
    08-20-2021, 08:07 PM Go to last post

  34. Moved: Subtracting 0.05 from 1 until it reaches 0 gives -3.19189119579733E-16 for 0! Why?!?

    Started by Spielberg‎, 08-20-2021 06:14 PM
    •  
    •  

  35. Post [SOLVED] use multiple criteria to lookup =>, and return the results of the cheapest

    Started by g3xer‎, 08-19-2021 06:36 PM
    index, match, multiple criteria 1 Attachment(s)
    • 3
    • 397
    FlameRetired
    08-20-2021, 05:11 PM Go to last post

  36. Lookup Info on another sheet

    Started by regina85345‎, 08-20-2021 12:30 PM
    1 Attachment(s)
    • 4
    • 195
    regina85345
    08-20-2021, 03:23 PM Go to last post

  37. [SOLVED] Match Question

    Started by CWatsonJr‎, 08-20-2021 01:38 PM
    1 Attachment(s)
    • 2
    • 190
    CWatsonJr
    08-20-2021, 01:46 PM Go to last post

  38. [SOLVED] IF function less than and greater than help.

    Started by i.r.smith‎, 08-20-2021 12:46 PM
    1 Attachment(s)
    • 2
    • 289
    i.r.smith
    08-20-2021, 01:41 PM Go to last post

  39. Question Cell Color change based off multiple cells conditional formatting

    Started by gulonraid‎, 08-20-2021 12:12 AM
    color as condition, conditional formatting 2 Attachment(s)
    • 5
    • 397
    gulonraid
    08-20-2021, 01:18 PM Go to last post

  40. Format Spilled Data (not Conditional)

    Started by Mgc26133‎, 08-20-2021 12:43 PM
    • 0
    • 217
    Mgc26133
    08-20-2021, 12:43 PM Go to last post

  41. embedded if, and, or

    Started by boochster‎, 08-19-2021 06:20 PM
    1 Attachment(s)
    • 6
    • 273
    TMS
    08-20-2021, 12:18 PM Go to last post

  42. [SOLVED] Index match/return data based on value

    Started by rayted‎, 08-20-2021 03:24 AM
    index, match, skills matrix 1 Attachment(s)
    • 4
    • 345
    TMS
    08-20-2021, 12:16 PM Go to last post

  43. Duplicate values in column A -> print column B values to Column C (2nd edition)

    Started by K.Flaming‎, 08-20-2021 06:35 AM
    1 Attachment(s)
    • 1
    • 198
    DavidBowman
    08-20-2021, 12:11 PM Go to last post

  44. Exclamation Ecommerce and Excel

    Started by sunniebrowne‎, 08-20-2021 08:49 AM
    excel 2 Attachment(s)
    • 1
    • 233
    6StringJazzer
    08-20-2021, 12:01 PM Go to last post

  45. Formula to Prorate Real estate taxes paid in arrears

    Started by regina85345‎, 08-18-2021 05:46 PM
    2 Attachment(s)
    • 4
    • 406
    regina85345
    08-20-2021, 11:58 AM Go to last post

  46. [SOLVED] matching 1 column with another

    Started by DEEARO‎, 08-20-2021 10:42 AM
    1 Attachment(s)
    • 4
    • 228
    AliGW
    08-20-2021, 11:56 AM Go to last post

  47. [SOLVED] Copy Formula's to certain days on another worksheet

    Started by Spoonyz‎, 08-19-2021 04:51 AM
    7 Attachment(s)
    • 12
    • 314
    JohnTopley
    08-20-2021, 11:11 AM Go to last post

  48. Add previous formula answer to column amount

    Started by odahilys‎, 08-20-2021 10:19 AM
    • 1
    • 189
    Special-K
    08-20-2021, 11:10 AM Go to last post

  49. Match multiple cells to create a Win/Loss result

    Started by JKD8786‎, 08-20-2021 06:04 AM
    1 Attachment(s)
    • 1
    • 268
    alansidman
    08-20-2021, 10:35 AM Go to last post

  50. [SOLVED] Highlight date range on calendar

    Started by pamela16‎, 04-29-2021 07:49 AM
    7 Attachment(s)
    • 44
    • 1,623
    pamela16
    08-20-2021, 09:18 AM Go to last post
+ Post New Thread
Page 441 of 5614 FirstFirst ... 441 ...

Forum Information and Options

Users Browsing this Forum

There are currently 45 users browsing this forum. (5 members & 40 guests)

  1. boynejs,
  2. HansDouwe,
  3. JN831,
  4. tjensen91

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