+ Post New Thread
Page 201 of 5614 FirstFirst ... 201 ...
Threads 10001 to 10050 of 280680

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

  1. Missing parenthenses ? =roundup((C4/(1-D4,1))

    Started by zjadh123‎, 12-15-2022 04:35 AM
    • 3
    • 201
    sandy666
    12-15-2022, 05:34 AM Go to last post

  2. SUM cell based on header

    Started by muss1210‎, 12-15-2022 05:21 AM
    • 2
    • 154
    avk
    12-15-2022, 05:32 AM Go to last post

  3. [SOLVED] Calculation of a cumulative penalty with 2 different penalty rates

    Started by Mr_Muts‎, 12-14-2022 03:48 AM
    5 Attachment(s)
    • 7
    • 677
    Mr_Muts
    12-15-2022, 04:57 AM Go to last post

  4. Question Time averages not calculating properly

    Started by lindaRoth‎, 12-14-2022 11:20 AM
    5 Attachment(s)
    • 14
    • 421
    Pepe Le Mokko
    12-15-2022, 04:32 AM Go to last post

  5. Help with creating a monthly budget planner

    Started by electriczen‎, 12-12-2012 11:30 AM
    1 Attachment(s)
    • 1
    • 676
    mannas34
    12-15-2022, 04:09 AM Go to last post

  6. [SOLVED] Formula to calculate % based on price range

    Started by positivemind‎, 12-15-2022 02:22 AM
    2 Attachment(s)
    • 2
    • 154
    positivemind
    12-15-2022, 03:00 AM Go to last post

  7. Converting table of data into a list

    Started by cpm8504‎, 12-14-2022 12:59 PM
    6 Attachment(s)
    • 7
    • 323
    sandy666
    12-14-2022, 11:26 PM Go to last post

  8. [SOLVED] Need correct formula to pull specific data from a list payees

    Started by Fred Houck‎, 12-13-2022 11:57 PM
    2 Attachment(s)
    • 4
    • 219
    Fred Houck
    12-14-2022, 08:38 PM Go to last post

  9. [SOLVED] Date and Time STRING/TEXT to Actual Date Time

    Started by NewYears1978‎, 11-02-2022 10:32 AM
    3 Attachment(s)
    • 6
    • 327
    sandy666
    12-14-2022, 06:06 PM Go to last post

  10. [SOLVED] How to find prior result with same category and subtract

    Started by billrogers184‎, 12-14-2022 04:33 PM
    1 Attachment(s)
    • 3
    • 164
    dosydos
    12-14-2022, 05:14 PM Go to last post

  11. [SOLVED] Why doesn't LET work whereas it's nested components COUNTA(UNIQUE(FILTER())) do work?

    Started by akedm‎, 12-12-2022 06:11 PM
    2 Attachment(s)
    • 6
    • 318
    Fluff13
    12-14-2022, 04:42 PM Go to last post

  12. Vlookup Help?

    Started by truchamp‎, 12-14-2022 03:25 PM
    hlookup, vlookup 1 Attachment(s)
    • 4
    • 220
    truchamp
    12-14-2022, 04:28 PM Go to last post

  13. [SOLVED] Conditional Formatting using CHOOSE - Is it possible?

    Started by akedm‎, 12-14-2022 03:28 PM
    • 2
    • 215
    akedm
    12-14-2022, 04:26 PM Go to last post

  14. Formula to compare two dates and return the later one

    Started by kailaingrid‎, 12-14-2022 02:40 PM
    • 9
    • 238
    TMS
    12-14-2022, 04:19 PM Go to last post

  15. #Spill error message

    Started by TeacherWart‎, 12-12-2022 08:58 PM
    #spill error, formula assistance 4 Attachment(s)
    • 13
    • 391
    Fluff13
    12-14-2022, 03:14 PM Go to last post

  16. [SOLVED] Lookup with unique ID and match date by month

    Started by gee83‎, 12-09-2022 10:04 AM
    3 Attachment(s)
    • 6
    • 504
    HansDouwe
    12-14-2022, 01:44 PM Go to last post

  17. Question Randomly assign tasks evenly to user by groups restriction

    Started by WhiteBunny‎, 12-14-2022 09:41 AM
    filter, rand() 1 Attachment(s)
    • 2
    • 400
    MarvinP
    12-14-2022, 12:46 PM Go to last post

  18. Identify Top 2 and Lowest 2 Value and include in Comment.

    Started by RaghavaRock‎, 12-14-2022 10:07 AM
    3 Attachment(s)
    • 4
    • 239
    dosydos
    12-14-2022, 12:30 PM Go to last post

  19. [SOLVED] Enter todays date next to text using if error

    Started by thursday140‎, 12-14-2022 12:10 PM
    1 Attachment(s)
    • 2
    • 181
    Pepe Le Mokko
    12-14-2022, 12:16 PM Go to last post

  20. Probability dist

    Started by IknowNOt‎, 12-11-2022 07:34 AM
    2 Attachment(s)
    • 11
    • 329
    MrShorty
    12-14-2022, 12:05 PM Go to last post

  21. [SOLVED] Concatenate long list with punctuation (email list)

    Started by cathyrd‎, 11-05-2015 03:13 PM
    concatenate, list, text 2 Attachment(s)
    • 16
    • 12,185
    carriecat2425
    12-14-2022, 11:45 AM Go to last post

  22. How to stop Excel from changing a file path in a formula

    Started by david killoran‎, 03-09-2019 01:12 PM
    absolute, absolute file path, excel changes file path, file path, formula
    • 12
    • 9,552
    AliGW
    12-14-2022, 09:53 AM Go to last post

  23. [SOLVED] Created Sumifs formula but doesnt work when table is sorted

    Started by batjl9‎, 12-13-2022 01:31 PM
    1 Attachment(s)
    • 3
    • 259
    Fluff13
    12-14-2022, 09:32 AM Go to last post

  24. SUMIF formula does not recognize automatically inserted date

    Started by Thyago_Martins‎, 12-11-2022 05:39 PM
    date auto insert, sumif and formula 3 Attachment(s)
    • 7
    • 302
    6StringJazzer
    12-14-2022, 09:29 AM Go to last post

  25. To count the number of instances for ranged dates

    Started by viewotst‎, 12-14-2022 08:50 AM
    1 Attachment(s)
    • 1
    • 135
    tanasedn
    12-14-2022, 09:27 AM Go to last post

  26. [SOLVED] Find and show the last value from a row

    Started by Vihral‎, 12-14-2022 05:18 AM
    5 Attachment(s)
    • 8
    • 270
    HansDouwe
    12-14-2022, 06:47 AM Go to last post

  27. [SOLVED] Finding Average for Last 5/10 games closing line

    Started by showtimesaints‎, 12-11-2022 08:56 AM
    4 Attachment(s)
    • 10
    • 448
    showtimesaints
    12-14-2022, 06:31 AM Go to last post

  28. Coloring cells based on a formula

    Started by guna_shekar‎, 12-13-2022 10:59 PM
    8 Attachment(s)
    • 18
    • 362
    HansDouwe
    12-14-2022, 06:13 AM Go to last post

  29. [SOLVED] Calculating vacation entitlement based on service date and grade

    Started by Raehan‎, 12-13-2022 10:37 PM
    2 Attachment(s)
    • 3
    • 218
    HansDouwe
    12-14-2022, 12:38 AM Go to last post

  30. Check to see if two inputs share the same data

    Started by ExcelDropper‎, 12-13-2022 07:03 AM
    4 Attachment(s)
    • 2
    • 325
    menem
    12-13-2022, 09:29 PM Go to last post

  31. Needing to Add totals for CountIF values

    Started by streetboi1208‎, 12-13-2022 04:28 PM
    3 Attachment(s)
    • 2
    • 429
    sandy666
    12-13-2022, 05:44 PM Go to last post

  32. [SOLVED] Calculate How Many People Are Working At The Same Time using the COUNTIFS Function

    Started by DPCummerbund‎, 12-13-2022 02:54 PM
    2 Attachment(s)
    • 7
    • 225
    DPCummerbund
    12-13-2022, 05:42 PM Go to last post

  33. Absolute external workbook reference

    Started by RJ77‎, 12-13-2022 02:04 PM
    absolute path, linked workbook
    • 2
    • 204
    RJ77
    12-13-2022, 04:10 PM Go to last post

  34. Angry [SOLVED] Vlookup Help

    Started by jwilson7‎, 12-13-2022 02:31 PM
    2 Attachment(s)
    • 6
    • 203
    TMS
    12-13-2022, 03:51 PM Go to last post

  35. Top ten Percentile

    Started by AMJADMemon‎, 12-08-2022 11:25 AM
    14 Attachment(s)
    • 31
    • 490
    AMJADMemon
    12-13-2022, 03:34 PM Go to last post

  36. [SOLVED] Convert From tables to another table problem?

    Started by choletseng‎, 12-13-2022 02:11 AM
    5 Attachment(s)
    • 6
    • 309
    52779
    12-13-2022, 03:20 PM Go to last post

  37. [SOLVED] Using vlookup to find table from a table

    Started by sansan88‎, 12-12-2022 08:59 AM
    1 Attachment(s)
    • 5
    • 174
    sansan88
    12-13-2022, 01:32 PM Go to last post

  38. To count dates in ranges that meet a condition

    Started by viewotst‎, 12-13-2022 11:30 AM
    2 Attachment(s)
    • 3
    • 179
    viewotst
    12-13-2022, 01:06 PM Go to last post

  39. Help with a formula by time frame

    Started by brandon74‎, 12-13-2022 12:19 PM
    formula, help a dummy needed, help a noob 2 Attachment(s)
    • 11
    • 389
    HansDouwe
    12-13-2022, 12:54 PM Go to last post

  40. Angry [SOLVED] Need help with Sum Filter Formula

    Started by jwilson7‎, 12-13-2022 12:11 PM
    1 Attachment(s)
    • 4
    • 170
    jwilson7
    12-13-2022, 12:54 PM Go to last post

  41. Need help capitalizing formula results

    Started by aleiva16‎, 12-13-2022 11:41 AM
    • 2
    • 158
    aleiva16
    12-13-2022, 12:30 PM Go to last post

  42. Question Automate copy pasting values

    Started by markcoutinho‎, 12-12-2022 03:59 PM
    • 4
    • 195
    markcoutinho
    12-13-2022, 11:50 AM Go to last post

  43. Growth/reduction in orderlist

    Started by CE89‎, 12-13-2022 09:53 AM
    • 2
    • 200
    TMS
    12-13-2022, 10:46 AM Go to last post

  44. [SOLVED] Sumif formula

    Started by Jacks18928jl‎, 12-09-2022 04:42 AM
    1 Attachment(s)
    • 8
    • 261
    Jacks18928jl
    12-13-2022, 08:35 AM Go to last post

  45. Remove " at beginning and end of formula result

    Started by troywhite1111‎, 12-13-2022 07:29 AM
    char10, clean function, concat
    • 2
    • 211
    AliGW
    12-13-2022, 08:09 AM Go to last post

  46. I Need an IF NESTED FUNTION?

    Started by Nery‎, 12-12-2022 02:30 PM
    2 Attachment(s)
    • 7
    • 256
    Glenn Kennedy
    12-13-2022, 05:39 AM Go to last post

  47. [SOLVED] CountIFS based on a date

    Started by peterderrington‎, 12-12-2022 11:27 AM
    4 Attachment(s)
    • 15
    • 386
    etaf
    12-13-2022, 05:31 AM Go to last post

  48. [SOLVED] Calculate Percentage Based on Few Criteria

    Started by cyliyu‎, 12-13-2022 02:19 AM
    1 Attachment(s)
    • 2
    • 167
    cyliyu
    12-13-2022, 05:08 AM Go to last post

  49. formula to help with payment allocation over months based on 30 day months (including feb)

    Started by a2424‎, 07-15-2020 07:53 AM
    4 Attachment(s)
    • 9
    • 953
    alansidman
    12-13-2022, 02:21 AM Go to last post

  50. Looking for a more dynamic SUMPRODUCT(ISNUM(SEARCH option for a lot of data.

    Started by Lacey87‎, 12-12-2022 07:46 PM
    1 Attachment(s)
    • 1
    • 248
    FDibbins
    12-13-2022, 01:01 AM Go to last post
+ Post New Thread
Page 201 of 5614 FirstFirst ... 201 ...

Forum Information and Options

Users Browsing this Forum

There are currently 55 users browsing this forum. (2 members & 53 guests)

  1. ExceLogan,
  2. jwpeters74

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