+ Post New Thread
Page 1000 of 5611 FirstFirst ... 1000 ...
Threads 49951 to 50000 of 280512

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

  1. [SOLVED] How to make dependant drop down lists

    Started by zaibuojantis‎, 02-16-2019 06:05 PM
    2 Attachment(s)
    • 3
    • 348
    FDibbins
    02-17-2019, 05:41 PM Go to last post

  2. DATEDIF Formula HELP

    Started by vforrestt‎, 02-17-2019 04:23 PM
    excel, formula, formula and functions 1 Attachment(s)
    • 4
    • 369
    FDibbins
    02-17-2019, 05:36 PM Go to last post

  3. [SOLVED] How to remove text after the last -

    Started by tuongtu3‎, 02-17-2019 01:55 AM
    • 8
    • 337
    FDibbins
    02-17-2019, 05:31 PM Go to last post

  4. [SOLVED] Fixing the Time Sheet

    Started by Wolfin2010‎, 08-19-2017 01:04 PM
    minutes, sheet, time 6 Attachment(s)
    • 17
    • 1,362
    AliGW
    02-17-2019, 05:18 PM Go to last post

  5. Construct Column From Checked Values

    Started by MotrColt‎, 02-17-2019 04:55 PM
    1 Attachment(s)
    • 1
    • 251
    Pete_UK
    02-17-2019, 05:06 PM Go to last post

  6. FILTERXML Function

    Started by benmorgan1985‎, 02-17-2019 06:51 AM
    api, darksky, filterxml, weather
    • 1
    • 719
    sergiomabres
    02-17-2019, 04:38 PM Go to last post

  7. [SOLVED] Golf League Hcp calculation

    Started by cjaiz71‎, 02-16-2019 06:27 PM
    average, golf 6 Attachment(s)
    • 19
    • 1,448
    cjaiz71
    02-17-2019, 04:37 PM Go to last post

  8. Question Font color change automatically based on specific keyword

    Started by demice‎, 01-31-2019 07:18 AM
    1 Attachment(s)
    • 5
    • 439
    Fluff13
    02-17-2019, 03:35 PM Go to last post

  9. [SOLVED] Date difference formula

    Started by hpgerald‎, 02-17-2019 05:16 AM
    2 Attachment(s)
    • 3
    • 332
    hpgerald
    02-17-2019, 03:30 PM Go to last post

  10. Formula to show the contents of the first filtered cell

    Started by tinkode‎, 02-17-2019 01:40 PM
    1 Attachment(s)
    • 1
    • 342
    FlameRetired
    02-17-2019, 03:00 PM Go to last post

  11. Combine percentage formula with dynamic range

    Started by rogrand‎, 02-16-2019 08:33 PM
    1 Attachment(s)
    • 2
    • 471
    rogrand
    02-17-2019, 02:54 PM Go to last post

  12. [SOLVED] Another (yet different) Time Problem

    Started by WalterE‎, 02-16-2019 07:08 PM
    1 Attachment(s)
    • 4
    • 318
    Greg M
    02-17-2019, 01:03 PM Go to last post

  13. sum cells in 2(or more) conditions

    Started by eitansss‎, 02-17-2019 12:18 PM
    1 Attachment(s)
    • 2
    • 233
    AliGW
    02-17-2019, 12:23 PM Go to last post

  14. [SOLVED] Convert Three Columns to Table

    Started by soleimani1967‎, 02-17-2019 05:10 AM
    1 Attachment(s)
    • 8
    • 1,297
    soleimani1967
    02-17-2019, 12:13 PM Go to last post

  15. Sports athletic meet bib no input

    Started by actveme‎, 02-14-2019 02:44 PM
    9 Attachment(s)
    • 11
    • 816
    AliGW
    02-17-2019, 10:35 AM Go to last post

  16. Auto Numbering in Excel. Thank you!

    Started by cliffe007‎, 02-17-2019 08:10 AM
    excel, excel formula help 4 Attachment(s)
    • 8
    • 476
    AliGW
    02-17-2019, 09:48 AM Go to last post

  17. IFERROR, LOOKUP and ROUNDUP In the Same Formula?

    Started by sawyer8870‎, 02-16-2019 10:32 AM
    3 Attachment(s)
    • 6
    • 942
    6StringJazzer
    02-17-2019, 09:32 AM Go to last post

  18. [SOLVED] Calculate Visa Renewal Dates

    Started by NonStopLeo‎, 02-17-2019 01:45 AM
    1 Attachment(s)
    • 7
    • 944
    FDibbins
    02-17-2019, 03:14 AM Go to last post

  19. Problem with Index/Match Functions

    Started by Acanthostega‎, 02-16-2019 08:42 PM
    2 Attachment(s)
    • 5
    • 383
    AliGW
    02-17-2019, 02:11 AM Go to last post

  20. Question [SOLVED] how to fill cells if next cells have specific text

    Started by matz47‎, 02-12-2019 07:15 PM
    6 Attachment(s)
    • 15
    • 418
    TMS
    02-16-2019, 08:41 PM Go to last post

  21. Taking data from regularly updated table

    Started by eveza‎, 02-15-2019 08:32 PM
    2 Attachment(s)
    • 2
    • 306
    GeoffW283
    02-16-2019, 08:31 PM Go to last post

  22. Copy names in B downward as long as A is the same

    Started by watchthefaithrain‎, 02-16-2019 06:11 PM
    1 Attachment(s)
    • 2
    • 268
    WalterE
    02-16-2019, 06:39 PM Go to last post

  23. [SOLVED] Index/Match formula to account for duplicates

    Started by dvess11‎, 02-16-2019 05:50 PM
    1 Attachment(s)
    • 4
    • 332
    Greg M
    02-16-2019, 06:34 PM Go to last post

  24. [SOLVED] Count how many string (left rows) that not match any cell reference

    Started by AndyJr‎, 02-16-2019 04:07 PM
    count, match, reference criteria 2 Attachment(s)
    • 2
    • 395
    AndyJr
    02-16-2019, 04:46 PM Go to last post

  25. Conditional formatting depending on drop down other cell?

    Started by Frigide‎, 02-02-2019 06:02 PM
    • 6
    • 428
    JeteMc
    02-16-2019, 03:48 PM Go to last post

  26. Subtracting non-blank cells only

    Started by levpn‎, 02-15-2019 04:57 PM
    average, blank cell, formula
    • 9
    • 4,808
    GeoffW283
    02-16-2019, 03:22 PM Go to last post

  27. [SOLVED] How to get External link data to stay

    Started by rogrand‎, 02-13-2019 12:18 AM
    • 1
    • 285
    rogrand
    02-16-2019, 03:13 PM Go to last post

  28. Cool Calculate the new NPER when a baloon payment is made

    Started by cristinaion‎, 02-16-2019 01:37 PM
    nper, var interest rate 1 Attachment(s)
    • 1
    • 490
    Greg M
    02-16-2019, 03:06 PM Go to last post

  29. Formula to count occurances of decimal value (Easy one)

    Started by ricklou‎, 02-16-2019 07:56 AM
    9 Attachment(s)
    • 15
    • 425
    torachan
    02-16-2019, 01:24 PM Go to last post

  30. I want to include two conditions within an IF formula

    Started by abdelqaderdiab‎, 01-25-2019 03:50 PM
    2 Attachment(s)
    • 7
    • 1,119
    Aardigspook
    02-16-2019, 09:59 AM Go to last post

  31. IF statement with dates

    Started by fatboylard‎, 02-14-2019 10:47 AM
    1 Attachment(s)
    • 7
    • 340
    fatboylard
    02-16-2019, 07:45 AM Go to last post

  32. calculate if a car has made a return journey

    Started by rikkyshh‎, 02-10-2019 03:45 PM
    3 Attachment(s)
    • 9
    • 346
    rikkyshh
    02-16-2019, 07:18 AM Go to last post

  33. How to use AND & IF and shorten a long formula

    Started by VisionSmart‎, 02-16-2019 05:48 AM
    2 Attachment(s)
    • 5
    • 316
    Roel Jongman
    02-16-2019, 06:45 AM Go to last post

  34. count if formula with link to closed workbook

    Started by steddas‎, 02-16-2019 06:03 AM
    • 1
    • 804
    arthurbr
    02-16-2019, 06:21 AM Go to last post

  35. Copying cell formats based on VLOOKUP formulas

    Started by Quaker2001‎, 02-15-2019 05:28 PM
    formatted cells, match & index, vlookup
    • 1
    • 347
    FDibbins
    02-16-2019, 02:59 AM Go to last post

  36. [SOLVED] Index/match across multiple sheets

    Started by Jamesera27‎, 05-18-2017 06:40 PM
    3 Attachment(s)
    • 21
    • 18,809
    FDibbins
    02-16-2019, 02:55 AM Go to last post

  37. large files

    Started by khaled1989‎, 02-15-2019 07:40 AM
    • 2
    • 286
    FDibbins
    02-16-2019, 02:15 AM Go to last post

  38. Confused not sure if possible HELP

    Started by slock92‎, 02-15-2019 05:43 AM
    1 Attachment(s)
    • 2
    • 215
    FDibbins
    02-16-2019, 02:13 AM Go to last post

  39. 2-Part Question for Schedule

    Started by scubakerny‎, 02-15-2019 08:49 PM
    1 Attachment(s)
    • 2
    • 261
    MarvinP
    02-16-2019, 01:03 AM Go to last post

  40. Printing

    Started by Teddi‎, 02-15-2019 10:00 AM
    • 1
    • 243
    Greg M
    02-15-2019, 10:29 PM Go to last post

  41. automatically populated into a cell

    Started by scubakerny‎, 02-15-2019 08:04 PM
    • 1
    • 222
    etaf
    02-15-2019, 08:09 PM Go to last post

  42. [SOLVED] Need Dependent Cell validation list

    Started by hmr2662‎, 02-15-2019 01:49 PM
    1 Attachment(s)
    • 2
    • 240
    hmr2662
    02-15-2019, 07:21 PM Go to last post

  43. SUM funtion for cells in row containing both string AND with specified month

    Started by Chairman_Wu‎, 02-15-2019 12:57 PM
    2 Attachment(s)
    • 3
    • 356
    FlameRetired
    02-15-2019, 06:43 PM Go to last post

  44. Replace words by numbers and calculate mean II

    Started by anahochmanova‎, 02-15-2019 03:36 PM
    2 Attachment(s)
    • 2
    • 316
    alansidman
    02-15-2019, 06:12 PM Go to last post

  45. [SOLVED] Use SUMIF with VLOOKUP or any other way

    Started by k_gitnos‎, 02-15-2019 01:57 PM
    sumif, vlookup 1 Attachment(s)
    • 5
    • 446
    jason.b75
    02-15-2019, 06:11 PM Go to last post

  46. [SOLVED] Replace words by numbers and calculate mean

    Started by anahochmanova‎, 02-02-2019 01:50 PM
    mean(average) 4 Attachment(s)
    • 7
    • 565
    anahochmanova
    02-15-2019, 05:30 PM Go to last post

  47. List INCLUDING repeat values

    Started by PingTing‎, 02-15-2019 03:33 PM
    1 Attachment(s)
    • 7
    • 298
    Fluff13
    02-15-2019, 04:39 PM Go to last post

  48. [SOLVED] pulling out groups from master list

    Started by chriswrcg‎, 02-14-2019 03:32 PM
    3 Attachment(s)
    • 4
    • 467
    FlameRetired
    02-15-2019, 02:01 PM Go to last post

  49. [SOLVED] Multipl IF between 2 values (But 3 differnet values)

    Started by pmw19800‎, 02-15-2019 04:10 AM
    1 Attachment(s)
    • 6
    • 302
    FlameRetired
    02-15-2019, 01:10 PM Go to last post

  50. Sum on Multiple Sheets based on Single Condition

    Started by ceranes‎, 02-15-2019 11:03 AM
    2 Attachment(s)
    • 9
    • 398
    ceranes
    02-15-2019, 01:00 PM Go to last post
+ Post New Thread
Page 1000 of 5611 FirstFirst ... 1000 ...

Forum Information and Options

Users Browsing this Forum

There are currently 63 users browsing this forum. (0 members & 63 guests)

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