+ Post New Thread
Page 1501 of 5614 FirstFirst ... 1501 ...
Threads 75001 to 75050 of 280657

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

  1. [SOLVED] how to change the number index in column A to column E

    Started by hktom‎, 02-03-2017 04:05 AM
    1 Attachment(s)
    • 5
    • 367
    hktom
    02-03-2017, 08:23 AM Go to last post

  2. Cool Formula - cut from 3 lines to 1 line

    Started by Travman1986‎, 02-03-2017 06:12 AM
    1 Attachment(s)
    • 1
    • 270
    JohnTopley
    02-03-2017, 07:27 AM Go to last post

  3. Conditional Formatting Formula Assistance

    Started by SH1988‎, 02-03-2017 06:16 AM
    2 Attachment(s)
    • 5
    • 503
    Glenn Kennedy
    02-03-2017, 07:26 AM Go to last post

  4. Sumproduct or multiple sumif's, I think?

    Started by chadboehne‎, 02-02-2017 08:02 PM
    • 4
    • 416
    Pete_UK
    02-03-2017, 06:20 AM Go to last post

  5. Need an excel spreadsheet with formuals for Sales ROI

    Started by PNaik‎, 01-02-2017 08:14 AM
    • 6
    • 851
    PNaik
    02-03-2017, 04:11 AM Go to last post

  6. [SOLVED] Nested ifs with 2 index and 2 matches

    Started by bambino86‎, 02-03-2017 02:38 AM
    1 Attachment(s)
    • 3
    • 401
    JohnTopley
    02-03-2017, 03:39 AM Go to last post

  7. [SOLVED] If Date in Column A = Today, Then Copy (Value, Value, Value, Value, Value, Value, Value)

    Started by Ourukai‎, 02-02-2017 02:49 PM
    1 Attachment(s)
    • 8
    • 545
    Ourukai
    02-03-2017, 02:13 AM Go to last post

  8. [SOLVED] Transposition of Part of a Dataset - Formula?

    Started by AliGW‎, 02-02-2017 08:35 AM
    1 Attachment(s)
    • 11
    • 436
    TMS
    02-03-2017, 01:56 AM Go to last post

  9. Miroring Conditional format

    Started by ahuang3433‎, 02-02-2017 01:25 PM
    1 Attachment(s)
    • 9
    • 444
    FDibbins
    02-03-2017, 01:56 AM Go to last post

  10. [SOLVED] index - max date if cell is >50

    Started by jackf-nc‎, 01-24-2017 11:02 PM
    1 Attachment(s)
    • 15
    • 624
    FlameRetired
    02-03-2017, 01:00 AM Go to last post

  11. [SOLVED] Formula too long, need to condense it.

    Started by travel23845‎, 02-02-2017 08:24 PM
    • 3
    • 362
    travel23845
    02-03-2017, 12:10 AM Go to last post

  12. Question Extracting numbers out of a string with alpha/number characters that are different lengths

    Started by cs566‎, 02-02-2017 08:47 PM
    delimiter, excel formula, string functions, text and number
    • 5
    • 626
    Tony Valko
    02-02-2017, 09:11 PM Go to last post

  13. [SOLVED] Formula to convert Month name to digit

    Started by rizmomin‎, 02-02-2017 08:49 PM
    • 4
    • 415
    Tony Valko
    02-02-2017, 09:05 PM Go to last post

  14. [SOLVED] If false then check next row (No blanks in list) formula

    Started by WanderingMike‎, 01-29-2017 06:50 PM
    blank, check, false, formula
    • 8
    • 1,712
    Tony Valko
    02-02-2017, 07:37 PM Go to last post

  15. [SOLVED] Table that will show if person has completed particlar training

    Started by TAMMY32‎, 01-31-2017 04:00 PM
    1 Attachment(s)
    • 8
    • 525
    FlameRetired
    02-02-2017, 06:28 PM Go to last post

  16. [SOLVED] COUNTIFS with distinct values for one condition

    Started by HeyInKy‎, 02-02-2017 12:15 PM
    1 Attachment(s)
    • 5
    • 2,645
    Tony Valko
    02-02-2017, 05:49 PM Go to last post

  17. Dragging a vlookup formula

    Started by matt_c_l‎, 02-02-2017 04:14 PM
    • 4
    • 956
    dflak
    02-02-2017, 05:19 PM Go to last post

  18. Finding a date greater than

    Started by ms.fb‎, 02-02-2017 04:29 PM
    • 3
    • 243
    José Augusto
    02-02-2017, 05:00 PM Go to last post

  19. Find unique value in one column, then any corresponding values in adjacent column

    Started by K-Dog‎, 01-31-2017 08:46 PM
    7 Attachment(s)
    • 17
    • 1,885
    JohnTopley
    02-02-2017, 04:13 PM Go to last post

  20. Finding next row of information

    Started by toongal12‎, 02-02-2017 12:57 PM
    index-match
    • 1
    • 472
    toongal12
    02-02-2017, 02:52 PM Go to last post

  21. [SOLVED] Trying to create time tracker that stops at 40hrs and then splits the OT separately

    Started by taylorsm‎, 02-01-2017 05:56 PM
    1 Attachment(s)
    • 2
    • 358
    taylorsm
    02-02-2017, 02:44 PM Go to last post

  22. Question Date format conversion - help with formula

    Started by maillme‎, 02-02-2017 04:21 AM
    • 4
    • 420
    FDibbins
    02-02-2017, 02:43 PM Go to last post

  23. [SOLVED] SUMIF not quite working

    Started by Hoddie‎, 02-02-2017 11:13 AM
    2 Attachment(s)
    • 8
    • 541
    Tony Valko
    02-02-2017, 02:14 PM Go to last post

  24. [SOLVED] I need to COUNTIF when greater than today, but ignore duplicates

    Started by taylorsm‎, 02-02-2017 10:37 AM
    1 Attachment(s)
    • 4
    • 360
    Tony Valko
    02-02-2017, 02:11 PM Go to last post

  25. Combining two reports - Need to find value in two columns and place it into another

    Started by SchoolPrincipalNJ13‎, 02-02-2017 01:06 PM
    3 Attachment(s)
    • 1
    • 225
    José Augusto
    02-02-2017, 01:42 PM Go to last post

  26. Vlookup?

    Started by annac113‎, 02-01-2017 02:43 PM
    2 Attachment(s)
    • 9
    • 377
    Tony Valko
    02-02-2017, 01:33 PM Go to last post

  27. [SOLVED] if, sumproduct help

    Started by jilaba‎, 02-01-2017 10:34 PM
    1 Attachment(s)
    • 3
    • 329
    jilaba
    02-02-2017, 01:05 PM Go to last post

  28. Searching for unique values in row or column

    Started by Ejje‎, 02-02-2017 11:49 AM
    • 2
    • 283
    Tony Valko
    02-02-2017, 12:02 PM Go to last post

  29. [SOLVED] How to add multiple VLOOKUPS to part of an IF formula

    Started by Alice21‎, 02-02-2017 07:56 AM
    3 Attachment(s)
    • 8
    • 555
    Alice21
    02-02-2017, 11:49 AM Go to last post

  30. [SOLVED] How can I remove the tax from a total to get the pre tax value for New York (8.875%)

    Started by thursday140‎, 02-01-2017 12:04 PM
    • 6
    • 498
    Logit
    02-02-2017, 11:19 AM Go to last post

  31. [SOLVED] Sumif formula help

    Started by ImranBhatti‎, 02-02-2017 10:41 AM
    1 Attachment(s)
    • 3
    • 373
    ImranBhatti
    02-02-2017, 11:09 AM Go to last post

  32. [SOLVED] Date conversion - Excel presents system report date incorrectly

    Started by Fred Johs‎, 02-01-2017 06:30 AM
    • 12
    • 1,323
    kev_
    02-02-2017, 10:26 AM Go to last post

  33. [SOLVED] Change values of table by percentage in certain cell

    Started by perko121‎, 02-01-2017 10:31 AM
    4 Attachment(s)
    • 15
    • 699
    dflak
    02-02-2017, 09:52 AM Go to last post

  34. [SOLVED] Count Problem

    Started by Travman1986‎, 02-02-2017 08:16 AM
    1 Attachment(s)
    • 3
    • 427
    Travman1986
    02-02-2017, 08:33 AM Go to last post

  35. Red face [SOLVED] Linking Formulas?

    Started by Britt Hounslow‎, 01-10-2017 06:02 AM
    3 Attachment(s)
    • 14
    • 489
    Pete_UK
    02-02-2017, 07:43 AM Go to last post

  36. Unique Partner Name based on week and region

    Started by Sanjibghosh‎, 02-01-2017 07:44 AM
    1 Attachment(s)
    • 8
    • 384
    Glenn Kennedy
    02-02-2017, 07:28 AM Go to last post

  37. [SOLVED] Count Add (in Column H) with blank in Column N

    Started by Sekars‎, 02-02-2017 04:34 AM
    1 Attachment(s)
    • 2
    • 237
    Sekars
    02-02-2017, 05:26 AM Go to last post

  38. [SOLVED] Using if Formula with percentage

    Started by ShakJames‎, 02-02-2017 05:05 AM
    • 4
    • 289
    ShakJames
    02-02-2017, 05:18 AM Go to last post

  39. [SOLVED] Formula to work out progression in months

    Started by Jamidd1‎, 02-01-2017 07:27 AM
    1 Attachment(s)
    • 8
    • 393
    Jamidd1
    02-02-2017, 04:38 AM Go to last post

  40. If with And

    Started by bilalo94‎, 02-02-2017 03:03 AM
    • 1
    • 343
    JohnTopley
    02-02-2017, 03:47 AM Go to last post

  41. Comparing Collumn two collumns and returning value from third column

    Started by josephz94‎, 02-02-2017 01:01 AM
    1 Attachment(s)
    • 5
    • 459
    avk
    02-02-2017, 02:31 AM Go to last post

  42. Standard Deviation with Dynamic Sheet names

    Started by bleggins‎, 02-02-2017 01:59 AM
    • 1
    • 356
    AliGW
    02-02-2017, 02:02 AM Go to last post

  43. Index and match formula, attempting to return results with multiple criteria.

    Started by mahalek1976‎, 02-01-2017 02:05 PM
    1 Attachment(s)
    • 5
    • 677
    FDibbins
    02-02-2017, 12:43 AM Go to last post

  44. Post Counting the number of times a word appears with a twist

    Started by laurigardner‎, 01-31-2017 11:06 PM
    3 Attachment(s)
    • 10
    • 599
    Glenn Kennedy
    02-02-2017, 12:37 AM Go to last post

  45. [SOLVED] CountIfs(?) Ignoring Duplicates

    Started by thesonofdarwin‎, 02-01-2017 01:37 PM
    • 4
    • 6,764
    Tony Valko
    02-02-2017, 12:31 AM Go to last post

  46. How to Find value from one column and transfer to another

    Started by randynavarro‎, 02-01-2017 01:52 PM
    2 Attachment(s)
    • 4
    • 317
    randynavarro
    02-01-2017, 11:53 PM Go to last post

  47. [SOLVED] lookup / index or such function to fetch details

    Started by jilaba‎, 02-01-2017 01:51 PM
    1 Attachment(s)
    • 8
    • 582
    jilaba
    02-01-2017, 11:23 PM Go to last post

  48. [SOLVED] Looking for a single formula to calculate tiered Sales Bonus for amounts that exceed $750K

    Started by ppilot‎, 02-01-2017 05:46 PM
    • 4
    • 488
    Phuocam
    02-01-2017, 08:13 PM Go to last post

  49. [SOLVED] Can the Lookup Range of a Vlookup be a Range?

    Started by yamalady‎, 02-01-2017 04:11 PM
    1 Attachment(s)
    • 6
    • 390
    TMS
    02-01-2017, 06:23 PM Go to last post

  50. Standard Deviation with Dynamic Sheet names

    Started by bleggins‎, 02-01-2017 06:10 PM
    • 0
    • 294
    bleggins
    02-01-2017, 06:10 PM Go to last post
+ Post New Thread
Page 1501 of 5614 FirstFirst ... 1501 ...

Forum Information and Options

Users Browsing this Forum

There are currently 72 users browsing this forum. (2 members & 70 guests)

  1. finallymint,
  2. Sam Capricci

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