+ Post New Thread
Page 90 of 5615 FirstFirst ... 90 ...
Threads 4451 to 4500 of 280706

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

  1. [SOLVED] Issue with the formula for numerical extraction in the cell

    Started by chrisneu‎, 09-06-2023 02:40 PM
    • 7
    • 232
    Fluff13
    09-07-2023, 08:21 AM Go to last post

  2. Index/ Match Help

    Started by ats1312‎, 09-07-2023 06:42 AM
    3 Attachment(s)
    • 8
    • 180
    ats1312
    09-07-2023, 07:45 AM Go to last post

  3. [SOLVED] Make Supplies Sheet Rule Function Like Inventory Sheet Rule

    Started by billy60‎, 09-07-2023 06:50 AM
    • 3
    • 172
    billy60
    09-07-2023, 07:40 AM Go to last post

  4. [SOLVED] How to calculate median between two dates/ Medianifs

    Started by Bigmaq98‎, 09-07-2023 06:18 AM
    conditional median, median, medianifs 1 Attachment(s)
    • 7
    • 235
    Phuocam
    09-07-2023, 07:35 AM Go to last post

  5. Unhappy amount of days between a start date and end date within a particular quarter

    Started by AlexEllice‎, 09-07-2023 06:12 AM
    • 1
    • 165
    kvsrinivasamurthy
    09-07-2023, 07:18 AM Go to last post

  6. Smile Select Parent Column and that filters out the ParentEntity Column

    Started by asmita.nda‎, 09-06-2023 09:07 PM
    data validation, formula, macros 4 Attachment(s)
    • 7
    • 236
    Gregb11
    09-07-2023, 07:03 AM Go to last post

  7. [SOLVED] Is it possible to use TREND formula BYROW on a #Spill Range?

    Started by chris01395‎, 09-07-2023 04:27 AM
    2 Attachment(s)
    • 3
    • 215
    HansDouwe
    09-07-2023, 06:10 AM Go to last post

  8. [SOLVED] Allocate Amount Based On Multiple Criteria

    Started by Barieq‎, 09-07-2023 03:47 AM
    2 Attachment(s)
    • 3
    • 141
    HansDouwe
    09-07-2023, 04:32 AM Go to last post

  9. Subtracting values from sheet 2 to sheet 1

    Started by rameshantony2000‎, 09-07-2023 04:04 AM
    • 2
    • 136
    HansDouwe
    09-07-2023, 04:29 AM Go to last post

  10. Formula for the Maximum of Numbers and Less than numbers.

    Started by FortMyersKid‎, 09-06-2023 02:37 PM
    3 Attachment(s)
    • 7
    • 275
    Glenn Kennedy
    09-07-2023, 03:17 AM Go to last post

  11. Extract Names from individual cell

    Started by Shawn Oh‎, 09-05-2023 09:16 PM
    4 Attachment(s)
    • 13
    • 599
    HansDouwe
    09-07-2023, 12:48 AM Go to last post

  12. Smile IF-THEN function appropriate? & how to work around income words/ranges?

    Started by krismor‎, 09-05-2023 11:42 PM
    1 Attachment(s)
    • 3
    • 273
    Gregb11
    09-06-2023, 09:46 PM Go to last post

  13. [SOLVED] Cumulative FICA Calculation using a threshold of current FICA CAP.

    Started by natemoney2‎, 09-06-2023 05:06 PM
    cumulative, fica, tax calculation, threshold 2 Attachment(s)
    • 3
    • 196
    HansDouwe
    09-06-2023, 08:53 PM Go to last post

  14. How to have =Today() Function keep today's date adn nt change tomorrow or in future

    Started by benitopjuarez‎, 10-11-2013 02:27 PM
    date, today, today formula, today function 3 Attachment(s)
    • 10
    • 9,264
    zbor
    09-06-2023, 08:19 PM Go to last post

  15. [SOLVED] Same Name With Different Values and Sum of them

    Started by avinashraste‎, 09-05-2023 08:33 AM
    4 Attachment(s)
    • 27
    • 1,209
    alansidman
    09-06-2023, 03:41 PM Go to last post

  16. Calculating % change from the previous year

    Started by CEdward‎, 09-03-2023 06:37 PM
    4 Attachment(s)
    • 5
    • 278
    kvsrinivasamurthy
    09-06-2023, 03:32 PM Go to last post

  17. Moved: Generate formatted rows for a table based on number values entered into cells

    Started by rncd147‎, 09-06-2023 12:16 PM
    •  
    •  

  18. [SOLVED] Colour cells depending on the date

    Started by alf_‎, 09-06-2023 11:06 AM
    • 3
    • 148
    AliGW
    09-06-2023, 11:49 AM Go to last post

  19. [SOLVED] IF Between Date Ranges

    Started by Stenner‎, 09-06-2023 09:11 AM
    2 Attachment(s)
    • 4
    • 209
    AliGW
    09-06-2023, 10:34 AM Go to last post

  20. Question Intelligently split a value among varying parties

    Started by djveed‎, 08-30-2023 06:35 PM
    1 Attachment(s)
    • 5
    • 248
    AliGW
    09-06-2023, 10:34 AM Go to last post

  21. [SOLVED] SUM without certain values

    Started by PintaDe‎, 09-04-2023 10:36 AM
    2 Attachment(s)
    • 10
    • 343
    windknife
    09-06-2023, 09:18 AM Go to last post

  22. [SOLVED] Count age range formula

    Started by Ibrahim Ambale‎, 09-04-2023 09:17 AM
    3 Attachment(s)
    • 13
    • 423
    AliGW
    09-06-2023, 09:07 AM Go to last post

  23. Weighted average using SUMPRODUCT and multiple criteria need to be met

    Started by miketomei‎, 09-05-2023 04:54 PM
    2 Attachment(s)
    • 3
    • 249
    miketomei
    09-06-2023, 08:54 AM Go to last post

  24. Nested if formula with an error

    Started by Chon1978‎, 09-05-2023 09:29 PM
    2 Attachment(s)
    • 5
    • 180
    6StringJazzer
    09-06-2023, 07:51 AM Go to last post

  25. Smile [SOLVED] Dealing with Ties in Card Game Scoring

    Started by Albert310‎, 09-06-2023 04:22 AM
    3 Attachment(s)
    • 9
    • 187
    AliGW
    09-06-2023, 05:30 AM Go to last post

  26. Excel formula for sending email

    Started by sunboy‎, 09-05-2023 11:17 PM
    1 Attachment(s)
    • 4
    • 241
    sunboy
    09-06-2023, 04:50 AM Go to last post

  27. Formula Need: Count cells with numeric value where column header matches specific text.

    Started by VivoSomnio‎, 09-06-2023 01:01 AM
    4 Attachment(s)
    • 5
    • 170
    HansDouwe
    09-06-2023, 04:34 AM Go to last post

  28. Multiple if statement

    Started by mfplayer20‎, 09-05-2023 08:02 PM
    1 Attachment(s)
    • 3
    • 325
    AliGW
    09-06-2023, 03:51 AM Go to last post

  29. Power Query: If statement

    Started by sharonca‎, 09-05-2023 12:57 PM
    • 1
    • 131
    alansidman
    09-05-2023, 10:52 PM Go to last post

  30. [SOLVED] Dynamic Formula to insert 2 blank rows between dataset

    Started by chullan88‎, 09-05-2023 01:19 AM
    3 Attachment(s)
    • 9
    • 276
    windknife
    09-05-2023, 09:35 PM Go to last post

  31. [SOLVED] Need to create a matrix that sums the number of paired observations.

    Started by Venturer‎, 09-04-2023 06:15 PM
    excel & if, index & count, index & if 4 Attachment(s)
    • 6
    • 285
    HansDouwe
    09-05-2023, 05:37 PM Go to last post

  32. Need New Row for Every Phone #

    Started by darenfro‎, 08-22-2023 05:19 PM
    1 Attachment(s)
    • 6
    • 289
    TMS
    09-05-2023, 04:09 PM Go to last post

  33. [SOLVED] If formula for specific text in string

    Started by mrteater‎, 09-05-2023 03:26 PM
    1 Attachment(s)
    • 1
    • 162
    Bernie Deitrick
    09-05-2023, 03:50 PM Go to last post

  34. [SOLVED] Modify Formula

    Started by MartinLiss‎, 09-05-2023 11:00 AM
    formula assistance 2 Attachment(s)
    • 8
    • 251
    Jacc
    09-05-2023, 03:14 PM Go to last post

  35. [SOLVED] Return just one criteria, ignore others

    Started by Shruder‎, 09-05-2023 02:31 PM
    condition and 1 Attachment(s)
    • 3
    • 193
    Fluff13
    09-05-2023, 02:58 PM Go to last post

  36. [SOLVED] Find top 50 consecutive out of 1000 records

    Started by M0RDANT‎, 09-05-2023 01:29 PM
    1 Attachment(s)
    • 3
    • 160
    Fluff13
    09-05-2023, 02:43 PM Go to last post

  37. [SOLVED] Find most occuring value and sort the top 3

    Started by amoi‎, 08-31-2023 02:28 AM
    9 Attachment(s)
    • 10
    • 464
    Glenn Kennedy
    09-05-2023, 01:26 PM Go to last post

  38. Post smoothly create an exponential graph in which the relation between the accuracy and evasio

    Started by CVDom‎, 08-24-2023 01:07 PM
    complex, exponential, formula, log, math 2 Attachment(s)
    • 19
    • 601
    MrShorty
    09-05-2023, 01:15 PM Go to last post

  39. [SOLVED] Help with formula

    Started by Canalrunna‎, 09-05-2023 11:28 AM
    help with formulas 2 Attachment(s)
    • 4
    • 194
    AliGW
    09-05-2023, 12:43 PM Go to last post

  40. Excel Formula For Start Date and End Date

    Started by geh17‎, 09-05-2023 11:27 AM
    • 1
    • 168
    AliGW
    09-05-2023, 12:00 PM Go to last post

  41. Moved: List Unique Values by Formula

    Started by paulocsm‎, 09-05-2023 10:48 AM
    •  
    •  

  42. [SOLVED] Can I update a sheet with a function or combinations of functions?

    Started by kvemperor‎, 09-03-2023 03:10 AM
    2 Attachment(s)
    • 7
    • 282
    JeteMc
    09-05-2023, 10:35 AM Go to last post

  43. Match Data if Partial Match and Greater Than

    Started by franztupaz‎, 09-05-2023 06:01 AM
    1 Attachment(s)
    • 3
    • 165
    AliGW
    09-05-2023, 09:34 AM Go to last post

  44. Moved: build a function/integration that will search a defined list to find the nearest 5 postcod

    Started by Qamer Shehzad‎, 09-05-2023 07:55 AM
    •  
    •  

  45. Finding Values That Add Up to a Specified Number

    Started by ibrmoh‎, 09-05-2023 06:27 AM
    1 Attachment(s)
    • 5
    • 201
    AliGW
    09-05-2023, 09:25 AM Go to last post

  46. [SOLVED] All possibility combinations 7 numbers from 18 numbers

    Started by Maxwell76‎, 09-04-2023 08:47 AM
    3 Attachment(s)
    • 9
    • 299
    JEC.
    09-05-2023, 09:04 AM Go to last post

  47. Need to Find escalation % on Series of Rent data for years in horizontal form

    Started by Ganapathyraman‎, 01-16-2013 01:51 AM
    1 Attachment(s)
    • 4
    • 642
    JohnTopley
    09-05-2023, 09:01 AM Go to last post

  48. Unhappy [SOLVED] Ceiling formula

    Started by Fraser Hamilton‎, 09-05-2023 06:19 AM
    ceiling, formula, rounding up
    • 2
    • 335
    Fraser Hamilton
    09-05-2023, 06:42 AM Go to last post

  49. [SOLVED] Bank loan calculations help

    Started by Jonathan624624‎, 09-05-2023 04:25 AM
    1 Attachment(s)
    • 4
    • 172
    Jonathan624624
    09-05-2023, 06:39 AM Go to last post

  50. Listing Staff and Roles according to Table

    Started by NVRensburg‎, 09-05-2023 03:38 AM
    4 Attachment(s)
    • 14
    • 195
    Glenn Kennedy
    09-05-2023, 05:55 AM Go to last post
+ Post New Thread
Page 90 of 5615 FirstFirst ... 90 ...

Forum Information and Options

Users Browsing this Forum

There are currently 27 users browsing this forum. (3 members & 24 guests)

  1. AliGW,
  2. Fluff13

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