+ Post New Thread
Page 1001 of 5612 FirstFirst ... 1001 ...
Threads 50001 to 50050 of 280553

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

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

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

  2. Combine percentage formula with dynamic range

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

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

  4. sum cells in 2(or more) conditions

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

  5. [SOLVED] Convert Three Columns to Table

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

  6. Sports athletic meet bib no input

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

  7. Auto Numbering in Excel. Thank you!

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

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

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

  9. [SOLVED] Calculate Visa Renewal Dates

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

  10. Problem with Index/Match Functions

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

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

  12. Taking data from regularly updated table

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

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

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

  15. [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
    • 396
    AndyJr
    02-16-2019, 04:46 PM Go to last post

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

  17. Subtracting non-blank cells only

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

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

  19. 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
    • 491
    Greg M
    02-16-2019, 03:06 PM Go to last post

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

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

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

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

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

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

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

  25. count if formula with link to closed workbook

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

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

  27. [SOLVED] Index/match across multiple sheets

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

  28. large files

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

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

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

  31. Printing

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

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

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

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

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

  36. [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
    • 447
    jason.b75
    02-15-2019, 06:11 PM Go to last post

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

  38. List INCLUDING repeat values

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

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

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

  41. Sum on Multiple Sheets based on Single Condition

    Started by ceranes‎, 02-15-2019 11:03 AM
    2 Attachment(s)
    • 9
    • 399
    ceranes
    02-15-2019, 01:00 PM Go to last post

  42. [SOLVED] vlookup value checking specific criteria from multiple columns

    Started by Lisa4legin‎, 02-14-2019 02:25 PM
    choose columns, vlookup & if 3 Attachment(s)
    • 4
    • 450
    Lisa4legin
    02-15-2019, 12:27 PM Go to last post

  43. return date with 3 sets of criteria

    Started by steddas‎, 02-15-2019 10:35 AM
    1 Attachment(s)
    • 7
    • 257
    steddas
    02-15-2019, 12:02 PM Go to last post

  44. [SOLVED] Tricky formula: is this even possible?

    Started by SomeRoark‎, 02-15-2019 03:57 AM
    2 Attachment(s)
    • 9
    • 341
    shg
    02-15-2019, 11:40 AM Go to last post

  45. [SOLVED] Counting by month and year without array formulas

    Started by hmltnangel‎, 02-15-2019 07:54 AM
    • 2
    • 253
    hmltnangel
    02-15-2019, 11:30 AM Go to last post

  46. [SOLVED] How to modify my CountIf Syntax

    Started by Rev12‎, 02-15-2019 11:01 AM
    • 2
    • 192
    Bo_Ry
    02-15-2019, 11:12 AM Go to last post

  47. Automate Subtracting Quantities

    Started by jarett‎, 02-11-2019 12:36 PM
    1 Attachment(s)
    • 5
    • 373
    jarett
    02-15-2019, 10:55 AM Go to last post

  48. Question How to use vlookup with iferror and if blank?

    Started by cblabey‎, 02-15-2019 09:53 AM
    excel formula help, iferror, vlookup, vlookup & if
    • 2
    • 403
    cblabey
    02-15-2019, 10:33 AM Go to last post

  49. [SOLVED] Formula to find and copy information

    Started by Vregnant‎, 02-13-2019 05:44 PM
    match & index, match and paste 2 Attachment(s)
    • 6
    • 351
    Vregnant
    02-15-2019, 10:07 AM Go to last post

  50. Vlookup to show average number

    Started by Danielnir‎, 02-15-2019 09:36 AM
    • 1
    • 240
    PaulM100
    02-15-2019, 09:53 AM Go to last post
+ Post New Thread
Page 1001 of 5612 FirstFirst ... 1001 ...

Forum Information and Options

Users Browsing this Forum

There are currently 61 users browsing this forum. (3 members & 58 guests)

  1. bekwiet,
  2. Phuocam,
  3. tobiasmass

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