+ Post New Thread
Page 399 of 5614 FirstFirst ... 399 ...
Threads 19901 to 19950 of 280693

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

  1. Highlight the cells that show up more than once in separate lists

    Started by zohan1‎, 11-13-2021 01:17 PM
    2 Attachment(s)
    • 2
    • 243
    zohan1
    11-13-2021, 03:19 PM Go to last post

  2. How to Averageifs last N values based on date and product.

    Started by illusionek‎, 11-12-2021 06:44 AM
    3 Attachment(s)
    • 8
    • 327
    GeoffW283
    11-13-2021, 02:16 PM Go to last post

  3. [SOLVED] Lookup value and return max absolute in a range

    Started by xWiZardx‎, 11-12-2021 02:35 PM
    • 2
    • 229
    nicnaws
    11-13-2021, 02:06 PM Go to last post

  4. Formula result is different from evaluated result

    Started by RaulSerg‎, 11-13-2021 10:23 AM
    2 Attachment(s)
    • 9
    • 274
    RaulSerg
    11-13-2021, 12:46 PM Go to last post

  5. Comparing data across multiple columns

    Started by Cooper13300‎, 11-04-2021 03:20 PM
    3 Attachment(s)
    • 8
    • 395
    JeteMc
    11-13-2021, 10:07 AM Go to last post

  6. Find the Last Occurrence of a Lookup Value between two columns

    Started by caves23‎, 11-12-2021 08:48 PM
    2 Attachment(s)
    • 3
    • 268
    Pete_UK
    11-13-2021, 07:49 AM Go to last post

  7. [SOLVED] formatting highlights last number

    Started by john_cash‎, 11-13-2021 03:51 AM
    1 Attachment(s)
    • 2
    • 384
    john_cash
    11-13-2021, 05:53 AM Go to last post

  8. Post CheckBox and IF functions

    Started by Anth c‎, 11-12-2021 06:35 PM
    checkbox, iffunction, timesheet
    • 2
    • 323
    Anth c
    11-13-2021, 12:14 AM Go to last post

  9. Thumbs up Email ID validation

    Started by kjxavier‎, 11-12-2021 01:40 PM
    email, email address, email validation, excel & formula, excel formula
    • 3
    • 445
    Croweater
    11-12-2021, 10:33 PM Go to last post

  10. Using checkboxes to change cell color...with a twist!

    Started by CreativeName‎, 11-12-2021 08:00 PM
    1 Attachment(s)
    • 3
    • 224
    6StringJazzer
    11-12-2021, 09:11 PM Go to last post

  11. [SOLVED] Formula to Extract MONTH ANd year from a number

    Started by Howardc1001‎, 11-12-2021 07:49 PM
    1 Attachment(s)
    • 3
    • 210
    Pete_UK
    11-12-2021, 09:02 PM Go to last post

  12. Question Rearranging names in one colum

    Started by wellsjp‎, 11-12-2021 06:22 PM
    • 2
    • 200
    Pete_UK
    11-12-2021, 08:45 PM Go to last post

  13. Help with formula for Cash Flow Sheet

    Started by eliassonoliver‎, 11-12-2021 03:54 PM
    3 Attachment(s)
    • 4
    • 257
    janmorris
    11-12-2021, 06:01 PM Go to last post

  14. [SOLVED] Incrementing a number in a formula

    Started by ChestyPuller‎, 11-11-2021 05:43 PM
    1 Attachment(s)
    • 3
    • 224
    TMS
    11-12-2021, 04:50 PM Go to last post

  15. formula greater or less

    Started by xam99‎, 11-12-2021 02:11 PM
    4 Attachment(s)
    • 9
    • 341
    xam99
    11-12-2021, 04:47 PM Go to last post

  16. [SOLVED] How to automate shift pay/time for split shifts with given constraints.

    Started by Dexter2‎, 11-10-2021 11:22 AM
    3 Attachment(s)
    • 14
    • 348
    Dexter2
    11-12-2021, 04:32 PM Go to last post

  17. Formula that tells me if the temp has exceed a temp of 2 degrees for more than an hour.

    Started by greenn424‎, 11-11-2021 11:20 AM
    2 Attachment(s)
    • 7
    • 282
    GeoffW283
    11-12-2021, 02:53 PM Go to last post

  18. [SOLVED] TEXTJOIN in a Spill Array Formula

    Started by DJunqueira‎, 11-12-2021 01:16 PM
    2 Attachment(s)
    • 6
    • 2,632
    DJunqueira
    11-12-2021, 02:33 PM Go to last post

  19. Question How does List selection changes value

    Started by retrostone‎, 10-31-2021 07:47 AM
    3 Attachment(s)
    • 8
    • 325
    JeteMc
    11-12-2021, 02:30 PM Go to last post

  20. [SOLVED] Formula Time calculation 2 variables

    Started by pjbassdc‎, 11-12-2021 10:48 AM
    nested if, variable dependent 2 Attachment(s)
    • 4
    • 283
    JohnTopley
    11-12-2021, 12:42 PM Go to last post

  21. Question [SOLVED] Identify specific conditions between one or more duplicate

    Started by diggadodd‎, 11-12-2021 07:23 AM
    1 Attachment(s)
    • 2
    • 193
    diggadodd
    11-12-2021, 12:41 PM Go to last post

  22. [SOLVED] Spreading contract amount across months by start/end date

    Started by awexy‎, 11-12-2021 11:45 AM
    contract revenue, contract term, revenue, revenue forecast, revenue recognition 2 Attachment(s)
    • 3
    • 390
    Kaper
    11-12-2021, 12:36 PM Go to last post

  23. Formula Help

    Started by crabbyc‎, 11-12-2021 12:00 PM
    • 5
    • 182
    Pete_UK
    11-12-2021, 12:33 PM Go to last post

  24. [SOLVED] Articles by Client

    Started by Vinhas‎, 11-12-2021 11:57 AM
    2 Attachment(s)
    • 3
    • 234
    Pete_UK
    11-12-2021, 12:28 PM Go to last post

  25. [SOLVED] Nesting IF and XLOOKUP functions

    Started by Katterpillar19‎, 11-12-2021 10:52 AM
    1 Attachment(s)
    • 2
    • 292
    Katterpillar19
    11-12-2021, 12:19 PM Go to last post

  26. [SOLVED] Transpose horizontal to vertical

    Started by akalien‎, 11-12-2021 06:56 AM
    5 Attachment(s)
    • 11
    • 414
    Pete_UK
    11-12-2021, 12:09 PM Go to last post

  27. Nearest coordinates 3d distance - surveyor

    Started by piosta‎, 11-12-2021 09:53 AM
    3d distance, closest value, coordinates, surveyor 3 Attachment(s)
    • 2
    • 310
    MarvinP
    11-12-2021, 11:03 AM Go to last post

  28. Calculate total of previous full 3 weeks

    Started by cableghost‎, 11-12-2021 12:38 AM
    max, sum
    • 5
    • 474
    cableghost
    11-12-2021, 10:06 AM Go to last post

  29. [SOLVED] charts ..make it linked up to current month

    Started by DEEARO‎, 11-12-2021 07:15 AM
    1 Attachment(s)
    • 1
    • 238
    Greg M
    11-12-2021, 09:56 AM Go to last post

  30. TEXTJOIN and IF Array

    Started by mrmacs‎, 11-12-2021 08:34 AM
    array, textjoin 1 Attachment(s)
    • 1
    • 308
    AliGW
    11-12-2021, 08:51 AM Go to last post

  31. Post CountIF between Time ranges

    Started by Loukki‎, 11-12-2021 08:02 AM
    countif countifs 3 Attachment(s)
    • 1
    • 241
    6StringJazzer
    11-12-2021, 08:48 AM Go to last post

  32. AverageIf on a Filtered List

    Started by LPDTC‎, 11-12-2021 07:59 AM
    1 Attachment(s)
    • 2
    • 184
    LPDTC
    11-12-2021, 08:18 AM Go to last post

  33. [SOLVED] SUM IFS Not adding up correctly

    Started by DEEARO‎, 11-12-2021 04:59 AM
    2 Attachment(s)
    • 2
    • 295
    AliGW
    11-12-2021, 07:16 AM Go to last post

  34. Changing a number that appears in cell depending on content

    Started by craigc0187‎, 11-12-2021 05:43 AM
    • 5
    • 184
    JohnTopley
    11-12-2021, 07:05 AM Go to last post

  35. [SOLVED] Help with finding number from second table depending on parameters set

    Started by vintage89‎, 11-12-2021 04:24 AM
    4 Attachment(s)
    • 9
    • 242
    AliGW
    11-12-2021, 06:28 AM Go to last post

  36. [SOLVED] Dynamically copy row to another sheet if match "See Notes"

    Started by lovethycat‎, 11-11-2021 11:16 AM
    2 Attachment(s)
    • 10
    • 276
    CARACALLA
    11-12-2021, 05:36 AM Go to last post

  37. Need rules to tell me what to update

    Started by Kazzaw‎, 11-05-2021 12:03 AM
    7 Attachment(s)
    • 15
    • 552
    KOKOSEK
    11-12-2021, 04:13 AM Go to last post

  38. Sorting cells with coordinates to match in different columns

    Started by Bjorn85‎, 11-11-2021 06:47 AM
    2 Attachment(s)
    • 6
    • 229
    Bjorn85
    11-12-2021, 03:42 AM Go to last post

  39. [SOLVED] Nonblank values from a row and the corresponding values from another row to use in formula

    Started by docGee‎, 11-11-2021 06:12 PM
    excel formula help 2 Attachment(s)
    • 3
    • 374
    GeoffW283
    11-11-2021, 10:24 PM Go to last post

  40. [SOLVED] Formula adds a zero to the final value

    Started by Luisftv‎, 11-11-2021 07:52 PM
    1 Attachment(s)
    • 5
    • 262
    TMS
    11-11-2021, 08:46 PM Go to last post

  41. Unhappy IF this (Book 1, Sheet 1, Column C) = THAT (Book 2, Sheet 1, Column F) THEN????

    Started by walkerneedshelp‎, 11-11-2021 02:24 AM
    help challenging problem
    • 3
    • 273
    Sam Capricci
    11-11-2021, 05:54 PM Go to last post

  42. Copy Today() to another cell, where it won't change

    Started by mstgier‎, 11-07-2021 10:20 AM
    formula, today()
    • 3
    • 325
    janmorris
    11-11-2021, 05:26 PM Go to last post

  43. [SOLVED] SUMIFS and date in formula

    Started by CAPapps‎, 11-11-2021 05:12 PM
    • 4
    • 205
    FlameRetired
    11-11-2021, 05:26 PM Go to last post

  44. Looking for a formula to count consecutive blank cells

    Started by Swieser‎, 11-11-2021 04:58 PM
    • 4
    • 211
    FlameRetired
    11-11-2021, 05:23 PM Go to last post

  45. [SOLVED] Formula help - on specific values

    Started by Smashsmash‎, 11-11-2021 03:28 PM
    2 Attachment(s)
    • 7
    • 209
    etaf
    11-11-2021, 04:38 PM Go to last post

  46. index match excel with negative and positive numbers

    Started by samiitr‎, 11-11-2021 01:01 PM
    1 Attachment(s)
    • 6
    • 822
    WideBoyDixon
    11-11-2021, 03:46 PM Go to last post

  47. [SOLVED] How to autofill a column depending on data in another column

    Started by samashlit‎, 11-10-2021 03:44 PM
    3 Attachment(s)
    • 5
    • 230
    samashlit
    11-11-2021, 03:37 PM Go to last post

  48. [SOLVED] Repeating the values from previous row whe a row is all zeros

    Started by GentlemanGeo‎, 11-10-2021 11:53 PM
    3 Attachment(s)
    • 6
    • 279
    GentlemanGeo
    11-11-2021, 02:34 PM Go to last post

  49. [SOLVED] formatting cell number positive_negative

    Started by xam99‎, 11-11-2021 12:13 PM
    2 Attachment(s)
    • 5
    • 243
    TMS
    11-11-2021, 02:33 PM Go to last post

  50. [SOLVED] Counting cells with data in them while containing a formula

    Started by glide2131‎, 11-10-2021 08:26 PM
    1 Attachment(s)
    • 2
    • 193
    glide2131
    11-11-2021, 02:30 PM Go to last post
+ Post New Thread
Page 399 of 5614 FirstFirst ... 399 ...

Forum Information and Options

Users Browsing this Forum

There are currently 58 users browsing this forum. (5 members & 53 guests)

  1. 9411john,
  2. angelosison00,
  3. metrostar,
  4. RaulSerg,
  5. 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