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

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. [SOLVED] Returning results with a minimum number of enteries

    Started by maxwellsdemon13‎, Yesterday 04:41 PM
    2 Attachment(s)
    • 8
    • 87
    TMS
    Today, 03:12 AM Go to last post

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

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

  3. 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
    • 45
    JohnTopley
    Today, 02:11 AM Go to last post

  4. Count If there are 2 probabilities

    Started by Por2gal‎, 05-08-2024 07:32 PM
    1 Attachment(s)
    • 3
    • 52
    AliGW
    Today, 01:21 AM Go to last post

  5. 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
    • 6
    • 51
    AliGW
    Today, 12:55 AM Go to last post

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

    Started by asifmian55‎, Yesterday 12:19 PM
    1 Attachment(s)
    • 2
    • 53
    AliGW
    Today, 12:28 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)
    • 2
    • 118
    majana54
    Today, 12:21 AM Go to last post

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

    Started by MubiJazz‎, Yesterday 02:16 PM
    3 Attachment(s)
    • 2
    • 42
    MubiJazz
    Today, 12:02 AM Go to last post

  9. [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
    • 91
    jaffirahamed1
    Yesterday, 11:07 PM Go to last post

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

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

  11. [SOLVED] Records processed on time

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

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

    Started by esaelias‎, 05-01-2024 08:29 AM
    7 Attachment(s)
    • 30
    • 206
    esaelias
    Yesterday, 09:40 PM Go to last post

  13. Trying to calculate YTD total comparison using SUMIFS

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

  14. Formula to return Friday of payroll week

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

  15. Fishing Club Sheet Formula help Index

    Started by chadd‎, Yesterday 08:25 PM
    1 Attachment(s)
    • 0
    • 24
    chadd
    Yesterday, 08:25 PM Go to last post

  16. [SOLVED] Nested Countif

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

  17. 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
    • 147
    pfusella
    Yesterday, 04:57 PM Go to last post

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

    Started by emerson16‎, Yesterday 02:38 PM
    1 Attachment(s)
    • 1
    • 40
    6StringJazzer
    Yesterday, 04:30 PM Go to last post

  19. 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
    • 79
    Kaper
    Yesterday, 04:04 PM Go to last post

  20. [SOLVED] Excel pickup wrong data

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

  21. Excel Data Validation custom formula conditions

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

  22. 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
    • 43
    TMS
    Yesterday, 03:37 PM Go to last post

  23. reject entry on co dition

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

  24. Date-wise Bank Balance Statement required

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

  25. 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
    • 42
    BBFDSue
    Yesterday, 12:59 PM Go to last post

  26. AUM fee billing calculator

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

  27. 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
    • 42
    johncassell
    Yesterday, 12:50 PM Go to last post

  28. 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
    • 86
    etaf
    Yesterday, 12:40 PM Go to last post

  29. [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
    • 91
    TMS
    Yesterday, 12:24 PM Go to last post

  30. Formula

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

  31. Linest Function incorrect result

    Started by Jarqu‎, Yesterday 08:19 AM
    bingham, linest, pv ty, rheology
    • 2
    • 43
    MrShorty
    Yesterday, 12:00 PM Go to last post

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

    Started by crompton1980‎, Yesterday 10:48 AM
    1 Attachment(s)
    • 0
    • 35
    crompton1980
    Yesterday, 10:48 AM Go to last post

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

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

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

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

  35. 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
    • 122
    TMS
    Yesterday, 09:51 AM Go to last post

  36. 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
    • 66
    wk9128
    Yesterday, 09:30 AM Go to last post

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

    Started by Concrete_kid21‎, Yesterday 08:55 AM
    • 2
    • 39
    TMS
    Yesterday, 09:05 AM Go to last post

  38. Probabilities

    Started by lemans96‎, 05-08-2024 05:32 PM
    1 Attachment(s)
    • 2
    • 70
    6StringJazzer
    Yesterday, 09:05 AM Go to last post

  39. [SOLVED] Trying to exclude certain results from location columns in a transactional inventory

    Started by ndascher‎, 05-02-2024 07:05 PM
    excel, inventory tracking 2 Attachment(s)
    • 3
    • 140
    JeteMc
    Yesterday, 08:53 AM Go to last post

  40. Moving specific data from rows to columns

    Started by FrancisM2411‎, 04-29-2024 07:05 AM
    5 Attachment(s)
    • 11
    • 181
    JeteMc
    Yesterday, 08:52 AM Go to last post

  41. omit cell with text value from Conditional Formatting

    Started by DarrylBurge‎, Yesterday 04:19 AM
    1 Attachment(s)
    • 4
    • 45
    TMS
    Yesterday, 08:46 AM Go to last post

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

    Started by ebrauns79‎, Yesterday 05:44 AM
    1 Attachment(s)
    • 3
    • 55
    Pete_UK
    Yesterday, 08:26 AM Go to last post

  43. If (AND nested help

    Started by k.tanton‎, 05-08-2024 02:02 AM
    2 Attachment(s)
    • 8
    • 87
    k.tanton
    Yesterday, 08:09 AM Go to last post

  44. [SOLVED] Very Complicated SUM function

    Started by mlukot01‎, 05-08-2024 10:09 PM
    6 Attachment(s)
    • 13
    • 141
    kvsrinivasamurthy
    Yesterday, 05:48 AM Go to last post

  45. Help Tracking how many people in a Room.

    Started by rar032‎, Yesterday 04:28 AM
    • 1
    • 56
    Pete_UK
    Yesterday, 04:54 AM Go to last post

  46. [SOLVED] COUNTIF function for the occurrences of "-"

    Started by asad.ermo‎, Yesterday 03:25 AM
    1 Attachment(s)
    • 1
    • 38
    zbor
    Yesterday, 03:27 AM Go to last post

  47. Calculating summary sheet using INDIRECT function for multiple months

    Started by yiyi2‎, 05-08-2024 05:23 AM
    2 Attachment(s)
    • 4
    • 85
    yiyi2
    Yesterday, 02:03 AM Go to last post

  48. Exclamation How to work out time when passed 24 hours

    Started by Blayde‎, 05-08-2024 12:31 PM
    1 Attachment(s)
    • 2
    • 36
    Blayde
    Yesterday, 12:22 AM Go to last post

  49. Excel - How to Parse out a portion of a string to a new value

    Started by cubd8‎, 05-08-2024 06:27 PM
    • 3
    • 84
    Rick Rothstein
    05-08-2024, 09:57 PM Go to last post

  50. Add text to date pulled from another sheet

    Started by cbadouin‎, 05-08-2024 02:29 PM
    • 3
    • 65
    cbadouin
    05-08-2024, 09:42 PM Go to last post
+ Post New Thread
Page 1 of 5619 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 92 users browsing this forum. (1 members & 91 guests)

  1. btparkhe1920

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