+ Post New Thread
Page 400 of 5614 FirstFirst ... 400 ...
Threads 19951 to 20000 of 280693

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] Naming / Commenting Conditional Formatting Formulas

    Started by Modify_inc‎, 11-11-2021 12:22 PM
    conditional formatiing, formulas
    • 5
    • 319
    AliGW
    11-11-2021, 12:55 PM Go to last post

  2. Add row in one worksheet, automatically adds a row in other worksheet

    Started by roby117‎, 11-11-2021 12:19 PM
    • 1
    • 185
    AliGW
    11-11-2021, 12:20 PM Go to last post

  3. Lookup multiple columns to return value

    Started by jhw1998‎, 11-11-2021 10:32 AM
    3 Attachment(s)
    • 5
    • 248
    mehmetcik
    11-11-2021, 11:06 AM Go to last post

  4. [SOLVED] When column value is reached return contents from adjacent cell

    Started by will.sf‎, 11-11-2021 10:25 AM
    1 Attachment(s)
    • 3
    • 208
    will.sf
    11-11-2021, 10:42 AM Go to last post

  5. [SOLVED] extract only a part of text

    Started by vermaccio‎, 11-11-2021 10:28 AM
    • 2
    • 185
    BadlySpelledBuoy
    11-11-2021, 10:34 AM Go to last post

  6. Help with conditional formatting & time value

    Started by zainmerchant‎, 11-10-2021 06:21 AM
    8 Attachment(s)
    • 16
    • 373
    zainmerchant
    11-11-2021, 09:55 AM Go to last post

  7. [SOLVED] SUM up row and column with date range

    Started by DEEARO‎, 11-11-2021 08:58 AM
    1 Attachment(s)
    • 4
    • 220
    Richard Buttrey
    11-11-2021, 09:47 AM Go to last post

  8. Thumbs up [SOLVED] Dynamic insertbreak function looks for special character instead of lenght

    Started by Ralleberg‎, 11-09-2021 05:56 AM
    break text, function
    • 2
    • 297
    Ralleberg
    11-11-2021, 09:36 AM Go to last post

  9. [SOLVED] Formula needed to strip alphabet characters appended to numbers

    Started by paulma1960‎, 11-09-2021 05:45 AM
    • 22
    • 326
    paulma1960
    11-11-2021, 09:05 AM Go to last post

  10. cell border with freeze panes

    Started by john_cash‎, 11-10-2021 04:00 PM
    1 Attachment(s)
    • 2
    • 387
    john_cash
    11-11-2021, 05:31 AM Go to last post

  11. Conditional formatting if a date is between 2 dates and IS NOT a weekend or public holiday

    Started by dafidav‎, 11-10-2021 09:02 AM
    1 Attachment(s)
    • 3
    • 235
    davsth
    11-11-2021, 05:00 AM Go to last post

  12. AR aging using FIFO method

    Started by tina16marie‎, 11-10-2021 03:39 AM
    4 Attachment(s)
    • 3
    • 707
    WideBoyDixon
    11-11-2021, 04:57 AM Go to last post

  13. [SOLVED] Formulas with Multiple Range Criteria - not returning result

    Started by btparkhe1920‎, 11-10-2021 08:55 AM
    1 Attachment(s)
    • 2
    • 243
    btparkhe1920
    11-10-2021, 11:57 PM Go to last post

  14. [SOLVED] How to Correct or Delete an Array

    Started by viclea‎, 11-10-2021 10:55 PM
    • 1
    • 232
    Sam Capricci
    11-10-2021, 11:14 PM Go to last post

  15. Need help with nested IF and MAX statement

    Started by rob5299‎, 11-10-2021 09:01 PM
    1 Attachment(s)
    • 1
    • 189
    Crooza
    11-10-2021, 09:23 PM Go to last post

  16. How to Generate a Range of Values between 2 Points with a Given Average

    Started by nitro22888‎, 11-06-2021 08:32 PM
    3 Attachment(s)
    • 7
    • 334
    nitro22888
    11-10-2021, 08:26 PM Go to last post

  17. Vlookup trying to pull value or values from a cell where values are separated by a comma

    Started by the1trugr81‎, 11-02-2021 12:35 PM
    5 Attachment(s)
    • 5
    • 348
    JeteMc
    11-10-2021, 07:59 PM Go to last post

  18. Creating a formula to do a teammate count

    Started by Midday259‎, 11-07-2021 04:33 AM
    4 Attachment(s)
    • 7
    • 364
    GeoffW283
    11-10-2021, 07:35 PM Go to last post

  19. Lookup for MULTIPLE values and return a specific cell if AT LEAST ONE criteria is met

    Started by simonesk‎, 11-10-2021 06:16 PM
    excel, hlookup, index, match, match & index 1 Attachment(s)
    • 1
    • 323
    6StringJazzer
    11-10-2021, 07:11 PM Go to last post

  20. Cool [SOLVED] Statutory Redundancy Pay Out

    Started by shiraz‎, 07-25-2017 06:40 PM
    redundancy pay, redundancy pay new rules, uk redundancy pay 5 Attachment(s)
    • 30
    • 12,439
    samanthab32
    11-10-2021, 06:08 PM Go to last post

  21. [SOLVED] create 1 multi-column array from multiple single column arrays

    Started by Coley356‎, 11-09-2021 09:24 PM
    • 4
    • 339
    FlameRetired
    11-10-2021, 05:04 PM Go to last post

  22. [SOLVED] How to find differences in groups?

    Started by AccountingJ‎, 11-10-2021 03:22 PM
    1 Attachment(s)
    • 2
    • 200
    CARACALLA
    11-10-2021, 03:58 PM Go to last post

  23. Calculating (8 Threads)....

    Started by asr138‎, 11-09-2021 05:16 PM
    2 Attachment(s)
    • 5
    • 1,037
    TMS
    11-10-2021, 03:50 PM Go to last post

  24. LET function not producing a spill range

    Started by Coley356‎, 11-09-2021 02:20 PM
    1 Attachment(s)
    • 8
    • 272
    Fluff13
    11-10-2021, 03:44 PM Go to last post

  25. [SOLVED] "create" path to a file

    Started by squatter87‎, 11-09-2021 11:17 PM
    6 Attachment(s)
    • 8
    • 391
    DJunqueira
    11-10-2021, 02:49 PM Go to last post

  26. Post [SOLVED] Drop Down and vlookup

    Started by Miggy2021‎, 11-10-2021 02:09 PM
    1 Attachment(s)
    • 7
    • 207
    Pete_UK
    11-10-2021, 02:42 PM Go to last post

  27. Formulas become array when file downloaded

    Started by rallatt‎, 11-10-2021 12:14 PM
    array formula
    • 3
    • 360
    TMS
    11-10-2021, 02:35 PM Go to last post

  28. [SOLVED] sum by month, criteria are from row and column

    Started by DEEARO‎, 11-10-2021 09:09 AM
    5 Attachment(s)
    • 9
    • 328
    JohnTopley
    11-10-2021, 02:25 PM Go to last post

  29. Count Formula Using Only First Part of Lookup Value

    Started by danielo08‎, 11-10-2021 12:55 PM
    1 Attachment(s)
    • 4
    • 173
    FlameRetired
    11-10-2021, 01:39 PM Go to last post

  30. Splitting a period of time into days in the relevant months

    Started by Lars-Denmark‎, 11-10-2021 09:14 AM
    date and range 3 Attachment(s)
    • 3
    • 285
    bsalv
    11-10-2021, 01:13 PM Go to last post

  31. [SOLVED] Counting from Left to Right

    Started by markvdhouten‎, 11-10-2021 11:16 AM
    2 Attachment(s)
    • 4
    • 256
    markvdhouten
    11-10-2021, 12:34 PM Go to last post

  32. Date based conditional formulas

    Started by will26‎, 11-10-2021 11:07 AM
    • 2
    • 218
    etaf
    11-10-2021, 12:33 PM Go to last post

  33. [SOLVED] Sum row and columun with great and equal to date

    Started by DEEARO‎, 11-10-2021 12:01 PM
    • 1
    • 142
    mehmetcik
    11-10-2021, 12:17 PM Go to last post

  34. [SOLVED] filter rows containing a word

    Started by vermaccio‎, 11-10-2021 10:52 AM
    1 Attachment(s)
    • 3
    • 191
    TMS
    11-10-2021, 11:55 AM Go to last post

  35. k-th Central moment and k-th ordinary moment

    Started by LuisFer033‎, 11-10-2021 04:00 AM
    2 Attachment(s)
    • 9
    • 518
    LuisFer033
    11-10-2021, 11:32 AM Go to last post

  36. 2 questions on number sequence and dates

    Started by wislndixie1100‎, 11-08-2021 11:04 PM
    dates formating
    • 5
    • 298
    wislndixie1100
    11-10-2021, 11:17 AM Go to last post

  37. [SOLVED] sort without zeros

    Started by vermaccio‎, 11-10-2021 09:07 AM
    2 Attachment(s)
    • 2
    • 309
    vermaccio
    11-10-2021, 10:56 AM Go to last post

  38. Searching a value (different tabs) using some conditionals

    Started by Siqs‎, 11-09-2021 05:28 PM
    conditionals, funtionif, funtions, sumif 4 Attachment(s)
    • 4
    • 374
    DJunqueira
    11-10-2021, 10:55 AM Go to last post

  39. [SOLVED] Counting rows based on a value

    Started by will.sf‎, 11-10-2021 09:33 AM
    1 Attachment(s)
    • 3
    • 197
    will.sf
    11-10-2021, 10:55 AM Go to last post

  40. [SOLVED] If the value is false show difference

    Started by Statzz‎, 11-10-2021 10:03 AM
    • 2
    • 191
    Statzz
    11-10-2021, 10:18 AM Go to last post

  41. [SOLVED] If statement not working on blank cell due to formula

    Started by kris01‎, 11-10-2021 08:12 AM
    • 4
    • 265
    AliGW
    11-10-2021, 10:07 AM Go to last post

  42. [SOLVED] Add days in dates,,

    Started by max2599‎, 11-10-2021 09:42 AM
    1 Attachment(s)
    • 2
    • 204
    alansidman
    11-10-2021, 10:00 AM Go to last post

  43. [SOLVED] Using SUMIF with an OR or ELSE

    Started by cableghost‎, 11-09-2021 10:49 PM
    else and elseif, sumif 1 Attachment(s)
    • 4
    • 398
    Fluff13
    11-10-2021, 09:58 AM Go to last post

  44. Combining FILTER and SORTBY formulas

    Started by Ctromb‎, 11-04-2021 11:47 AM
    1 Attachment(s)
    • 9
    • 1,823
    JeteMc
    11-10-2021, 09:39 AM Go to last post

  45. [SOLVED] Vlookup exclude first character

    Started by rayted‎, 11-10-2021 05:10 AM
    mid, vlookup 1 Attachment(s)
    • 3
    • 468
    rayted
    11-10-2021, 09:20 AM Go to last post

  46. Post Randomly assign cell values by date

    Started by ubagas‎, 11-10-2021 08:17 AM
    1 Attachment(s)
    • 1
    • 184
    AliGW
    11-10-2021, 08:36 AM Go to last post

  47. Hyperlink to Web Page based on data in cell

    Started by goranimo‎, 11-10-2021 03:53 AM
    3 Attachment(s)
    • 4
    • 247
    DJunqueira
    11-10-2021, 08:19 AM Go to last post

  48. Average the last three responses in a row

    Started by sdking‎, 11-10-2021 07:56 AM
    • 3
    • 209
    AliGW
    11-10-2021, 08:03 AM Go to last post

  49. Post [SOLVED] How to type a word and fill some cells with numeric values associated

    Started by fcgreco‎, 11-08-2021 07:44 AM
    6 Attachment(s)
    • 14
    • 326
    AliGW
    11-10-2021, 07:52 AM Go to last post

  50. How to generate arrays name using concat or similar functions

    Started by nima50‎, 11-09-2021 09:34 PM
    array
    • 5
    • 330
    DJunqueira
    11-10-2021, 07:18 AM Go to last post
+ Post New Thread
Page 400 of 5614 FirstFirst ... 400 ...

Forum Information and Options

Users Browsing this Forum

There are currently 53 users browsing this forum. (4 members & 49 guests)

  1. DeeWuu,
  2. Glenn Kennedy,
  3. JohnTopley,
  4. 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