+ Post New Thread
Page 481 of 5614 FirstFirst ... 481 ...
Threads 24001 to 24050 of 280685

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

  1. [SOLVED] Change formula from equals to does not equal

    Started by matrixpom‎, 06-06-2021 07:10 PM
    • 5
    • 281
    bebo021999
    06-08-2021, 12:34 AM Go to last post

  2. can not get this formula to work

    Started by campbell millar‎, 06-07-2021 08:54 PM
    • 1
    • 151
    sgstevenlow
    06-07-2021, 09:08 PM Go to last post

  3. Question AVERAGEIFS function not working in some of the data sheets

    Started by mostafa.elnazer‎, 04-26-2021 08:36 AM
    averageifs 6 Attachment(s)
    • 12
    • 492
    mostafa.elnazer
    06-07-2021, 08:14 PM Go to last post

  4. SUMIFS - Multiple Conditions

    Started by alreadybeen23‎, 06-07-2021 04:15 PM
    1 Attachment(s)
    • 2
    • 279
    Pete_UK
    06-07-2021, 05:55 PM Go to last post

  5. Text Formula with Date where the date can still caculate

    Started by Stryfe‎, 06-07-2021 12:25 PM
    • 3
    • 181
    Estevaoba
    06-07-2021, 03:35 PM Go to last post

  6. [SOLVED] Dragging SUMIFS function through table changes the array reference?

    Started by cph020283‎, 06-07-2021 02:43 PM
    2 Attachment(s)
    • 4
    • 1,521
    cph020283
    06-07-2021, 03:16 PM Go to last post

  7. [SOLVED] Overlapping dates

    Started by Berna11‎, 06-07-2021 10:48 AM
    4 Attachment(s)
    • 9
    • 380
    Richard Buttrey
    06-07-2021, 02:32 PM Go to last post

  8. Question [SOLVED] how many times number occured in a cell?(or how many plus signs in cell)+1

    Started by tta.akmal‎, 06-06-2021 02:53 AM
    3 Attachment(s)
    • 6
    • 320
    tta.akmal
    06-07-2021, 02:26 PM Go to last post

  9. [SOLVED] Conditional formatting trouble

    Started by jason.hampton‎, 06-07-2021 12:54 PM
    2 Attachment(s)
    • 2
    • 236
    jason.hampton
    06-07-2021, 01:33 PM Go to last post

  10. Vlookup

    Started by obee100uk‎, 06-07-2021 11:55 AM
    • 1
    • 199
    AliGW
    06-07-2021, 11:57 AM Go to last post

  11. Need A cleaner Formula / Function

    Started by Toolman954‎, 06-04-2021 03:52 PM
    if/or formula, if/or function
    • 7
    • 531
    Toolman954
    06-07-2021, 11:37 AM Go to last post

  12. Average Multiple Rows in Multiple Columns Based off Multiple Criteria Points

    Started by Chendrix‎, 06-06-2021 10:58 AM
    5 Attachment(s)
    • 14
    • 688
    JohnTopley
    06-07-2021, 11:31 AM Go to last post

  13. Truck Logistics Optimization Template

    Started by dw_22801‎, 05-31-2021 10:46 PM
    • 4
    • 555
    dw_22801
    06-07-2021, 10:20 AM Go to last post

  14. [SOLVED] Conditional Formatting with Slicers - losing formats

    Started by aleksTO‎, 06-07-2021 08:50 AM
    1 Attachment(s)
    • 0
    • 366
    aleksTO
    06-07-2021, 08:50 AM Go to last post

  15. Unique/conditional count formula

    Started by smclen‎, 06-06-2021 07:17 PM
    1 Attachment(s)
    • 7
    • 389
    davsth
    06-07-2021, 08:47 AM Go to last post

  16. [SOLVED] Overtime calculation - IF function or Sumif

    Started by melan‎, 05-25-2021 08:06 AM
    3 Attachment(s)
    • 17
    • 638
    JeteMc
    06-07-2021, 08:45 AM Go to last post

  17. Lightbulb Using formulas, is it possible to distribute a figure between specific columns

    Started by Richardr35‎, 06-07-2021 06:51 AM
    corresponding periods, distribution, formula and functions 2 Attachment(s)
    • 3
    • 334
    Richardr35
    06-07-2021, 08:34 AM Go to last post

  18. [SOLVED] vlookup not working at all

    Started by serenasist‎, 06-07-2021 05:33 AM
    • 3
    • 268
    JohnTopley
    06-07-2021, 07:49 AM Go to last post

  19. [SOLVED] If great than formula into one cell but reading from two cells

    Started by Lwamp‎, 06-07-2021 05:09 AM
    1 Attachment(s)
    • 4
    • 244
    JohnTopley
    06-07-2021, 07:48 AM Go to last post

  20. [SOLVED] Rearrange comma-separated values based on prefix

    Started by Excite‎, 06-07-2021 04:37 AM
    1 Attachment(s)
    • 3
    • 245
    TMS
    06-07-2021, 07:06 AM Go to last post

  21. VLookup Multiple Columns

    Started by andygrah‎, 06-07-2021 05:22 AM
    1 Attachment(s)
    • 3
    • 251
    andygrah
    06-07-2021, 05:57 AM Go to last post

  22. Excel Formula - How many duplicates in Column B per Name (Column A)?

    Started by alreadybeen23‎, 06-06-2021 09:59 PM
    excel 2 Attachment(s)
    • 4
    • 269
    wk9128
    06-07-2021, 05:36 AM Go to last post

  23. Cool Random number generator

    Started by KellyAustralia‎, 06-02-2021 10:53 PM
    4 Attachment(s)
    • 9
    • 411
    davsth
    06-07-2021, 05:09 AM Go to last post

  24. [SOLVED] Compare Columns using Cell Values

    Started by mailtoashok13‎, 06-06-2021 05:09 AM
    exce function, excel & formula 1 Attachment(s)
    • 8
    • 538
    bebo021999
    06-07-2021, 04:43 AM Go to last post

  25. [SOLVED] Fetching true / false based on product in same order ID

    Started by Jonneh2k‎, 06-07-2021 02:27 AM
    1 Attachment(s)
    • 2
    • 237
    Jonneh2k
    06-07-2021, 03:04 AM Go to last post

  26. Lengths to be divided based on Priority Stretches

    Started by chowdaryharsha‎, 06-06-2021 12:22 AM
    2 Attachment(s)
    • 8
    • 359
    kvsrinivasamurthy
    06-07-2021, 02:35 AM Go to last post

  27. Convert Range to HTML, then paste to Word, then Save as PDF

    Started by Lee_of_Excel‎, 06-06-2021 10:18 PM
    2 Attachment(s)
    • 8
    • 605
    macropod
    06-07-2021, 12:28 AM Go to last post

  28. [SOLVED] How to automate capturing the cell references

    Started by plumberef‎, 06-06-2021 10:12 AM
    3 Attachment(s)
    • 7
    • 305
    plumberef
    06-06-2021, 11:59 PM Go to last post

  29. traffic sign for kpi

    Started by shamsu203‎, 06-06-2021 02:34 AM
    3 Attachment(s)
    • 7
    • 387
    kvsrinivasamurthy
    06-06-2021, 11:14 PM Go to last post

  30. unique/distinct count within a day

    Started by td3201‎, 06-06-2021 10:41 PM
    • 1
    • 163
    Gregb11
    06-06-2021, 11:06 PM Go to last post

  31. [SOLVED] Combining two if statements

    Started by NLidddell‎, 06-06-2021 08:14 PM
    1 Attachment(s)
    • 3
    • 217
    6StringJazzer
    06-06-2021, 09:41 PM Go to last post

  32. Exclamation [SOLVED] IF, AND, OR Function:True is equation with neg result, False is equation with pos result

    Started by MrSurveyor‎, 06-06-2021 05:09 PM
    negative equation factor, nested equations, results in a negative 2 Attachment(s)
    • 7
    • 318
    wk9128
    06-06-2021, 07:18 PM Go to last post

  33. Find multiple Key Word in Column that is in multiple sequence forms

    Started by Chendrix‎, 06-06-2021 05:10 PM
    3 Attachment(s)
    • 2
    • 297
    Chendrix
    06-06-2021, 06:06 PM Go to last post

  34. [SOLVED] Is it possible to cycle relative to absolute reference in more than one selection in a Mac

    Started by so_fistica_ted‎, 06-05-2021 11:57 AM
    • 6
    • 277
    so_fistica_ted
    06-06-2021, 05:52 PM Go to last post

  35. [SOLVED] Transpose Unique Values from tow columns to a row

    Started by chullan88‎, 04-09-2017 07:20 AM
    2 Attachment(s)
    • 6
    • 7,903
    Scotland-0
    06-06-2021, 04:32 PM Go to last post

  36. [SOLVED] Formula or macro that will count the first positive in a set of percentages

    Started by lar9149‎, 06-04-2021 12:51 PM
    3 Attachment(s)
    • 12
    • 390
    mehmetcik
    06-06-2021, 03:41 PM Go to last post

  37. [SOLVED] A Formula for Auto Filter

    Started by soleimani1967‎, 06-01-2021 03:52 PM
    2 Attachment(s)
    • 5
    • 336
    JeteMc
    06-06-2021, 03:09 PM Go to last post

  38. Calculating Future Value but with contributions and deductions at different frequencies

    Started by JR73‎, 06-04-2021 04:33 AM
    • 2
    • 363
    joeu2004
    06-06-2021, 02:51 PM Go to last post

  39. Question [SOLVED] Please help get INDIRECT inside INDEX to function across different worksheets

    Started by Silent_Broccoli_Dish‎, 06-06-2021 10:47 AM
    index, indirect 1 Attachment(s)
    • 3
    • 452
    JohnTopley
    06-06-2021, 02:46 PM Go to last post

  40. Filters based on alphabets from A-Z

    Started by asad.ermo‎, 06-06-2021 11:38 AM
    2 Attachment(s)
    • 2
    • 195
    JohnTopley
    06-06-2021, 02:45 PM Go to last post

  41. [SOLVED] How to remove time from date in a cell. How to get complete number without exponential

    Started by Pawnar‎, 06-06-2021 11:14 AM
    3 Attachment(s)
    • 4
    • 277
    Pawnar
    06-06-2021, 12:17 PM Go to last post

  42. [SOLVED] Cell value multiplication, by criteria.

    Started by windzz‎, 06-05-2021 03:45 AM
    7 Attachment(s)
    • 8
    • 378
    windzz
    06-06-2021, 11:21 AM Go to last post

  43. Question Formula for bonus setup

    Started by MG74‎, 06-01-2021 04:06 PM
    2 Attachment(s)
    • 17
    • 625
    JohnTopley
    06-06-2021, 11:08 AM Go to last post

  44. [SOLVED] Help with sorting vaules by date taken from table

    Started by pieceinc‎, 06-04-2021 11:53 PM
    3 Attachment(s)
    • 14
    • 493
    Fluff13
    06-06-2021, 09:31 AM Go to last post

  45. [SOLVED] Multiple criteria Lookup value between two numbers

    Started by krakha‎, 06-06-2021 05:36 AM
    1 Attachment(s)
    • 6
    • 319
    krakha
    06-06-2021, 07:42 AM Go to last post

  46. INDEX-MATCH formula to conditionally compile missing data

    Started by msta4ord93‎, 05-25-2021 03:04 PM
    4 Attachment(s)
    • 4
    • 413
    Gregb11
    06-06-2021, 07:37 AM Go to last post

  47. [SOLVED] Summarize the data to make it continuous

    Started by chowdaryharsha‎, 06-06-2021 12:17 AM
    4 Attachment(s)
    • 10
    • 340
    Croweater
    06-06-2021, 04:29 AM Go to last post

  48. [SOLVED] consecutive coloring

    Started by Berna11‎, 06-05-2021 03:41 AM
    2 Attachment(s)
    • 5
    • 279
    Berna11
    06-06-2021, 03:46 AM Go to last post

  49. How to change date format

    Started by goodboy‎, 06-05-2021 12:51 PM
    1 Attachment(s)
    • 11
    • 315
    JohnTopley
    06-06-2021, 03:05 AM Go to last post

  50. [SOLVED] Substitute formula

    Started by Carrol‎, 06-05-2021 10:52 AM
    2 Attachment(s)
    • 4
    • 275
    AliGW
    06-06-2021, 02:20 AM Go to last post
+ Post New Thread
Page 481 of 5614 FirstFirst ... 481 ...

Forum Information and Options

Users Browsing this Forum

There are currently 58 users browsing this forum. (2 members & 56 guests)

  1. AliGW,
  2. CARACALLA

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