+ Post New Thread
Page 552 of 5618 FirstFirst ... 552 ...
Threads 27551 to 27600 of 280878

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

  1. FORECAST function and Drop-down

    Started by JCEurovision‎, 02-08-2021 09:49 PM
    2 Attachment(s)
    • 1
    • 333
    JeteMc
    02-13-2021, 07:34 PM Go to last post

  2. [SOLVED] Blank cell formula problem

    Started by lilsnoop‎, 02-13-2021 04:42 PM
    1 Attachment(s)
    • 2
    • 226
    lilsnoop
    02-13-2021, 05:41 PM Go to last post

  3. [SOLVED] compare all coordinate values across two arrays

    Started by Seattlites‎, 02-12-2021 04:58 PM
    3 Attachment(s)
    • 4
    • 339
    Seattlites
    02-13-2021, 03:51 PM Go to last post

  4. [SOLVED] Combine IF and SUM formula

    Started by thedunna‎, 02-13-2021 02:15 PM
    1 Attachment(s)
    • 13
    • 405
    AliGW
    02-13-2021, 03:27 PM Go to last post

  5. [SOLVED] Exatract Values Into Column C if condition is Met

    Started by bjnockle‎, 02-09-2021 04:31 PM
    2 Attachment(s)
    • 7
    • 446
    Glenn Kennedy
    02-13-2021, 03:24 PM Go to last post

  6. [SOLVED] Formula to consolidate data from multiple sheets

    Started by leprince2007‎, 02-10-2021 04:40 PM
    4 Attachment(s)
    • 19
    • 586
    leprince2007
    02-13-2021, 03:07 PM Go to last post

  7. [SOLVED] formula for automatic breakdown

    Started by felixpanganiban‎, 02-13-2021 01:26 PM
    4 Attachment(s)
    • 10
    • 328
    Glenn Kennedy
    02-13-2021, 02:10 PM Go to last post

  8. Multiple dependable searchable drop down lists

    Started by Ma.Sa.‎, 02-13-2021 12:13 PM
    1 Attachment(s)
    • 4
    • 300
    Glenn Kennedy
    02-13-2021, 01:29 PM Go to last post

  9. [SOLVED] Count Number of Events using both Month and Year

    Started by Redders15‎, 02-13-2021 10:43 AM
    2 Attachment(s)
    • 5
    • 322
    AliGW
    02-13-2021, 11:29 AM Go to last post

  10. [SOLVED] Conditional Format IF multiple Criteria Met?

    Started by Keithhe‎, 02-13-2021 11:14 AM
    2 Attachment(s)
    • 3
    • 267
    AliGW
    02-13-2021, 11:27 AM Go to last post

  11. Unhappy [SOLVED] Complicated Formula for Calculating Notice Period

    Started by Chris_010101‎, 09-21-2020 05:34 PM
    1 Attachment(s)
    • 9
    • 1,092
    JeteMc
    02-13-2021, 11:07 AM Go to last post

  12. [SOLVED] Quality Formula with Not Attempt

    Started by Sekar G‎, 02-13-2021 10:26 AM
    1 Attachment(s)
    • 3
    • 296
    AliGW
    02-13-2021, 10:50 AM Go to last post

  13. [SOLVED] if with vlookup

    Started by geniusufo007‎, 02-13-2021 09:48 AM
    2 Attachment(s)
    • 3
    • 227
    AliGW
    02-13-2021, 10:06 AM Go to last post

  14. [SOLVED] Count content of multiple column

    Started by Shinas‎, 02-12-2021 07:07 PM
    1 Attachment(s)
    • 3
    • 281
    TMS
    02-13-2021, 08:49 AM Go to last post

  15. Formula: Lookup and sum duration of specific tasks from Case ID No.

    Started by Amigo1975‎, 02-12-2021 07:20 AM
    dashboard, formula, index, lookup, sum 1 Attachment(s)
    • 10
    • 558
    Glenn Kennedy
    02-13-2021, 06:50 AM Go to last post

  16. Arrow [SOLVED] Conditional time subtraction

    Started by Khaldon‎, 02-11-2021 11:59 AM
    8 Attachment(s)
    • 32
    • 684
    Khaldon
    02-13-2021, 06:32 AM Go to last post

  17. [SOLVED] Improve on COUNTIFS Result

    Started by gra0001‎, 02-12-2021 08:57 PM
    1 Attachment(s)
    • 3
    • 234
    TMS
    02-13-2021, 05:48 AM Go to last post

  18. Adding cells except blanks

    Started by jafeth_b18‎, 02-13-2021 02:32 AM
    4 Attachment(s)
    • 9
    • 317
    L34NN3
    02-13-2021, 05:14 AM Go to last post

  19. [SOLVED] Inventory - MATCH - IF issue

    Started by GolfNut39‎, 02-13-2021 01:01 AM
    1 Attachment(s)
    • 4
    • 299
    GolfNut39
    02-13-2021, 04:30 AM Go to last post

  20. Smile [SOLVED] Required formula to generate Leave Register-Additional Requirement

    Started by GemBox‎, 02-12-2021 02:37 AM
    2 Attachment(s)
    • 3
    • 270
    avk
    02-13-2021, 12:35 AM Go to last post

  21. Calculating SD for BMI

    Started by NDavis77‎, 02-12-2021 09:21 PM
    1 Attachment(s)
    • 3
    • 489
    joeu2004
    02-13-2021, 12:12 AM Go to last post

  22. Advanced find and replace

    Started by fozuk1609‎, 02-12-2021 11:57 AM
    3 Attachment(s)
    • 3
    • 316
    fozuk1609
    02-12-2021, 08:16 PM Go to last post

  23. Lookup formula to return multiple hits on multiple rows and values from multiple columns

    Started by Mattr13‎, 02-08-2021 11:45 AM
    columns, lookup, matrix, multiple, rows 1 Attachment(s)
    • 1
    • 695
    JeteMc
    02-12-2021, 07:21 PM Go to last post

  24. Use hyperlink to jump to a sheet based on 3 options

    Started by mtouhig‎, 02-12-2021 01:36 PM
    • 2
    • 255
    BusterT
    02-12-2021, 06:51 PM Go to last post

  25. [SOLVED] Sum vlookup to summarise data

    Started by STANILZ101‎, 02-12-2021 07:13 AM
    2 Attachment(s)
    • 4
    • 244
    STANILZ101
    02-12-2021, 06:48 PM Go to last post

  26. [SOLVED] Using INDIRECT inside a VLOOKUP formula for another sheet

    Started by VMS1066‎, 02-12-2021 04:50 PM
    1 Attachment(s)
    • 2
    • 257
    VMS1066
    02-12-2021, 05:49 PM Go to last post

  27. [SOLVED] Turnover - Count number of times a cell has a value, but next 2 right cells don't

    Started by Ebiru2387‎, 02-11-2021 06:46 PM
    2 Attachment(s)
    • 3
    • 252
    Ebiru2387
    02-12-2021, 04:36 PM Go to last post

  28. Formula to reference multiple cells for extracting positional characters within a string?

    Started by AGrayson84‎, 02-11-2021 05:35 PM
    6 Attachment(s)
    • 15
    • 357
    AGrayson84
    02-12-2021, 04:01 PM Go to last post

  29. [SOLVED] Adding and multiplying rows with Values Only

    Started by onp‎, 02-12-2021 02:43 PM
    1 Attachment(s)
    • 3
    • 220
    Fluff13
    02-12-2021, 03:41 PM Go to last post

  30. [SOLVED] Lookup Month in Col A and if Col H on same sheet = X display X, otherwise blank.

    Started by endavidson‎, 02-11-2021 12:21 PM
    3 Attachment(s)
    • 4
    • 289
    endavidson
    02-12-2021, 02:56 PM Go to last post

  31. [SOLVED] Sum until a condition is met

    Started by rahulmamtora‎, 02-12-2021 10:45 AM
    2 Attachment(s)
    • 8
    • 889
    Glenn Kennedy
    02-12-2021, 02:52 PM Go to last post

  32. [SOLVED] Complex Conditional Formatting with data from other cells (Calendar)

    Started by proudgeek42‎, 02-09-2021 02:06 PM
    and function, calendar, conditional format, highlight 2 Attachment(s)
    • 5
    • 623
    Pete_UK
    02-12-2021, 02:17 PM Go to last post

  33. Indirect function to another workbook and autofill other cells

    Started by sarahj0630‎, 02-11-2021 05:41 PM
    indirect
    • 3
    • 484
    Pete_UK
    02-12-2021, 02:14 PM Go to last post

  34. [SOLVED] If And with Index and Match ?

    Started by Ron Purpura‎, 02-12-2021 01:19 PM
    2 Attachment(s)
    • 5
    • 241
    Ron Purpura
    02-12-2021, 01:39 PM Go to last post

  35. [SOLVED] calculation with SUMPRODUCT based on date matching

    Started by dineshpatra06‎, 02-11-2021 11:06 AM
    1 Attachment(s)
    • 9
    • 355
    AliGW
    02-12-2021, 01:32 PM Go to last post

  36. [SOLVED] ISNUMBER(SEARCH.... for a specific word

    Started by Keithhe‎, 02-12-2021 12:15 PM
    2 Attachment(s)
    • 5
    • 232
    Glenn Kennedy
    02-12-2021, 01:19 PM Go to last post

  37. Listing existing combinations over 5 columns, and summing values for each

    Started by AndreVz‎, 02-08-2021 07:40 AM
    3 Attachment(s)
    • 1
    • 286
    JeteMc
    02-12-2021, 01:04 PM Go to last post

  38. Count total number of duplicate values and specific text

    Started by exceleratevba‎, 02-12-2021 12:52 PM
    1 Attachment(s)
    • 2
    • 193
    Glenn Kennedy
    02-12-2021, 01:03 PM Go to last post

  39. [SOLVED] Formula to count sequential Number of days

    Started by Redders15‎, 02-12-2021 10:06 AM
    2 Attachment(s)
    • 11
    • 334
    AliGW
    02-12-2021, 01:03 PM Go to last post

  40. [SOLVED] if formula is giving us wrong result

    Started by Ajay45822‎, 02-12-2021 12:19 PM
    formula error 3 Attachment(s)
    • 10
    • 281
    AliGW
    02-12-2021, 12:55 PM Go to last post

  41. Question [SOLVED] how to use conditional format for 3 different digit

    Started by emmr‎, 02-12-2021 12:34 PM
    3 Attachment(s)
    • 6
    • 230
    AliGW
    02-12-2021, 12:54 PM Go to last post

  42. How to search keywords in a sentence

    Started by silmiya‎, 02-01-2021 12:09 PM
    6 Attachment(s)
    • 30
    • 895
    Glenn Kennedy
    02-12-2021, 12:52 PM Go to last post

  43. [SOLVED] How to display particular digits from a text value, with one formula?

    Started by Dexter2‎, 02-12-2021 12:05 AM
    1 Attachment(s)
    • 4
    • 231
    Dexter2
    02-12-2021, 12:27 PM Go to last post

  44. Talking [SOLVED] Return difference between a value and a target value

    Started by Rosemarie Lee‎, 02-12-2021 10:55 AM
    4 Attachment(s)
    • 10
    • 319
    Glenn Kennedy
    02-12-2021, 12:26 PM Go to last post

  45. [SOLVED] Locking formulas and constants from Sheet 1 in Sheet 2

    Started by JanineH‎, 02-11-2021 05:20 AM
    3 Attachment(s)
    • 10
    • 318
    maclearyj
    02-12-2021, 11:53 AM Go to last post

  46. Post [SOLVED] If Cell contains some text from another Cell, then return "True".

    Started by PatricMiller‎, 02-12-2021 11:16 AM
    cell compare, cell contains, contains text, formula, if statement 2 Attachment(s)
    • 5
    • 439
    PatricMiller
    02-12-2021, 11:39 AM Go to last post

  47. Summarise numbers In different columns in a range mixed with text

    Started by patrik.silverby‎, 02-12-2021 10:52 AM
    1 Attachment(s)
    • 2
    • 190
    XLent
    02-12-2021, 11:15 AM Go to last post

  48. Formula / Conditional formatting for overdue dates

    Started by Redders15‎, 02-12-2021 11:09 AM
    1 Attachment(s)
    • 1
    • 209
    AliGW
    02-12-2021, 11:14 AM Go to last post

  49. Automated Employee Department Rotation

    Started by KuehnJohnA‎, 02-11-2021 04:18 PM
    2 Attachment(s)
    • 1
    • 211
    Glenn Kennedy
    02-12-2021, 11:06 AM Go to last post

  50. [SOLVED] 3 Way match

    Started by Sam Bulmer‎, 02-12-2021 09:13 AM
    3 Attachment(s)
    • 6
    • 261
    Glenn Kennedy
    02-12-2021, 10:25 AM Go to last post
+ Post New Thread
Page 552 of 5618 FirstFirst ... 552 ...

Forum Information and Options

Users Browsing this Forum

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

  1. Glaerun,
  2. pfusella,
  3. TMS

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