+ Post New Thread
Page 591 of 5614 FirstFirst ... 591 ...
Threads 29501 to 29550 of 280690

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. [SOLVED] Data Matching Formula

    Started by Doofus1‎, 12-05-2020 10:34 PM
    1 Attachment(s)
    • 4
    • 211
    Doofus1
    12-06-2020, 02:06 AM Go to last post

  2. [SOLVED] use of filter/ grouping in the formula loop used to find Quartile.INC

    Started by Hema Gopal‎, 12-05-2020 05:20 AM
    2 Attachment(s)
    • 5
    • 246
    Glenn Kennedy
    12-06-2020, 02:04 AM Go to last post

  3. Exclamation Using Index Match function to create multi dependent drop down lists - Returning Error

    Started by Kermyt007‎, 12-03-2020 06:17 AM
    dependent dropdowns, index & match 2 Attachment(s)
    • 6
    • 475
    Kermyt007
    12-05-2020, 10:46 PM Go to last post

  4. [SOLVED] Formula to extract a specific number from data in a cell

    Started by Doofus1‎, 12-05-2020 06:57 PM
    1 Attachment(s)
    • 3
    • 287
    TMS
    12-05-2020, 07:26 PM Go to last post

  5. Combination Lookup: Column 1 (Employee Name) + Column 2 (Code) + Row (Month) and sum

    Started by wherdzik‎, 12-05-2020 10:17 AM
    2 Attachment(s)
    • 3
    • 287
    wherdzik
    12-05-2020, 05:23 PM Go to last post

  6. [SOLVED] Month Over Month Headcount with SUMPRODUCT

    Started by kdalyveris‎, 09-15-2015 12:01 PM
    headcount, sumproduct 1 Attachment(s)
    • 8
    • 2,733
    AliGW
    12-05-2020, 04:55 PM Go to last post

  7. [SOLVED] Need to convert schedule from workday to "now" or hours

    Started by Dawn Clark‎, 11-10-2020 12:22 PM
    solved 1 Attachment(s)
    • 6
    • 437
    Dawn Clark
    12-05-2020, 03:12 PM Go to last post

  8. Compare tho columns and return unpaired cell contents

    Started by Rodokanator‎, 11-30-2020 06:49 PM
    2 Attachment(s)
    • 3
    • 401
    JeteMc
    12-05-2020, 12:43 PM Go to last post

  9. [SOLVED] Need value of a lookup item number of times in rows based on its value in other cell

    Started by haroonkhurshid‎, 12-05-2020 10:29 AM
    multiple values 2 Attachment(s)
    • 3
    • 249
    Glenn Kennedy
    12-05-2020, 11:33 AM Go to last post

  10. Drop Down List Selection Based On Column Title Selection

    Started by StephenCoff‎, 12-05-2020 09:07 AM
    4 Attachment(s)
    • 2
    • 325
    torachan
    12-05-2020, 10:48 AM Go to last post

  11. [SOLVED] Unique List From Row Name Based On Criteria from Column Data Header and Column Contents

    Started by jweatherford‎, 12-05-2020 12:00 AM
    column look up, row name return, unique list 1 Attachment(s)
    • 5
    • 399
    alansidman
    12-05-2020, 10:19 AM Go to last post

  12. Lightbulb [SOLVED] Match value of another column & get records from another column

    Started by sanjuss2‎, 12-05-2020 08:55 AM
    2 Attachment(s)
    • 2
    • 248
    sanjuss2
    12-05-2020, 10:18 AM Go to last post

  13. quickly apply formula to subtract values in one column from another.

    Started by memunoz‎, 12-05-2020 08:02 AM
    • 2
    • 236
    Pete_UK
    12-05-2020, 08:46 AM Go to last post

  14. [SOLVED] Formula to breakdown time into half hour segments

    Started by dharvey1978‎, 12-05-2020 04:40 AM
    5 Attachment(s)
    • 8
    • 425
    etaf
    12-05-2020, 08:45 AM Go to last post

  15. [SOLVED] Array formula counting empty cells as zero

    Started by Marvo‎, 12-04-2020 01:00 PM
    5 Attachment(s)
    • 17
    • 2,992
    AliGW
    12-05-2020, 08:15 AM Go to last post

  16. Moved: Excel VBA UserForm - Control list does not have Date Picker SP6

    Started by Pawnar‎, 12-05-2020 06:18 AM
    •  
    •  

  17. Smile [SOLVED] How to return results of a top 5 lowest price, top 5 highest price and price difference?

    Started by Luu4466‎, 12-04-2020 11:53 AM
    column, index, match, vlook up 3 Attachment(s)
    • 2
    • 513
    Luu4466
    12-05-2020, 05:29 AM Go to last post

  18. Consoldate Mulitple Rows into a Single Row

    Started by madams1260‎, 12-03-2020 05:38 PM
    4 Attachment(s)
    • 5
    • 419
    kvsrinivasamurthy
    12-05-2020, 12:31 AM Go to last post

  19. [SOLVED] Concatenate - Roundup - Sum

    Started by Mike215‎, 12-04-2020 11:00 PM
    concatenate, equation, roundup, sum 1 Attachment(s)
    • 2
    • 497
    Mike215
    12-04-2020, 11:33 PM Go to last post

  20. [SOLVED] Count values in dynamic column greater than another

    Started by chris01395‎, 12-04-2020 02:23 PM
    • 3
    • 379
    chris01395
    12-04-2020, 07:00 PM Go to last post

  21. combined data validation

    Started by cheesemeister‎, 12-04-2020 01:57 PM
    • 2
    • 296
    cheesemeister
    12-04-2020, 05:07 PM Go to last post

  22. VLOOKUP functions to generate report

    Started by vishiabj‎, 09-19-2019 09:17 AM
    formulas, functions, vlookup 6 Attachment(s)
    • 10
    • 1,033
    Glenn Kennedy
    12-04-2020, 04:47 PM Go to last post

  23. Help a newbie. Very easy if and then formula.

    Started by Bsingh897‎, 12-04-2020 02:46 PM
    • 3
    • 303
    Bsingh897
    12-04-2020, 03:19 PM Go to last post

  24. Multiple nested sum and blanks or zero

    Started by Aquarock‎, 12-03-2020 03:29 PM
    2 Attachment(s)
    • 6
    • 346
    Aquarock
    12-04-2020, 02:30 PM Go to last post

  25. How to identify a column

    Started by j_Southern‎, 12-03-2020 11:57 AM
    1 Attachment(s)
    • 2
    • 369
    j_Southern
    12-04-2020, 01:14 PM Go to last post

  26. [SOLVED] conditional formatting different formulas in 1 row

    Started by JulieVDAA‎, 12-03-2020 05:18 PM
    2 Attachment(s)
    • 4
    • 278
    JulieVDAA
    12-04-2020, 12:46 PM Go to last post

  27. Convert a cell from text to number then carry out a formula

    Started by Saturn5‎, 12-04-2020 12:31 PM
    1 Attachment(s)
    • 1
    • 168
    Glenn Kennedy
    12-04-2020, 12:32 PM Go to last post

  28. Extracting a portion from a text

    Started by piku9290dgp‎, 12-04-2020 11:45 AM
    extract #value! #num!, extract between strings 2 Attachment(s)
    • 1
    • 257
    Bo_Ry
    12-04-2020, 12:11 PM Go to last post

  29. SUM with delimiters parameters

    Started by guilherme15990‎, 12-04-2020 11:59 AM
    1 Attachment(s)
    • 1
    • 182
    Pepe Le Mokko
    12-04-2020, 12:04 PM Go to last post

  30. [SOLVED] How to upload GDP of 16 countries?

    Started by Luu4466‎, 11-30-2020 10:32 AM
    import, revenue 3 Attachment(s)
    • 6
    • 519
    Luu4466
    12-04-2020, 11:55 AM Go to last post

  31. [SOLVED] If A1 does not equal today, go to next D1 etc...

    Started by RSkeen‎, 11-25-2020 05:46 PM
    1 Attachment(s)
    • 14
    • 544
    Aardigspook
    12-04-2020, 10:41 AM Go to last post

  32. Dynamic Sums

    Started by xTyD23x‎, 12-03-2020 06:28 PM
    • 5
    • 349
    BMV
    12-04-2020, 10:40 AM Go to last post

  33. Sum IF Excel Function

    Started by filip.irena‎, 12-03-2020 11:38 AM
    2 Attachment(s)
    • 5
    • 354
    Glenn Kennedy
    12-04-2020, 09:34 AM Go to last post

  34. XLOOKUP with a dynamic return array

    Started by phrankndonna‎, 12-02-2020 06:28 PM
    • 3
    • 2,444
    phrankndonna
    12-04-2020, 09:33 AM Go to last post

  35. Formula for budgeting from lowest cost unit

    Started by ttch‎, 12-03-2020 03:21 PM
    formula, macro, vba 3 Attachment(s)
    • 1
    • 361
    XLent
    12-04-2020, 08:19 AM Go to last post

  36. Question [SOLVED] Find the earliest occurence (date & time) and the corresponding category

    Started by Adelka‎, 12-04-2020 07:29 AM
    time and date formulas 2 Attachment(s)
    • 5
    • 334
    Glenn Kennedy
    12-04-2020, 07:52 AM Go to last post

  37. [SOLVED] Count cells with a condition

    Started by baxius‎, 12-04-2020 06:11 AM
    3 Attachment(s)
    • 3
    • 220
    baxius
    12-04-2020, 06:34 AM Go to last post

  38. Highlight cells if combined exceeds certain threshold set in another table

    Started by Linvin‎, 11-30-2020 02:14 AM
    conditional formatting, countif, formula 2 Attachment(s)
    • 7
    • 568
    Crooza
    12-04-2020, 03:06 AM Go to last post

  39. Unique Identifers in Names?

    Started by excellenthelp‎, 12-03-2020 08:05 PM
    • 3
    • 262
    AliGW
    12-04-2020, 02:05 AM Go to last post

  40. Index Match Dynamic Lookup

    Started by rhbnewbie‎, 11-19-2020 01:15 AM
    2 Attachment(s)
    • 3
    • 452
    jplasen
    12-04-2020, 12:38 AM Go to last post

  41. How to programmatically select a range

    Started by ekaunt‎, 12-03-2020 11:59 PM
    automatic, range, sum 3 Attachment(s)
    • 1
    • 444
    protonLeah
    12-04-2020, 12:17 AM Go to last post

  42. [SOLVED] Need to do a multiple chart reference formula

    Started by Butcher1‎, 12-03-2020 08:59 PM
    2 Attachment(s)
    • 2
    • 263
    Butcher1
    12-03-2020, 11:22 PM Go to last post

  43. Define cell's function via another cell

    Started by scbunker‎, 12-03-2020 10:19 PM
    • 3
    • 250
    scbunker
    12-03-2020, 11:19 PM Go to last post

  44. Identical Cell values not counting in Sumif formula

    Started by USGrant‎, 12-01-2020 02:20 PM
    cell values
    • 4
    • 347
    USGrant
    12-03-2020, 11:06 PM Go to last post

  45. HLOOKUP that skips blank/zero cells in lookup range

    Started by nwatson1‎, 12-03-2020 10:42 PM
    1 Attachment(s)
    • 1
    • 256
    bebo021999
    12-03-2020, 10:45 PM Go to last post

  46. Help to tweek a simple formula

    Started by Thunder001‎, 12-03-2020 11:44 AM
    • 3
    • 288
    Pete_UK
    12-03-2020, 10:20 PM Go to last post

  47. Custom URL's from Data in a Spreadsheet

    Started by jclaborn‎, 12-03-2020 08:31 PM
    1 Attachment(s)
    • 1
    • 240
    alansidman
    12-03-2020, 10:19 PM Go to last post

  48. [SOLVED] Powerquery data extraction from website question

    Started by Doofus1‎, 11-26-2020 09:20 PM
    9 Attachment(s)
    • 20
    • 853
    alansidman
    12-03-2020, 10:10 PM Go to last post

  49. Sort by Latitude and Longitude

    Started by mikey.snodgrass‎, 11-30-2020 02:31 PM
    2 Attachment(s)
    • 3
    • 750
    JeteMc
    12-03-2020, 09:28 PM Go to last post

  50. Convert text date to Excel format

    Started by MiteshChuahan‎, 12-03-2020 12:40 PM
    • 2
    • 353
    MiteshChuahan
    12-03-2020, 07:05 PM Go to last post
+ Post New Thread
Page 591 of 5614 FirstFirst ... 591 ...

Forum Information and Options

Users Browsing this Forum

There are currently 44 users browsing this forum. (1 members & 43 guests)

  1. XLalan

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