+ Post New Thread
Page 1 of 5619 1 ...
Threads 1 to 50 of 280918

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

  1. Pulling data from nth row on 1 sheet to another sheet

    Started by CDMJR2‎, 05-08-2024 01:57 PM
    2 Attachment(s)
    • 3
    • 62
    TMS
    Today, 09:57 AM Go to last post

  2. Dynamic filtering using a macro

    Started by abz2786‎, Today 07:31 AM
    2 Attachment(s)
    • 2
    • 47
    abz2786
    Today, 09:53 AM Go to last post

  3. countif between two times that range over 24hour period

    Started by crompton1980‎, Yesterday 10:48 AM
    2 Attachment(s)
    • 2
    • 53
    crompton1980
    Today, 09:51 AM Go to last post

  4. [SOLVED] Really really need help with this: Contra entries with customer names :(

    Started by esaelias‎, 05-01-2024 08:29 AM
    8 Attachment(s)
    • 32
    • 219
    esaelias
    Today, 09:27 AM Go to last post

  5. Fishing Club Sheet Formula help Index

    Started by chadd‎, Yesterday 08:25 PM
    1 Attachment(s)
    • 1
    • 36
    JohnTopley
    Today, 09:13 AM Go to last post

  6. Question Modelling a fee with a floor and cap, with a deferred element

    Started by Restructure Me‎, Today 09:11 AM
    2 Attachment(s)
    • 0
    • 5
    Restructure Me
    Today, 09:11 AM Go to last post

  7. [SOLVED] Formula to get actual numbers upon meeting conditions

    Started by majana54‎, 05-03-2024 01:53 AM
    2 Attachment(s)
    • 3
    • 126
    JeteMc
    Today, 09:06 AM Go to last post

  8. condition for a digit in the formulae (file attached) - SUMIFS

    Started by ebrauns79‎, Yesterday 05:44 AM
    1 Attachment(s)
    • 5
    • 66
    ebrauns79
    Today, 09:02 AM Go to last post

  9. Dynamic column

    Started by aeimisgr‎, Today 06:19 AM
    1 Attachment(s)
    • 2
    • 43
    aeimisgr
    Today, 08:42 AM Go to last post

  10. Question Creating a rule to Shade cells with different contents

    Started by emerson16‎, Yesterday 02:38 PM
    1 Attachment(s)
    • 2
    • 52
    emerson16
    Today, 08:17 AM Go to last post

  11. [SOLVED] Lookup function

    Started by djennasm‎, Today 05:25 AM
    4 Attachment(s)
    • 12
    • 81
    djennasm
    Today, 08:16 AM Go to last post

  12. Count If there are 2 probabilities

    Started by Por2gal‎, 05-08-2024 07:32 PM
    1 Attachment(s)
    • 4
    • 61
    Sam Capricci
    Today, 07:48 AM Go to last post

  13. Number of Days to Freeze once a Date of Completion is Entered

    Started by jaredino‎, Today 04:57 AM
    • 1
    • 36
    popipipo
    Today, 07:44 AM Go to last post

  14. Work Time: difference between two dates with conditions

    Started by lordpvl‎, Today 05:27 AM
    3 Attachment(s)
    • 3
    • 42
    JohnTopley
    Today, 07:21 AM Go to last post

  15. Post pull out specific date based on criteria from multiple columns having dates

    Started by srglt332‎, Today 06:44 AM
    pullout specific date 2 Attachment(s)
    • 2
    • 36
    kvsrinivasamurthy
    Today, 07:21 AM Go to last post

  16. Formula Help : 2023 dates to show 01/01/2024 and 2024 dates to show origional column date

    Started by Smiffy3594‎, Today 06:47 AM
    1 Attachment(s)
    • 3
    • 35
    romperstomper
    Today, 07:20 AM Go to last post

  17. Question what is wrong with my formula? for sumifs or am i using the wrong feature

    Started by cut3y‎, Yesterday 09:10 PM
    sumifs and and formula, sumifs and formula
    • 7
    • 64
    Gregb11
    Today, 07:14 AM Go to last post

  18. [SOLVED] Returning results with a minimum number of enteries

    Started by maxwellsdemon13‎, Yesterday 04:41 PM
    2 Attachment(s)
    • 9
    • 99
    Gregb11
    Today, 07:08 AM Go to last post

  19. Nested If's (Ands and then's

    Started by k.tanton‎, Today 04:31 AM
    2 Attachment(s)
    • 8
    • 72
    romperstomper
    Today, 06:59 AM Go to last post

  20. Generate spill array to determine the performance of a department

    Started by MubiJazz‎, Yesterday 02:16 PM
    3 Attachment(s)
    • 3
    • 57
    Fluff13
    Today, 06:48 AM Go to last post

  21. Linest Function incorrect result

    Started by Jarqu‎, Yesterday 08:19 AM
    bingham, linest, pv ty, rheology 1 Attachment(s)
    • 3
    • 55
    Jarqu
    Today, 05:31 AM Go to last post

  22. Issue with French formula on sum product

    Started by shiva_reshs‎, Today 03:44 AM
    • 3
    • 49
    romperstomper
    Today, 05:09 AM Go to last post

  23. [SOLVED] If (AND nested help

    Started by k.tanton‎, 05-08-2024 02:02 AM
    2 Attachment(s)
    • 9
    • 97
    k.tanton
    Today, 04:19 AM Go to last post

  24. [SOLVED] Combine multiple xlookups with multiple if statements

    Started by ajwilltravel‎, 05-06-2024 02:23 AM
    3 Attachment(s)
    • 17
    • 160
    AliGW
    Today, 02:44 AM Go to last post

  25. Question Return Value from Col's and Rows - US States WORKDAYS for a given period

    Started by pfusella‎, Yesterday 02:53 PM
    2 Attachment(s)
    • 1
    • 47
    JohnTopley
    Today, 02:11 AM Go to last post

  26. Find a MAX in one ROW & add corresponding numbers in another ROW

    Started by asifmian55‎, Yesterday 12:19 PM
    1 Attachment(s)
    • 2
    • 57
    AliGW
    Today, 12:28 AM Go to last post

  27. [SOLVED] In a column the TEXT values is not generating the result using IF but get result for Date

    Started by jaffirahamed1‎, 05-07-2024 12:49 AM
    2 Attachment(s)
    • 5
    • 94
    jaffirahamed1
    Yesterday, 11:07 PM Go to last post

  28. Moved: Fill column with specified range of numbers in Google Sheets.

    Started by HelghastG75‎, Yesterday 09:54 PM
    •  
    •  

  29. [SOLVED] Records processed on time

    Started by mq1973‎, Yesterday 12:24 PM
    6 Attachment(s)
    • 8
    • 101
    mq1973
    Yesterday, 09:48 PM Go to last post

  30. Trying to calculate YTD total comparison using SUMIFS

    Started by rpederson‎, 05-06-2024 12:57 PM
    sumifs 1 Attachment(s)
    • 5
    • 81
    JeteMc
    Yesterday, 09:11 PM Go to last post

  31. Formula to return Friday of payroll week

    Started by alohadboy‎, Yesterday 03:56 PM
    • 1
    • 45
    ExceLogan
    Yesterday, 08:25 PM Go to last post

  32. [SOLVED] Nested Countif

    Started by Katrinafarrugia‎, Yesterday 07:22 PM
    • 6
    • 64
    TMS
    Yesterday, 08:02 PM Go to last post

  33. Question Count unique rows in a dataset where a certain criteria is met

    Started by pfusella‎, 05-08-2024 07:52 PM
    3 Attachment(s)
    • 13
    • 149
    pfusella
    Yesterday, 04:57 PM Go to last post

  34. Subtract x amount from top/left and bottom/right sides of array

    Started by Chalumeau‎, 05-08-2024 04:38 PM
    2 Attachment(s)
    • 3
    • 80
    Kaper
    Yesterday, 04:04 PM Go to last post

  35. [SOLVED] Excel pickup wrong data

    Started by yankiessg‎, 05-08-2024 10:58 AM
    2 Attachment(s)
    • 5
    • 76
    Kaper
    Yesterday, 03:52 PM Go to last post

  36. Excel Data Validation custom formula conditions

    Started by oaklander‎, Yesterday 10:03 AM
    3 Attachment(s)
    • 3
    • 55
    etaf
    Yesterday, 03:43 PM Go to last post

  37. When copying a vlookup formula from one cell to it is displaying the incorrect row?

    Started by mcjohnson3211‎, Yesterday 03:03 PM
    1 Attachment(s)
    • 1
    • 44
    TMS
    Yesterday, 03:37 PM Go to last post

  38. reject entry on co dition

    Started by M S Narayanan‎, Yesterday 02:08 PM
    • 1
    • 37
    JohnTopley
    Yesterday, 02:13 PM Go to last post

  39. Date-wise Bank Balance Statement required

    Started by btparkhe1920‎, 05-04-2024 08:57 AM
    3 Attachment(s)
    • 5
    • 116
    JeteMc
    Yesterday, 01:10 PM Go to last post

  40. Copying a Conditional Formatting to each row individually

    Started by BBFDSue‎, Yesterday 11:20 AM
    conditional formatting, copying, format painting, many lines 1 Attachment(s)
    • 1
    • 44
    BBFDSue
    Yesterday, 12:59 PM Go to last post

  41. AUM fee billing calculator

    Started by dmdnbrooks‎, Yesterday 12:02 PM
    1 Attachment(s)
    • 1
    • 34
    JohnTopley
    Yesterday, 12:59 PM Go to last post

  42. Sum of 2 columns don't match unless I replace a cell with an identical cell!!

    Started by johncassell‎, Yesterday 12:09 PM
    1 Attachment(s)
    • 2
    • 44
    johncassell
    Yesterday, 12:50 PM Go to last post

  43. Count function to count number of clients who received service in a given month

    Started by rpederson‎, Yesterday 10:04 AM
    countifs, excel, office 365 2 Attachment(s)
    • 11
    • 89
    etaf
    Yesterday, 12:40 PM Go to last post

  44. [SOLVED] Only want to show employee names and times with a time against them on that day

    Started by Peter.Smith‎, Yesterday 05:54 AM
    2 Attachment(s)
    • 5
    • 94
    TMS
    Yesterday, 12:24 PM Go to last post

  45. Formula

    Started by denisazuz‎, Yesterday 10:55 AM
    2 Attachment(s)
    • 7
    • 60
    JohnTopley
    Yesterday, 12:23 PM Go to last post

  46. New Excel 365 functions - brainstorming compeling reasons for usage

    Started by kofeincek‎, Yesterday 10:28 AM
    • 0
    • 54
    kofeincek
    Yesterday, 10:28 AM Go to last post

  47. Count responses to a questionnaire only if the participant answered yes (instead of no).

    Started by en11nt‎, Yesterday 09:48 AM
    • 1
    • 20
    etaf
    Yesterday, 09:51 AM Go to last post

  48. Question validating 2 lists, if row info matches, add specific text in new column on same row

    Started by bushwacked‎, 05-06-2024 02:35 PM
    3 Attachment(s)
    • 7
    • 123
    TMS
    Yesterday, 09:51 AM Go to last post

  49. I have recently gone back to work and I am rusty!

    Started by DH Fisher‎, 05-08-2024 05:30 PM
    1 Attachment(s)
    • 5
    • 68
    wk9128
    Yesterday, 09:30 AM Go to last post

  50. Only including cells containing certain words / numbers in formula?

    Started by Concrete_kid21‎, Yesterday 08:55 AM
    • 2
    • 43
    TMS
    Yesterday, 09:05 AM Go to last post
+ Post New Thread
Page 1 of 5619 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 74 users browsing this forum. (7 members & 67 guests)

  1. abz2786,
  2. chullan88,
  3. crompton1980,
  4. maxwellsdemon13,
  5. Rick Rothstein

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